On Saturday 22 February 2003 22:48, Bruce Feist wrote:
> I'm a newcomer to MySQL, and I'm having trouble. I've installed MySQL
> under RedHat 7.1 Linux, and I can't actually use it; I get authorization
> error messages when I try. In particular, I understand that initially a
> 'root' user is set up without a password. I can't connect to the
> database as 'root' with:
>
> mysql -u root mysql
>
> but I get "access denied" messages. I tried wiping out the security
> data and recreating it with:
>
> mysql_install_db
>
> but that didn't seem to improve matters.
>
> Any ideas of what I'm doing wrong?
Seems 'root' already has a password :)
If you already have privilege table mysql_install_db doesn't recreate them.
You must remove old privilege table at first and then create new or you can
start MySQL server with --skip-grant-tables option:
http://www.mysql.com/doc/en/Resetting_permissions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [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
