Tewfic, Monday, April 22, 2002, 10:07:06 PM, you wrote: >> Hello, i'm having a problem accessing mysql database. I don't recall >> setting a password for root, but when i try to set that password. This is >> happening right after i run mysql_install_db >> >> [root@omsrh etc]# mysql -u root -p >> Enter password:********** >> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
If you didn't set password, you don't have to use '-p' option for connection. If you want to set password, please, chaeck the following link: http://www.mysql.com/doc/P/a/Passwords.html >> [root@omsrh etc]# mysql >> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) It means that anonymous user doesn't have any privileges ... Unix 'root' user and 'root' user in MySQL are different ... >> I was able access Mysql not being root, but couldn't get access to 'mysql' >> database to change user options and all. >> >> When accessing mysql as a user, I am unable to create databases. >> >> >> When using skip-grant-table i get ... >> >> [root@omsrh etc]# mysql -u root >> mysql: unrecognized option `--skip-grant-table' Use "--skip-grant-tables" option, not "--skip-grant-table" ... >> Your help will be greatly appreciated. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php