<tlr7425,
Thursday, June 27, 2002, 9:39:33 AM, you wrote:
t> I've been scowering (sp?) the docs but I can't get past:
t> mysql> use mysql;
t> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
t> This happens under any condition where access is needed.
t> It is after I have done mysql_install_db and chown and there is a user
t> "mysql".
t> It doesn't matter how I try to connect, which user, etc., I get the same
t> result.
Was there grant tables before running mysql_install_db? Is so,
mysql_install_db doesn't re-create tables. In this case try to connect
with your old user/password.
If you install MySQL for the first time, connect as a 'root' without a
password.
t> If I try to setup the ROOT password I get the same sort of denial.
Seems, your user doesn't have permissions on the database 'mysql'
t> Perhaps it has something to do with my host name or maybe a conf (cf) file
t> somewhere that I have no idea of that is set wrongly.
t> Please help me if you can.
End of all, you can start mysqld with --skip-grant-tables option and
set up privileges for your users:
http://www.mysql.com/doc/R/e/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
