RE: Re: Re: Access denied @locahost
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: >> > 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
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: >> > 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
Re: Access denied @locahost
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
Re: Access denied @locahost
have you run the "grant" command? this adds users SEPERATE from your unix user list. - Original Message - From: <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 2:39 PM Subject: Access denied @locahost I've been scowering (sp?) the docs but I can't get past: mysql> use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql> This happens under any condition where access is needed. It is after I have done mysql_install_db and chown and there is a user "mysql". It doesn't matter how I try to connect, which user, etc., I get the same result. If I try to setup the ROOT password I get the same sort of denial. Perhaps it has something to do with my host name or maybe a conf (cf) file somewhere that I have no idea of that is set wrongly. Please help me if you can. Ll (Mac OS X) (MySQL 3.23.51) - 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