Re: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
c s wrote: Dear friends, I have a question about mysql. I installed mysql on windows 2000, after I started the mysql, I tried to create a database, but I was denied, I got message: mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql CREATE DATABASE menagerie; ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' You did not start mysql as root. mysql -u root I have read the documentation again and again, it show I can create a host file, but ite does not say what kind file it is and where I should put it. How can I fix it? Read the section of the manual on permissions. Thank you for your help Luke Sui - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1044: Access denied for user
It means you don't have enough privileges to access 'mysql' database. You can add these privileges using GRANT command under user 'root' (or under another superuser). Check manual, the section about privileges. anjani.sinha wrote: Hi all, I am getting the error when trying to connect server from my client: ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database 'mysql' any answer? thanks, anjani - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: ERROR 1044: Access denied
ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk - 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: ERROR 1044: Access denied
- Original Message - From: Dana Powers [EMAIL PROTECTED] To: Pierre-Yves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 1:22 AM Subject: Re: ERROR 1044: Access denied ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk but I use the following command to connect mysql : mysql --user=user2 --host=localhost (there is no password for this user) and when I do this with the user1 it is working... so i don't think that's the problem. - 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: ERROR 1044: Access denied
The way mysql access tables work, if it cant find a user named 'user2', it will default to the blank user ( '' ). dpk - Original Message - From: Pierre-Yves [EMAIL PROTECTED] To: Dana Powers [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 4:39 PM Subject: Re: ERROR 1044: Access denied - Original Message - From: Dana Powers [EMAIL PROTECTED] To: Pierre-Yves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 1:22 AM Subject: Re: ERROR 1044: Access denied ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk but I use the following command to connect mysql : mysql --user=user2 --host=localhost (there is no password for this user) and when I do this with the user1 it is working... so i don't think that's the problem. - 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