ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
Howdy all, I keep getting this error when I try to issue: mysql mysql -u root -p the same thing happens when I substitute any other database name, not just mysql. I have another,nearly identical machine from which I copied the contents of /var/lib/mysql/mysql/ . The permissions all appear to be fine. This is a new problem, it started after I changed the firewall settings to activate port 3306.. don't know if that's what caused this somehow. Oddly enough, I can access the database from a remote machine with no problem. Any help would be much appreciated. sam -- 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: '@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]
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
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' 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? Thank you for your help Luke Sui - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger
ERROR 1044: Access denied after upgrade to MySQL 4.0.11a-gamma
I have an application that has stopped working after the ISP upgraded from MySQL 3.23.36 to MySQL 4.0.11a-gamma-log All I'm told is: ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'jomaridb' This is a commercial server so I have no access to the mySQL install. I'd appreciate help in how to troubleshooting the likely cause of the ERROR 1044. This application was working flawlessly prior to the "upgrade." John Hughes - 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 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
ERROR 1044: Access denied for user
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
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
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
> 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
ERROR 1044: Access denied
Hello, I have a problem with the access : I have created 2 users with no privileges in the user table (privileges are set in the db table, so those users can only access one particular db). the first user has all the privileges set to Y for the db "hello", this user works fine. the second user has exactly the same config as the first one, but with less privileges : only the Select_priv, Insert_priv, Update_priv and Delete_priv set to 'Y' for the db "hello". I can connect my sql with that user, but I can't use the db hello : mysql> use hello ERROR 1044: Access denied for user: '@localhost' to database 'hello' mysql> I'm surprised to have this error message... do I have to set a particular privilege to 'Y' in order to allow this user to connect to the db ??? Table db : HostDbUserSelect_privInsert_privUpdate_privDelete_privCreate_privDrop_privGr ant_privReferences_privIndex_privAlter_priv localhosthellouser2NN localhosthellouser1YY Thanks for your help ! - 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
