Just jumping in here so take this info accordingly.
Do you have root access to this machine?
If so, try restarting with --skip-grant-tables and set up your perm
scheme.
Look into mysqlaccess what does it say for root localhost ?
You can also replace user, host, db with '%' to see all possibilities.
Check man page; I may have messed up the ordering of the three.
It's also good to post your sql version since some syntax changes for
specific commands.
Read man pages carefully since user -p pass user -ppass and user
--password= aren't the same.
Do a search for grant on the mysql man pages.
Once you've got that straight you might want to save credentials in
/root/.my.cnf and probably delete that anonymous account. There's a
syntax tip for that on linuxsecurity.com
justin
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 3:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Re: Re: Access denied @locahost
Hello tlr7425,
Thursday, June 27, 2002, 12:29:10 PM, you wrote:
Please, don't write me. Send your question in the mail-list.
tgafe mysql will start and it is running and i can get the prompt:
mysql
tgafe but i can't do anything from there except to quit;
tgafe ?
You didn't answered my question...
Did you installed MySQL for the first time? If so, by default MySQL has
user 'root' (without a password) with full privileges and anonymous
user that has access only to the database 'test'.
Have you tried to connect as user 'root' without a password, i.e
mysql -uroot
?
tgafe on 6/27/02 4:44 AM, Egor Egorov, typed:
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
-
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
