access denied fpr user 'root'@'localhost' (using password: NO)
I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') how can I restore the db so I can connect through command line again ? thks
Re: access denied fpr user 'root'@'localhost' (using password: NO)
Am 29.05.2014 20:22, schrieb Érico: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') your command line is plain wrong as you can see in the response you are *not* using a password ./mysqladmin -u root --password=pwd *don't do that at all* your password ends in the history ./mysqladmin -u root -p after that you get a pwd-prompt how can I restore the db so I can connect through command line again ? if you really need to login with a destroyed userdb make sure that nobody else can access the server and use skip grant http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables signature.asc Description: OpenPGP digital signature
Re: access denied fpr user 'root'@'localhost' (using password: NO)
Did you tried this.. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html *thanks,* *-- *Kishore Kumar Vaishnav On Thu, May 29, 2014 at 11:22 AM, Érico erico...@gmail.com wrote: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') how can I restore the db so I can connect through command line again ? thks
Re: access denied fpr user 'root'@'localhost' (using password: NO)
Hi thanks but it is not working either I wonder if the 2 rows I removed (with empty users for localhost and my computer names) were responsilbe for allowing the autentication ? how this table works ? what mysql checks on it ? the pwd column ? if it is filled ? what if I have 2 records for root/localhost ... ? one with pwd filled and the second with the pwd empty how can I insert on this table with the mandatory column ssl_cipher as blob ... ? what value must I provide in a insert like : insert into mysql.user(host,user,ssl_cipher) values('localhost','root' , ??? ) thks !! 2014-05-29 15:36 GMT-03:00 Kishore Vaishnav kish...@railsfactory.org: Did you tried this.. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html *thanks,* *-- *Kishore Kumar Vaishnav On Thu, May 29, 2014 at 11:22 AM, Érico erico...@gmail.com wrote: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') how can I restore the db so I can connect through command line again ? thks
Re: access denied fpr user 'root'@'localhost' (using password: NO)
running this : ./mysqladmin -u root -p at this momento it thorws me to mysqladmin man page 2014-05-29 15:35 GMT-03:00 Reindl Harald h.rei...@thelounge.net: Am 29.05.2014 20:22, schrieb Érico: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') your command line is plain wrong as you can see in the response you are *not* using a password ./mysqladmin -u root --password=pwd *don't do that at all* your password ends in the history ./mysqladmin -u root -p after that you get a pwd-prompt how can I restore the db so I can connect through command line again ? if you really need to login with a destroyed userdb make sure that nobody else can access the server and use skip grant http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables
Re: access denied fpr user 'root'@'localhost' (using password: NO)
well, i am mysql administrator over 10 years now and never needed the mysqladmin command because the mysql command line client offers anything i ever needed mysql -u root -p [harry@srv-rhsoft:~]$ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 16056 Server version: 5.5.37-MariaDB-log thelounge Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)] Am 29.05.2014 21:19, schrieb Érico: running this : ./mysqladmin -u root -p at this momento it thorws me to mysqladmin man page 2014-05-29 15:35 GMT-03:00 Reindl Harald h.rei...@thelounge.net: Am 29.05.2014 20:22, schrieb Érico: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') your command line is plain wrong as you can see in the response you are *not* using a password ./mysqladmin -u root --password=pwd *don't do that at all* your password ends in the history ./mysqladmin -u root -p after that you get a pwd-prompt how can I restore the db so I can connect through command line again ? if you really need to login with a destroyed userdb make sure that nobody else can access the server and use skip grant http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables signature.asc Description: OpenPGP digital signature
Re: access denied fpr user 'root'@'localhost' (using password: NO)
Hello Érico On 5/29/2014 2:22 PM, Érico wrote: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') how can I restore the db so I can connect through command line again ? thks What that tells me is that you were never actually logging in as root but the system was authenticating you as the 'anonymous' user. Quoting from the very fine manual: http://dev.mysql.com/doc/refman/5.6/en/account-names.html A user name is either a nonblank value that literally matches the user name for incoming connection attempts, or a blank value (empty string) that matches any user name. An account with a blank user name is an anonymous user. To specify an anonymous user in SQL statements, use a quoted empty user name part, such as ''@'localhost'. http://dev.mysql.com/doc/refman/5.6/en/connection-access.html Identity checking is performed using the three user table scope columns (Host, User, and Password). The server accepts the connection only if the Host and User columns in some user table row match the client host name and user name and the client supplies the password specified in that row. ... If the User column value is nonblank, the user name in an incoming connection must match exactly. If the User value is blank, it matches any user name. If the user table row that matches an incoming connection has a blank user name, the user is considered to be an anonymous user with no name, not a user with the name that the client actually specified. This means that a blank user name is used for all further access checking for the duration of the connection (that is, during Stage 2). ... If you are able to connect to the server, but your privileges are not what you expect, you probably are being authenticated as some other account. To find out what account the server used to authenticate you, use the CURRENT_USER() function. That same page in the manual (and its siblings) should also answer your questions as to how MySQL uses the `user` table, what the empty `user` and `password` column mean to login attempts, and how to configure SSL-based connections. If you have forgotten your actual root@localhost password, you can reset it following one of the procedures provided here. http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html Yours, -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: access denied fpr user 'root'@'localhost' (using password: NO)
I am really sorry about this one .. the connection is ok ... I had not checked that I was using mysqladmin instead of mysql now please how can I check what is wrong with my application ( My SQL Admin ) at its login page it asks for user / pwd / server and db using both localhost and 127.0.01 ... it gets the same error : access denied for user 'root'@'localhost' the app has a php config page where it fills these info I am able to connect to it manually too using : ./mysql -h localhost -u root -pmy_pwd mysql-admin but the app keeps geting the access denied error would it be sometihng related to my /et/hosts ? its content : 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost fe80::1%lo0 localhost 127.0.0.1 mysqld 127.0.0.1 mac localhost mac my SO is a mac os 10.6.8 Thks Again !! 2014-05-29 16:26 GMT-03:00 Reindl Harald h.rei...@thelounge.net: well, i am mysql administrator over 10 years now and never needed the mysqladmin command because the mysql command line client offers anything i ever needed mysql -u root -p [harry@srv-rhsoft:~]$ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 16056 Server version: 5.5.37-MariaDB-log thelounge Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)] Am 29.05.2014 21:19, schrieb Érico: running this : ./mysqladmin -u root -p at this momento it thorws me to mysqladmin man page 2014-05-29 15:35 GMT-03:00 Reindl Harald h.rei...@thelounge.net: Am 29.05.2014 20:22, schrieb Érico: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') your command line is plain wrong as you can see in the response you are *not* using a password ./mysqladmin -u root --password=pwd *don't do that at all* your password ends in the history ./mysqladmin -u root -p after that you get a pwd-prompt how can I restore the db so I can connect through command line again ? if you really need to login with a destroyed userdb make sure that nobody else can access the server and use skip grant http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables
Re: access denied fpr user 'root'@'localhost' (using password: NO)
Hello Érico, On 5/29/2014 3:51 PM, Érico wrote: I am really sorry about this one .. the connection is ok ... I had not checked that I was using mysqladmin instead of mysql now please how can I check what is wrong with my application ( My SQL Admin ) at its login page it asks for user / pwd / server and db using both localhost and 127.0.01 ... it gets the same error : access denied for user 'root'@'localhost' the app has a php config page where it fills these info I am able to connect to it manually too using : ./mysql -h localhost -u root -pmy_pwd mysql-admin but the app keeps geting the access denied error would it be sometihng related to my /et/hosts ? its content : 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost fe80::1%lo0 localhost 127.0.0.1 mysqld 127.0.0.1 mac localhost mac my SO is a mac os 10.6.8 Thks Again !! ... snip ... What is the result of this query: SELECT user, host, length(password) from mysql.user; What hapens if you change your login to this? (you should not put your passwords on your command lines if you can avoid it http://dev.mysql.com/doc/refman/5.6/en/password-security-user.html http://dev.mysql.com/doc/refman/5.6/en/connecting.html ) ./mysql -h 127.0.01 --port=3306 --protocol=TCP -u root -p mysql-admin See also: http://dev.mysql.com/doc/refman/5.6/en/access-denied.html -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql Access denied error
Edward , use following way mysql -uroot -p -h{host ip } else give grant privileges to localhost On Mon, May 5, 2014 at 7:47 AM, EdwardKing zhan...@neusoft.com wrote: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows: [hadoop@master ~]$ mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.37-log MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql create database hadooptest; mysql grant all on hadooptest.* to 'hadoopuser'@'%' identified by '123456'; Query OK, 0 rows affected (0.00 sec) mysql flush priviledges; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'priviledges' at line 1 mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql quit; Bye Then I use hadoopuser with password 123456 [hadoop@master ~]$ mysql -u hadoopuser -p Enter password: ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using password: YES) --- Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s) is intended only for the use of the intended recipient and may be confidential and/or privileged of Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of this communication is not the intended recipient, unauthorized use, forwarding, printing, storing, disclosure or copying is strictly prohibited, and may be unlawful.If you have received this communication in error,please immediately notify the sender by return e-mail, and delete the original message and all copies from your system. Thank you. ---
Re: mysql Access denied error
2014-05-05 4:17 GMT+02:00 EdwardKing zhan...@neusoft.com: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows: [hadoop@master ~]$ mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.37-log MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql create database hadooptest; mysql grant all on hadooptest.* to 'hadoopuser'@'%' identified by '123456'; Query OK, 0 rows affected (0.00 sec) mysql flush priviledges; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'priviledges' at line 1 mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql quit; Bye Then I use hadoopuser with password 123456 [hadoop@master ~]$ mysql -u hadoopuser -p Enter password: ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using password: YES) Hello, I assume MySQL is listening in 3306 so: Try this: mysql -u hadoopuser -plocalhost (or 127.0.0.1) % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% Hope this helps Manuel.
Re: mysql Access denied error
Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% nonsense % matches *any host* signature.asc Description: OpenPGP digital signature
Re: mysql Access denied error
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% nonsense % matches *any host* Do the test yourself.
Re: mysql Access denied error
Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% nonsense % matches *any host* Do the test yourself i don't need to test such basics since i am working as mysql administrator the last 11 years and curently responsible for some hundret databases heavily using host specific permissions http://dev.mysql.com/doc/refman/5.5/en/connection-access.html '%' 'fred' fred, connecting from any host signature.asc Description: OpenPGP digital signature
Re: mysql Access denied error
2014-05-05 10:57 GMT+02:00 Reindl Harald h.rei...@thelounge.net: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.netmailto: h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% nonsense % matches *any host* Do the test yourself i don't need to test such basics since i am working as mysql administrator the last 11 years and curently responsible for some hundret databases heavily using host specific permissions Good for you. I might be working somewhere bigger than that. Here is what I am talking about: mysql grant all on hadooptest.* to 'hadoopuser'@'%' identified by '123456'; flush privileges; Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) mysql # mysql -uhadoopuser -p123456 ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using password: YES) # mysql -uhadoopuser -p123456 -hlocalhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 392245 snip --- mysql drop user 'hadoopuser'@'%'; flush privileges; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql grant all on hadooptest.* to 'hadoopuser'@'localhost' identified by '123456'; flush privileges; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) # mysql -uhadoopuser -p123456 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 392191 snip I have been reading your impoliteness in this list for years. You are well known in this (and other) lists for being like that. So I am not going to start a fight over the list and this will be my last message in this thread. Hopefully I have helped the original poster with my point. Good luck with your hundreds of databases. Manuel.
Re: mysql Access denied error
Hi, On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% nonsense % matches *any host* Do the test yourself i don't need to test such basics since i am working as mysql administrator the last 11 years and curently responsible for some hundret databases heavily using host specific permissions http://dev.mysql.com/doc/refman/5.5/en/connection-access.html '%' 'fred' fred, connecting from any host In that case you would know that connecting via a Unix socket is not the same as connection via a network. See: http://bugs.mysql.com/bug.php?id=69570 http://dev.mysql.com/doc/refman/5.5/en/connecting.html -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql Access denied error
Am 05.05.2014 11:12, schrieb Jigal van Hemert: On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% nonsense % matches *any host* Do the test yourself i don't need to test such basics since i am working as mysql administrator the last 11 years and curently responsible for some hundret databases heavily using host specific permissions http://dev.mysql.com/doc/refman/5.5/en/connection-access.html '%''fred'fred, connecting from any host In that case you would know that connecting via a Unix socket is not the same as connection via a network. See: http://bugs.mysql.com/bug.php?id=69570 http://dev.mysql.com/doc/refman/5.5/en/connecting.html i know that, but it does not change the fact that here are mysql users in production which are using % and accessed via localhost unix-socket as well as via TCP from remote-machines with mysql-over-ssl maybe MariaDB don't have that bug and it is a bug if you can't connect with a user specified with % over the unix-socket independent what some guy from Oracle pretends signature.asc Description: OpenPGP digital signature
Re: mysql Access denied error
- Original Message - From: Reindl Harald h.rei...@thelounge.net i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the second scenario, I can only wonder what you're doing on this list. -- Unhappiness is discouraged and will be corrected with kitten pictures.
Re: mysql Access denied error
Am 05.05.2014 15:26, schrieb Johan De Meersman: - Original Message - From: Reindl Harald h.rei...@thelounge.net i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the second scenario, I can only wonder what you're doing on this list oh, did your off-list message find it's way to the list the answer remains the same * i did know that about 10 years now * i have % instead localhost in use here for users * these users just work with unix-socket / localhost * period understand that i speak about living and working setups in front of me and not about theory signature.asc Description: OpenPGP digital signature
Re: mysql Access denied error
On 2014-05-04 9:17 PM, EdwardKing wrote: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. The command sequence ... mysql create database hadooptest; mysql grant all on hadooptest.* to 'hadoopuser'@'%' identified by '123456'; mysql quit; mysql -u hadoopuser -p Enter password: works fine, so your problem is due to something other than these commands, possibly other entries in the mysql.user or mysql.db table. PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
mysql Access denied error
I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows: [hadoop@master ~]$ mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.37-log MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql create database hadooptest; mysql grant all on hadooptest.* to 'hadoopuser'@'%' identified by '123456'; Query OK, 0 rows affected (0.00 sec) mysql flush priviledges; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'priviledges' at line 1 mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql quit; Bye Then I use hadoopuser with password 123456 [hadoop@master ~]$ mysql -u hadoopuser -p Enter password: ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using password: YES) --- Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s) is intended only for the use of the intended recipient and may be confidential and/or privileged of Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of this communication is not the intended recipient, unauthorized use, forwarding, printing, storing, disclosure or copying is strictly prohibited, and may be unlawful.If you have received this communication in error,please immediately notify the sender by return e-mail, and delete the original message and all copies from your system. Thank you. ---
[5.1 Vs 5.5 ] ERROR 1045 (28000): Access denied for user 'testuser'@'Serv1.corp.domain.in' (using password: YES)
Hi, I am trying to connect two mysql servers with different versions ( 5.1 5.5 ) . But in Mysql 5.1 i am facing strange issues. Below testuser exists in both Mysql Versions : mysql select host,user,password from mysql.user where user='testuser'; +---++---+ | host | user | password | +---++---+ | localhost | testuser | *FJHHEU5746DDHDUDYDH66488 | | %.corp.domain.in| testuser | *FJHHEU5746DDHDUDYDH66488 | +---++---+ and skip_networking is OFF *Mysql Version : 5.1.58-log* root@Serv1:~# mysql -utestuser -p@8AsnM0! -h $(hostname) ERROR 1045 (28000): Access denied for user 'testuser'@'Serv1.corp.domain.in' (using password: YES) It connect successfully if i remove -h option because it connects by localhost then *Mysql version : 5.5.36-log * root@Serv2:~# mysql -utestuser -p@8AsnM0! -h $(hostname) Welcome to the MySQL monitor. Commands end with ; or \g. Server version: 5.5.36-log MySQL Community Server (GPL) mysql mysql select user(),current_user(); +--+---+ | user() | current_user()| +--+---+ | testu...@serv2.corp.domain.in| testuser@%.corp.domain.in | +--+---+ Is dere some bug in Mysql5.1 or i need to set bind_address parameter in it. Thanks
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
ok I have tried these : ifconfig -a lo0: flags=8049UP,LOOPBACK,RUNNING,MULTICAST mtu 16384 inet6 ::1 prefixlen 128 inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 inet 127.0.0.1 netmask 0xff00 gif0: flags=8010POINTOPOINT,MULTICAST mtu 1280 stf0: flags=0 mtu 1280 fw0: flags=8863UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST mtu 4078 lladdr 70:cd:60:ff:fe:eb:72:ea media: autoselect full-duplex status: inactive en1: flags=8863UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST mtu 1500 ether e4:ce:8f:04:7c:f8 inet6 fe80::e6ce:8fff:fe04:7cf8%en1 prefixlen 64 scopeid 0x5 inet 169.254.99.150 netmask 0x broadcast 169.254.255.255 media: autoselect status: active en0: flags=8863UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST mtu 1500 ether c8:2a:14:1a:47:ea media: autoselect (none) status: inactive wc2: flags=822BROADCAST,SMART,SIMPLEX mtu 1500 ether 00:02:55:11:19:76 media: 1000baseT (unknown type) = mac:bin ericomtx$ nslookup localhost ;; connection timed out; no servers could be reached = mac:bin ericomtx$ netstat -an | grep 3306 tcp46 0 0 *.3306 *.*LISTEN tcp4 0 0 *.3306 *.*LISTEN = mac:bin ericomtx$ netstat -ln | grep mysql ff801403c280 stream 0 00 ff801403b20000 /tmp/mysql.sock ff801403a9c0 stream 0 0 ff801bbb78b8 000 /tmp/mysql.sock ff8013fb0bc0 stream 0 0 ff8014aa8078 000 /opt/local/var/run/mysql5/mysqld.sock *** here ... this last one is related to a previous mysql macports version *** = mac:lib ericomtx$ ps xa | grep mysqld 231 ?? S 0:00.01 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe --datadir=/opt/local/var/db/mysql5 --pid-file=/opt/local/var/db/mysql5/mac.local.pid 295 ?? S 0:00.74 /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=_mysql --log-error=/opt/local/var/db/mysql5/mac.local.err --pid-file=/opt/local/var/db/mysql5/mac.local.pid --socket=/opt/local/var/run/mysql5/mysqld.sock 2175 s000 S 0:00.02 /bin/sh /Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/bin/mysqld_safe --datadir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data --pid-file=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.pid 2273 s000 S 0:00.35 /Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/bin/mysqld --basedir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86 --datadir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data --plugin-dir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/lib/plugin --user=mysql --log-error=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.err --pid-file=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.pid = I have uninstalled everything related to mysql ports these dirs no longer exist : /opt/local/lib/mysql5 /opt/local/libexec I don't know from where they are getting called 2014/1/15 Claudio Nanni claudio.na...@gmail.com Hi | | ericomtxmacbookpro.local | *E85DC00A0137C6171923BE35EDD809573FB3AB4F | mysql DELETE FROM mysql.user WHERE user=''; mysql FLUSH PRIVILEGES; maybe helps? Cheers -- Claudio
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
Hi | | ericomtxmacbookpro.local | *E85DC00A0137C6171923BE35EDD809573FB3AB4F | mysql DELETE FROM mysql.user WHERE user=''; mysql FLUSH PRIVILEGES; maybe helps? Cheers -- Claudio
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
yes it is ... also , the eclipse is also local ... in both ... mysql-admin php application , plus inside eclispe plugin ... same behavior in both 2014/1/13 Reindl Harald h.rei...@thelounge.net i doubt that the webserver is running on the same machine as your mysql command shell Am 13.01.2014 23:59, schrieb Érico: true but please check this out : mysql Select user, host, password from mysql.user; +--+--+---+ | user | host | password | +--+--+---+ | root | localhost| *E85DC00A0137C6171923BE35EDD809573FB3AB4F | | root | ericomtxmacbookpro.local | *E85DC00A0137C6171923BE35EDD809573FB3AB4F | | root | 127.0.0.1| *E85DC00A0137C6171923BE35EDD809573FB3AB4F | | root | ::1 | | | | ericomtxmacbookpro.local | *E85DC00A0137C6171923BE35EDD809573FB3AB4F | +--+--+---+ 5 rows in set (0.00 sec) all passwords are filled in the db ... also ... I can connect through command line what I can't do is : 1. connect or even ping inside eclipse using jconnector 2. connect from a php app (mysql adim) with or with out pwd ... providing the error Access denied for user 'root'@'localhost' (using password: YES) Access denied for user 'root'@'localhost' (using password: NO) 2.1 when I use 127.0.0.1 on mysql admin url ... I get a connection closed so ... my point is : in both cases when using 127.0.0.1 or localhost ... can the OS be blocking the connection ? if so , how could I check this ? Regards Érico 2014/1/13 Reindl Harald h.rei...@thelounge.net mailto: h.rei...@thelounge.net WTF - we are talking about *database connections* and *not* http-URL's the webserver is only the *messenger* Am 13.01.2014 18:54, schrieb Érico: using both urls I get the same error : http://localhost/mysql/index.php http://127.0.0.1/mysql/index.php in 127.0.0.1... after I submit the index.php ... it redirects to localhost too .. 2014/1/13 Reindl Harald h.rei...@thelounge.net mailto: h.rei...@thelounge.net Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 mailto:root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1 http://127.0.0.1: TCP -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development m: +43 (676) 40 221 40, p: +43 (1) 595 3999 33 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
Hi I have installed mysql admin on my local environment I am able to connect to mysql through command line : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql ... but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen ? I am starting it this way : sudo ./mysql.server start my /etc/hosts file : ## # Host Database # # localhost is used to configure the loopback interface # when the system is booting. Do not change this entry. ## 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost #fe80::1%lo0localhost 127.0.0.1 ericomtxmacbookpro.local 127.0.0.1 mysqld Thks Érico
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP signature.asc Description: OpenPGP digital signature
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
From that error I would suspect you are trying to access to a database where has not external access. And yeah, try by doing $ mysql -u root -p database -h localhost -P 3306 change localhost by 127.0.0.1 in order to test if both cases work, and see which of them (localhost/127.0.0.1) is defined in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote: Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
using both urls I get the same error : http://localhost/mysql/index.php http://127.0.0.1/mysql/index.php in 127.0.0.1... after I submit the index.php ... it redirects to localhost too .. 2014/1/13 Reindl Harald h.rei...@thelounge.net Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
using localhost the coonection works ... ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost -P 3306 Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 97 Server version: 5.6.15 MySQL Community Server (GPL) but using 127.0.0.1 no : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1 -P 3306 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ericomtxmacbookpro:bin ericomtx$ 2014/1/13 Erick Ocrospoma zipper1...@gmail.com From that error I would suspect you are trying to access to a database where has not external access. And yeah, try by doing $ mysql -u root -p database -h localhost -P 3306 change localhost by 127.0.0.1 in order to test if both cases work, and see which of them (localhost/127.0.0.1) is defined in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote: Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
I presume your index.php file uses 127.0.0.1. After login to MySQL try this: $ grant all privileges to *.* 'root'@'127.0.0.1' identified by yourpassword; Of course this could not be the best solution, it's just to skip it, you must look at the query/connection on your php file. On 13 January 2014 12:57, Érico erico...@gmail.com wrote: using localhost the coonection works ... ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost -P 3306 Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 97 Server version: 5.6.15 MySQL Community Server (GPL) but using 127.0.0.1 no : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1 -P 3306 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ericomtxmacbookpro:bin ericomtx$ 2014/1/13 Erick Ocrospoma zipper1...@gmail.com From that error I would suspect you are trying to access to a database where has not external access. And yeah, try by doing $ mysql -u root -p database -h localhost -P 3306 change localhost by 127.0.0.1 in order to test if both cases work, and see which of them (localhost/127.0.0.1) is defined in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote: Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
I forgot this. Do it too. On 13 January 2014 13:01, Erick Ocrospoma zipper1...@gmail.com wrote: I presume your index.php file uses 127.0.0.1. After login to MySQL try this: $ grant all privileges to *.* 'root'@'127.0.0.1' identified by yourpassword; $ flush privileges; Of course this could not be the best solution, it's just to skip it, you must look at the query/connection on your php file. On 13 January 2014 12:57, Érico erico...@gmail.com wrote: using localhost the coonection works ... ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost -P 3306 Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 97 Server version: 5.6.15 MySQL Community Server (GPL) but using 127.0.0.1 no : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1 -P 3306 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ericomtxmacbookpro:bin ericomtx$ 2014/1/13 Erick Ocrospoma zipper1...@gmail.com From that error I would suspect you are trying to access to a database where has not external access. And yeah, try by doing $ mysql -u root -p database -h localhost -P 3306 change localhost by 127.0.0.1 in order to test if both cases work, and see which of them (localhost/127.0.0.1) is defined in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote: Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
the granting is not affecting the tables: mysql grant all privileges on *.* to root@localhost identified by 'pwd'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) ... and if I try the granting in 127.0.0.1 : mysql grant all privileges to *.* 'root'@'127.0.0.1' identified by kernel26; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to *.* 'root'@'127.0.0.1' identified by kernel26' at line 1 ... in eclipse using jconnector ... I get the same error : when pinging : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) Could not connect to New MySQL. Error creating SQL Model Connection connection to New MySQL. (Error: Access denied for user 'root'@'localhost' (using password: YES)) Access denied for user 'root'@'localhost' (using password: YES) 2014/1/13 Erick Ocrospoma zipper1...@gmail.com I forgot this. Do it too. On 13 January 2014 13:01, Erick Ocrospoma zipper1...@gmail.com wrote: I presume your index.php file uses 127.0.0.1. After login to MySQL try this: $ grant all privileges to *.* 'root'@'127.0.0.1' identified by yourpassword; $ flush privileges; Of course this could not be the best solution, it's just to skip it, you must look at the query/connection on your php file. On 13 January 2014 12:57, Érico erico...@gmail.com wrote: using localhost the coonection works ... ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost -P 3306 Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 97 Server version: 5.6.15 MySQL Community Server (GPL) but using 127.0.0.1 no : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1 -P 3306 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ericomtxmacbookpro:bin ericomtx$ 2014/1/13 Erick Ocrospoma zipper1...@gmail.com From that error I would suspect you are trying to access to a database where has not external access. And yeah, try by doing $ mysql -u root -p database -h localhost -P 3306 change localhost by 127.0.0.1 in order to test if both cases work, and see which of them (localhost/127.0.0.1) is defined in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote: Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
On 13 January 2014 13:25, Érico erico...@gmail.com wrote: the granting is not affecting the tables: mysql grant all privileges on *.* to root@localhost identified by 'pwd'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) ... and if I try the granting in 127.0.0.1 : mysql grant all privileges to *.* 'root'@'127.0.0.1' identified by kernel26; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to *.* 'root'@'127.0.0.1' identified by kernel26' at line 1 It's my error :) It should be: mysql grant all privileges on *.* to 'root'@'127.0.0.1' identified by 'kernel26'; ... in eclipse using jconnector ... I get the same error : when pinging : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) Could not connect to New MySQL. Error creating SQL Model Connection connection to New MySQL. (Error: Access denied for user 'root'@'localhost' (using password: YES)) Access denied for user 'root'@'localhost' (using password: YES) 2014/1/13 Erick Ocrospoma zipper1...@gmail.com I forgot this. Do it too. On 13 January 2014 13:01, Erick Ocrospoma zipper1...@gmail.com wrote: I presume your index.php file uses 127.0.0.1. After login to MySQL try this: $ grant all privileges to *.* 'root'@'127.0.0.1' identified by yourpassword; $ flush privileges; Of course this could not be the best solution, it's just to skip it, you must look at the query/connection on your php file. On 13 January 2014 12:57, Érico erico...@gmail.com wrote: using localhost the coonection works ... ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost -P 3306 Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 97 Server version: 5.6.15 MySQL Community Server (GPL) but using 127.0.0.1 no : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1 -P 3306 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ericomtxmacbookpro:bin ericomtx$ 2014/1/13 Erick Ocrospoma zipper1...@gmail.com From that error I would suspect you are trying to access to a database where has not external access. And yeah, try by doing $ mysql -u root -p database -h localhost -P 3306 change localhost by 127.0.0.1 in order to test if both cases work, and see which of them (localhost/127.0.0.1) is defined in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote: Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
Hi didn't work look ... isn't this something related to this : are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP ... since I am not able to stabilsh a connection even with using eclipse ... my /etc/hosts file : ## 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost #fe80::1%lo0localhost 127.0.0.1 ericomtxmacbookpro.local #127.0.0.1 mysqld 2014/1/13 Erick Ocrospoma zipper1...@gmail.com On 13 January 2014 13:25, Érico erico...@gmail.com wrote: the granting is not affecting the tables: mysql grant all privileges on *.* to root@localhost identified by 'pwd'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) ... and if I try the granting in 127.0.0.1 : mysql grant all privileges to *.* 'root'@'127.0.0.1' identified by kernel26; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to *.* 'root'@'127.0.0.1' identified by kernel26' at line 1 It's my error :) It should be: mysql grant all privileges on *.* to 'root'@'127.0.0.1' identified by 'kernel26'; ... in eclipse using jconnector ... I get the same error : when pinging : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) Could not connect to New MySQL. Error creating SQL Model Connection connection to New MySQL. (Error: Access denied for user 'root'@'localhost' (using password: YES)) Access denied for user 'root'@'localhost' (using password: YES) 2014/1/13 Erick Ocrospoma zipper1...@gmail.com I forgot this. Do it too. On 13 January 2014 13:01, Erick Ocrospoma zipper1...@gmail.com wrote: I presume your index.php file uses 127.0.0.1. After login to MySQL try this: $ grant all privileges to *.* 'root'@'127.0.0.1' identified by yourpassword; $ flush privileges; Of course this could not be the best solution, it's just to skip it, you must look at the query/connection on your php file. On 13 January 2014 12:57, Érico erico...@gmail.com wrote: using localhost the coonection works ... ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost -P 3306 Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 97 Server version: 5.6.15 MySQL Community Server (GPL) but using 127.0.0.1 no : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1 -P 3306 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ericomtxmacbookpro:bin ericomtx$ 2014/1/13 Erick Ocrospoma zipper1...@gmail.com From that error I would suspect you are trying to access to a database where has not external access. And yeah, try by doing $ mysql -u root -p database -h localhost -P 3306 change localhost by 127.0.0.1 in order to test if both cases work, and see which of them (localhost/127.0.0.1) is defined in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote: Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP -- ~ Happy install ! Erick. --- Cellphone : +51 950307809 Blog: http://zerick.me/ LUG: http://www.utpinux.org IRC : zerick About : http://about.me/zerick Linux User ID : 549567 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- ~ Happy install
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
Hello Érico, On 1/13/2014 1:49 PM, Érico wrote: Hi didn't work look ... isn't this something related to this : are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP ... since I am not able to stabilsh a connection even with using eclipse ... my /etc/hosts file : ## 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost #fe80::1%lo0localhost 127.0.0.1 ericomtxmacbookpro.local #127.0.0.1 mysqld The thing to remember is that 'localhost' or '127.0.0.1' is where the server believes the connection is coming from. The password you must be using in your client connection attempt must match the one used on the server for the mysql user 'root'@'localhost' or you will not authenticate. You also need to remember that if your .php page is on a different machine, it is not connecting to the same mysqld that you have running in your development machine (your personal environment). Your .PHP page is trying to connect to the one running on its host machine. That user 'root' may have an entirely different password. Your programs are connecting fine. If they didn't you would get a different message. They are failing to authenticate which means that the mysqld they are connecting to does not recognize the password you are using for the account you are trying to authenticate as. Regards, -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
Hi no connections outside command line are being accepted . I have connected through command line , but not using eclipse for example ... it gets the same error from the web app my apache and pages are in the same computer that mysql I am not getting password issues.. otherwise I would not connect through command line Thks 2014/1/13 shawn l.green shawn.l.gr...@oracle.com Hello Érico, On 1/13/2014 1:49 PM, Érico wrote: Hi didn't work look ... isn't this something related to this : are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP ... since I am not able to stabilsh a connection even with using eclipse ... my /etc/hosts file : ## 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost #fe80::1%lo0localhost 127.0.0.1 ericomtxmacbookpro.local #127.0.0.1 mysqld The thing to remember is that 'localhost' or '127.0.0.1' is where the server believes the connection is coming from. The password you must be using in your client connection attempt must match the one used on the server for the mysql user 'root'@'localhost' or you will not authenticate. You also need to remember that if your .php page is on a different machine, it is not connecting to the same mysqld that you have running in your development machine (your personal environment). Your .PHP page is trying to connect to the one running on its host machine. That user 'root' may have an entirely different password. Your programs are connecting fine. If they didn't you would get a different message. They are failing to authenticate which means that the mysqld they are connecting to does not recognize the password you are using for the account you are trying to authenticate as. Regards, -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
WTF - we are talking about *database connections* and *not* http-URL's the webserver is only the *messenger* Am 13.01.2014 18:54, schrieb Érico: using both urls I get the same error : http://localhost/mysql/index.php http://127.0.0.1/mysql/index.php in 127.0.0.1... after I submit the index.php ... it redirects to localhost too .. 2014/1/13 Reindl Harald h.rei...@thelounge.net Am 13.01.2014 18:28, schrieb Érico: ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) but in the browser I get the error : Access denied for user 'root'@'localhost' (using password: YES) I can't find any information in error log and access log is there any command parameter that I should use when starting mysql so this doesn't happen? are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP signature.asc Description: OpenPGP digital signature
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
*your application* is connecting to mysql *your application* is using a hostname *your application* *may* use 127.0.0.1 *your application* should use localhost to *connect to the databse* *your application* can only use TCP *if there is* a *mysql user* with *that host* http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html Am 13.01.2014 20:38, schrieb Érico: no connections outside command line are being accepted . I have connected through command line , but not using eclipse for example ... it gets the same error from the web app my apache and pages are in the same computer that mysql I am not getting password issues.. otherwise I would not connect through command line 2014/1/13 shawn l.green shawn.l.gr...@oracle.com On 1/13/2014 1:49 PM, Érico wrote: Hi didn't work look ... isn't this something related to this : are you using localhost or 127.0.0.1 in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP ... since I am not able to stabilsh a connection even with using eclipse ... my /etc/hosts file : ## 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost #fe80::1%lo0localhost 127.0.0.1 ericomtxmacbookpro.local #127.0.0.1 mysqld The thing to remember is that 'localhost' or '127.0.0.1' is where the server believes the connection is coming from. The password you must be using in your client connection attempt must match the one used on the server for the mysql user 'root'@'localhost' or you will not authenticate. You also need to remember that if your .php page is on a different machine, it is not connecting to the same mysqld that you have running in your development machine (your personal environment). Your .PHP page is trying to connect to the one running on its host machine. That user 'root' may have an entirely different password. Your programs are connecting fine. If they didn't you would get a different message. They are failing to authenticate which means that the mysqld they are connecting to does not recognize the password you are using for the account you are trying to authenticate as. signature.asc Description: OpenPGP digital signature
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
Hello Reindl, On 1/13/2014 3:01 PM, Reindl Harald wrote: *your application* is connecting to mysql *your application* is using a hostname *your application* *may* use 127.0.0.1 *your application* should use localhost to *connect to the databse* *your application* can only use TCP *if there is* a *mysql user* with *that host* http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html ... snip ... The problem is, his other clients (his php page,his eclipse environment) is where he has problems making the connection from. His direct connection (using the mysql command line client) is having no problems. So, the issues are: * Why is a client connection, from the same host as the mysqld server, initiated from his PHP code failing to connect? * Why is a client connection, from the same host machine as his mysqld server, initiated from his Eclipse programming tool failing to connect? We are not saying he is using HTTP commands to log into his database. We have clarified that both his client and his server are on the same host. My last advice is that the password he is providing through his other clients must be incorrect. I even suggested that he may be validating his account on one instance but his tools are attempting to connect to a different instance. And whether I say mysql -u root -h localhost (via Unix socket) or I say mysql -u root -h 127.0.0.1 (via TCP socket) they may /both/ be reported as 'localhost' in the error message because of how the reverse DNS lookup happens during the user authentication process and the contents of his local /etc/hosts file. http://dev.mysql.com/doc/refman/5.6/en/connection-access.html Does that give you a better image of the current problem? -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Access denied for user 'root'@'localhost' (using password:
YES) on mysql admin MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol=application/pgp-signature; boundary=wmcsLTXQx7E3jAVxUD1b39Xfw2SDoi7cu --wmcsLTXQx7E3jAVxUD1b39Xfw2SDoi7cu Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Please provide the output of the below query. Select user, host, password from mysql.user; Thanks Vikas Shukla Mail Sent from my Windows Phone From: Reindl Harald Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38 To: mysql@lists.mysql.com Subject: Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin *your application* is connecting to mysql *your application* is using a hostname *your application* *may* use 127.0.0.1 *your application* should use localhost to *connect to the databse* *your application* can only use TCP *if there is* a *mysql user* with *that= host* http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html Am 13.01.2014 20:38, schrieb =C3=89rico: no connections outside command line are being accepted . I have connected through command line , but not using eclipse for example ... it gets the same error from the web app =20 my apache and pages are in the same computer that mysql =20 I am not getting password issues.. otherwise I would not connect through command line =20 2014/1/13 shawn l.green shawn.l.gr...@oracle.com =20 On 1/13/2014 1:49 PM, =C3=89rico wrote: Hi didn't work look ... isn't this something related to this : are you using localhost or 127.0.0.1 in the web-application root@localhost !=3D root@127.0.0.1 =3D different users localhost: Unix-Socket 127.0.0.1: TCP ... since I am not able to stabilsh a connection even with using eclipse ..= . my /etc/hosts file : ## 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost #fe80::1%lo0localhost 127.0.0.1 ericomtxmacbookpro.local #127.0.0.1 mysqld The thing to remember is that 'localhost' or '127.0.0.1' is where the server believes the connection is coming from. The password you must be using in your client connection attempt must match the one used on the server for the mysql user 'root'@'localhost' or you will not authenticat= e. You also need to remember that if your .php page is on a different machine, it is not connecting to the same mysqld that you have running i= n your development machine (your personal environment). Your .PHP page is trying to connect to the one running on its host machine. That user 'roo= t' may have an entirely different password. Your programs are connecting fine. If they didn't you would get a different message. They are failing to authenticate which means that the mysqld they are connecting to does not recognize the password you are us= ing for the account you are trying to authenticate as. --wmcsLTXQx7E3jAVxUD1b39Xfw2SDoi7cu-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
Am 13.01.2014 21:47, schrieb shawn l.green: Hello Reindl, We are not saying he is using HTTP commands to log into his database we excludes obviously the OP or his overall understanding :-) Am 13.01.2014 18:54, schrieb Érico: using both urls I get the same error : http://localhost/mysql/index.php http://127.0.0.1/mysql/index.php in 127.0.0.1... after I submit the index.php ... it redirects to localhost too .. signature.asc Description: OpenPGP digital signature
Re: Automatic reply: access denied to non-root@localhost null-string user in USER_PRIVILEGES
Hello Round, On 12/27/2012 5:34 AM, Round Square wrote: On 12/26/2012 01:25 PM, Igor Shevtsov wrote: You mysql.user table might be corrupted. If you have access to it as a root user, try check table mysql.user, and repair table mysql.user if table corruption was detected. Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your $datadir/mysql directory) and run mysqlcheck -r mysql user I deleted the row with the empty user from mysql.user, then restarted the daemon, and all seems back to normal now. One lingering question is: why did mysql allow this to happen? Could this be considered a bug? After all, an inadvertent and seemingly harmless insertion leads to authentication failure for all users. Are there any other known similar gotchas? The fix for this one appears so trivial as to perhaps NOT call for a restore-from-backup. But there could be other similar glitches that might call for that? Thanks! No. Your tables were not corrupted. There is no need to restore from backup. In fact, it may have been an inappropriate restore that created this situation in the first place. What you had was either an intentional or unintentional failure in security. The system was performing appropriately for the accounts that you had configured. On 26/12/12 18:00, Round Square wrote: ... Poking around in puzzlement and comparing the current, broken state with the functioning state (from backup) I discovered that in the broken version there is this extra line in the information_schema.USER_PRIVILEGES table: | ''@'localhost' | NULL | USAGE | NO | (Note the null-string user prepended to @localhost) Again: the functional, non-broken state does NOT have this entry. Thus, my current theory is that this line is the culprit. Prior to the failure I had a surge of experimental installations, installing third-party software that created mysql tables, and can't clearly retrace everything I did, at this point, to pinpoint the installation that may have caused it. Be that as it may... (1) Is my theory correct? (2) If that line should not be there... (a) How do I remove it, properly? I don't have debian-sys-maint privileges to delete the line. (Or do I?) (b) Are there other tables, besides USER_PRIVILEGES, that would need to be updated/purged Yes. Your theory is correct. Why it had such an effect on your other logins is covered in the free, searchable, and publicly-available user manual (the only kind we have): http://dev.mysql.com/doc/refman/5.5/en/connection-access.html Removing a user account (a MySQL login) does not require debian-sys-maint privileges as this is not a Linux-level account. You need an appropriately-privileged MySQL account to do this maintenance. As you most likely discovered, we cannot directly modify the tables of the INFORMATION_SCHEMA database. Those tables are constructed dynamically (on demand) using information permanently stored in other places. In order to remove that account, you need to issue a DROP USER command or you need to be able to edit the `mysql`.`user` table. http://dev.mysql.com/doc/refman/5.5/en/drop-user.html http://dev.mysql.com/doc/refman/5.5/en/grant-table-structure.html -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Automatic reply: access denied to non-root@localhost null-string user in USER_PRIVILEGES
On 12/26/2012 01:25 PM, Igor Shevtsov wrote: You mysql.user table might be corrupted. If you have access to it as a root user, try check table mysql.user, and repair table mysql.user if table corruption was detected. Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your $datadir/mysql directory) and run mysqlcheck -r mysql user I deleted the row with the empty user from mysql.user, then restarted the daemon, and all seems back to normal now. One lingering question is: why did mysql allow this to happen? Could this be considered a bug? After all, an inadvertent and seemingly harmless insertion leads to authentication failure for all users. Are there any other known similar gotchas? The fix for this one appears so trivial as to perhaps NOT call for a restore-from-backup. But there could be other similar glitches that might call for that? Thanks! On 26/12/12 18:00, Round Square wrote: Hi all: Suddenly, after a long, functioning run of the mysql server, all the non-root accounts went bad, with: Access denied for user 'non_root_user'@'localhost' (using password: YES) Authenticating with non_root_u...@server.ip.address still works ( the bind-address in my.cnf is mapped to server.ip.address ) Poking around in puzzlement and comparing the current, broken state with the functioning state (from backup) I discovered that in the broken version there is this extra line in the information_schema.USER_PRIVILEGES table: | ''@'localhost' | NULL | USAGE | NO | (Note the null-string user prepended to @localhost) Again: the functional, non-broken state does NOT have this entry. Thus, my current theory is that this line is the culprit. Prior to the failure I had a surge of experimental installations, installing third-party software that created mysql tables, and can't clearly retrace everything I did, at this point, to pinpoint the installation that may have caused it. Be that as it may... (1) Is my theory correct? (2) If that line should not be there... (a) How do I remove it, properly? I don't have debian-sys-maint privileges to delete the line. (Or do I?) (b) Are there other tables, besides USER_PRIVILEGES, that would need to be updated/purged My version: mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
access denied to non-root@localhost null-string user in USER_PRIVILEGES
Hi all: Suddenly, after a long, functioning run of the mysql server, all the non-root accounts went bad, with: Access denied for user 'non_root_user'@'localhost' (using password: YES) Authenticating with non_root_u...@server.ip.address still works ( the bind-address in my.cnf is mapped to server.ip.address ) Poking around in puzzlement and comparing the current, broken state with the functioning state (from backup) I discovered that in the broken version there is this extra line in the information_schema.USER_PRIVILEGES table: | ''@'localhost' | NULL | USAGE | NO | (Note the null-string user prepended to @localhost) Again: the functional, non-broken state does NOT have this entry. Thus, my current theory is that this line is the culprit. Prior to the failure I had a surge of experimental installations, installing third-party software that created mysql tables, and can't clearly retrace everything I did, at this point, to pinpoint the installation that may have caused it. Be that as it may... (1) Is my theory correct? (2) If that line should not be there... (a) How do I remove it, properly? I don't have debian-sys-maint privileges to delete the line. (Or do I?) (b) Are there other tables, besides USER_PRIVILEGES, that would need to be updated/purged My version: mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: access denied to non-root@localhost null-string user in USER_PRIVILEGES
You mysql.user table might be corrupted. If you have access to it as a root user, try check table mysql.user, and repair table mysql.user if table corruption was detected. Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your $datadir/mysql directory) and run mysqlcheck -r mysql user On 26/12/12 18:00, Round Square wrote: Hi all: Suddenly, after a long, functioning run of the mysql server, all the non-root accounts went bad, with: Access denied for user 'non_root_user'@'localhost' (using password: YES) Authenticating with non_root_u...@server.ip.address still works ( the bind-address in my.cnf is mapped to server.ip.address ) Poking around in puzzlement and comparing the current, broken state with the functioning state (from backup) I discovered that in the broken version there is this extra line in the information_schema.USER_PRIVILEGES table: | ''@'localhost' | NULL | USAGE | NO | (Note the null-string user prepended to @localhost) Again: the functional, non-broken state does NOT have this entry. Thus, my current theory is that this line is the culprit. Prior to the failure I had a surge of experimental installations, installing third-party software that created mysql tables, and can't clearly retrace everything I did, at this point, to pinpoint the installation that may have caused it. Be that as it may... (1) Is my theory correct? (2) If that line should not be there... (a) How do I remove it, properly? I don't have debian-sys-maint privileges to delete the line. (Or do I?) (b) Are there other tables, besides USER_PRIVILEGES, that would need to be updated/purged My version: mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1
Re: mysql_upgrade fails with Access denied
I'm trying to run mysql_upgrade but I get: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still fails with error 1045. My /etc/passwd file looks like there is no password for user mysql. What else should I try? You should use the password for the _MySQL_ root user, which is _not_ stored in /etc/passwd, but within MySQL. / Carsten Thanks everyone. I got mysqld to start with --skip-grant-tables by adding skip-grant-tables to /etc/mysql/my.cnf and restarting mysql. mysql_upgrade ran without a problem. - Grant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql_upgrade fails with Access denied
I'm trying to run mysql_upgrade but I get: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still fails with error 1045. My /etc/passwd file looks like there is no password for user mysql. What else should I try? - Grant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql_upgrade fails with Access denied
On 11/28/2010 2:02 PM, Grant wrote: I'm trying to run mysql_upgrade but I get: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still fails with error 1045. My /etc/passwd file looks like there is no password for user mysql. What else should I try? Is this 5.5.7? You have to run the server with --skip-grant-tables, then run mysql_upgrade. PB http://www.artfulsoftware.com - Grant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql_upgrade fails with Access denied
I'm trying to run mysql_upgrade but I get: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still fails with error 1045. My /etc/passwd file looks like there is no password for user mysql. What else should I try? Is this 5.5.7? You have to run the server with --skip-grant-tables, then run mysql_upgrade. I'm running mysql-5.1.51 which is the latest marked stable in Gentoo. Does this still apply? I always use Gentoo's mysql initscript so I'm trying to find the correct command to start mysqld wtih --skip-grant-tables. - Grant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql_upgrade fails with Access denied
I'm running mysql-5.1.51 which is the latest marked stable in Gentoo. Does this still apply? No, just 5.5.7. PB - On 11/28/2010 2:28 PM, Grant wrote: I'm trying to run mysql_upgrade but I get: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still fails with error 1045. My /etc/passwd file looks like there is no password for user mysql. What else should I try? Is this 5.5.7? You have to run the server with --skip-grant-tables, then run mysql_upgrade. I'm running mysql-5.1.51 which is the latest marked stable in Gentoo. Does this still apply? I always use Gentoo's mysql initscript so I'm trying to find the correct command to start mysqld wtih --skip-grant-tables. - Grant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql_upgrade fails with Access denied
I'm running mysql-5.1.51 which is the latest marked stable in Gentoo. Does this still apply? No, just 5.5.7. What else should I try to prevent the 1045 error? - Grant I'm trying to run mysql_upgrade but I get: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still fails with error 1045. My /etc/passwd file looks like there is no password for user mysql. What else should I try? Is this 5.5.7? You have to run the server with --skip-grant-tables, then run mysql_upgrade. I'm running mysql-5.1.51 which is the latest marked stable in Gentoo. Does this still apply? I always use Gentoo's mysql initscript so I'm trying to find the correct command to start mysqld wtih --skip-grant-tables. - Grant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql_upgrade fails with Access denied
Den 28-11-2010 21:02, Grant skrev: I'm trying to run mysql_upgrade but I get: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still fails with error 1045. My /etc/passwd file looks like there is no password for user mysql. What else should I try? You should use the password for the _MySQL_ root user, which is _not_ stored in /etc/passwd, but within MySQL. / Carsten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
Hi, ¶¼ÊÇÖйúÈ˾Í˵ÖÐÎÄ°É^_^ Nice to meet you. But I think that this newsgroup is for the people who come from all of the world. So post topics in English is better for anyone who is also interested about this topic, right? Ã÷Ìì»á¸üºÃ I like this sentence. Õæ¸ßÐËÄÜÔÚÕâÀï¼ûµ½×Ô¼ºÈË¡£Ï£ÍûÒÔºóÄܶà¶àÖ¸½Ì£¬Ð»Ð»¡£ Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Access denied with mysqladmin
Dear all, I have installed the MySQL version 5.1.50 with complete installation. After the installation process is finished and the configuration is done, when I run 'mysqladmin' with option 'version' in prompt, I got the following error message: -- C:\Program Files\MySQL\MySQL Server 5.1\binmysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' -- Why do I get this result? Thanks. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
On 2010年09月24日 16:11, Ma Xiaoming wrote: Dear all, I have installed the MySQL version 5.1.50 with complete installation. After the installation process is finished and the configuration is done, when I run 'mysqladmin' with option 'version' in prompt, I got the following error message: -- C:\Program Files\MySQL\MySQL Server 5.1\binmysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' -- Why do I get this result? Thanks. Best Regards Xiaoming As the console print,do you enter the password for user ODBC correctly? ODBC用户密码不对,说的很明显. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
Hi, As the console print,do you enter the password for user ODBC correctly? How to correctly use this console application, that is how to pass password when calling this console application? Thanks. ODBCÓû§ÃÜÂë²»¶Ô£¬ËµµÄºÜÃ÷ÏÔ. ÎÒÊÇÐÂÊÖ£¬»¹²»»áʹÓÃMySQL¡£ÇëÎÊÈçºÎÔÚÔËÐÐmysqladminÕâ¸öÃüÁîÐгÌÐòµÄʱºòÊäÈëÃÜÂ룿лл£¡ Best Regards. Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
On 9/24/2010 4:11 AM, Ma Xiaoming wrote: Dear all, I have installed the MySQL version 5.1.50 with complete installation. After the installation process is finished and the configuration is done, when I run 'mysqladmin' with option 'version' in prompt, I got the following error message: -- C:\Program Files\MySQL\MySQL Server 5.1\binmysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' -- Why do I get this result? Thanks. Best Regards Xiaoming You forgot to use -- before the option version. Try this instead mysqladmin --version Let us know your results. -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
Hi Shawn, You forgot to use -- before the option version. Try this instead mysqladmin --version Let us know your results. Oh yes, it works. When I typed the right command: mysqladmin --version I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on ia32 Many thanks for your help. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied with mysqladmin
都是中国人就说中文吧^_^ 明天会更好 On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.comwrote: Hi Shawn, You forgot to use -- before the option version. Try this instead mysqladmin --version Let us know your results. Oh yes, it works. When I typed the right command: mysqladmin --version I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on ia32 Many thanks for your help. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=neocana...@gmail.com
Re: Access denied with mysqladmin
太搞笑了,哈哈 2010/9/25 Neo neocana...@gmail.com 都是中国人就说中文吧^_^ 明天会更好 On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.com wrote: Hi Shawn, You forgot to use -- before the option version. Try this instead mysqladmin --version Let us know your results. Oh yes, it works. When I typed the right command: mysqladmin --version I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on ia32 Many thanks for your help. Best Regards Xiaoming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=neocana...@gmail.com
Access denied for phpmyadmin
Hi all, when i m trying to access phpmyadmin it gives the error * #1045 - Access denied for user 'pma'@'localhost' (using password: NO) ** *How could i fix the problem olease help me, Advanced thanx to you. -Regards Ganeswar Mishra Junior Programmer TathyaSoft pvt. ltd. (+91)9438014761
Access denied; you need the RELOAD privilege for this operation
Hi everyone -- I'm pretty new to MySql, but not many years ago I was an ISAM guy so I understand the issues with indexes and on-the-fly inserts. I've seen many questions around this error message, Access denied; you need the RELOAD privilege for this operation. But I'm not grokking the answers. Is it true that I cannot get all the privs I need on a database that I have created? If so, then what's a reasonable way for MySql users to get around this restriction? In my particular case, cPanel tells me MySQL version 5.0.81-community. I have a table usrs in my ISAM DB into which I want to insert a row. I execute this C-connector code before the insert: err = mysql_query( pmysql, lock table usrs write; ); err = mysql_query( pmysql, flush table usrs; ); The error return from flush table is Access denied; you need the RELOAD privilege for this operation After the insert (which completes without error) I execute the flush table call again prior to issuing unlock tables; The error return to the second flush table is likewise Access denied. I think I understand (from reading the net) that only root can grant RELOAD privs. So of course the many responses to this question everywhere often begin, It's so very simple! Just login as root and ... :-) Since I'm on a shared-host ISP, I need to get the admin to grant me RELOAD privs. But it seems that RELOAD priv is a MySql-wide priv, not a per-database or per-user priv. So no admin will go for that. The other alternative, I guess, is for me to ask the admin to execute a flush table on my table from time to time, every few days, say. Do I have the correct understanding of the situation? And how do people usually deal with this error? Thanks so much! I apologize for the newb-level question and really appreciate your help. -- Pete -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied; you need the RELOAD privilege for this operation
In the last episode (Sep 20), Pete Wilson said: I'm pretty new to MySql, but not many years ago I was an ISAM guy so I understand the issues with indexes and on-the-fly inserts. I've seen many questions around this error message, Access denied; you need the RELOAD privilege for this operation. But I'm not grokking the answers. Is it true that I cannot get all the privs I need on a database that I have created? If so, then what's a reasonable way for MySql users to get around this restriction? In my particular case, cPanel tells me MySQL version 5.0.81-community. I have a table usrs in my ISAM DB into which I want to insert a row. I execute this C-connector code before the insert: err = mysql_query( pmysql, lock table usrs write; ); err = mysql_query( pmysql, flush table usrs; ); The error return from flush table is Access denied; you need the RELOAD privilege for this operation After the insert (which completes without error) I execute the flush table call again prior to issuing unlock tables; The error return to the second flush table is likewise Access denied. The only time a table flush is needed is when you are looking at the raw mysql data files and want to make sure there are no dirty blocks that haven't been written to disk yet (for hot backup purposes, for example), or if you are debugging a performance problem and want to make sure all caches are emptied. If you're just inserting rows, there's no need to flush anything. Also, there probably isn't a reason to explicitly lock the entire table, either. If you were previously using that to emulate atomic transactions on myisam tables, you can replace your lock/unlock table operations with a START TRANSACTION/COMMIT pair, because innodb supports transactions (myisam doesn't). That will let other users access the usrs table at the same time you're doing your insert. If you're just inserting a single row, you can even drop the transaction calls. A single insert is always atomic, no matter what table type you are using. Your ISAM experience might actually be a drawback here, if it's more at the operational level of old Berkely DB 1.x-style databases (where one has to manually maintain the index, there are no transactions, etc). SQL-based databases sit on top of the lower-level table engines and handle all that work for you. -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqldump.exe gives Access Denied for user
Gurus, I'm running a Windows Server 2003 cmd shell script to backup my databases using: %mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% -p%dbpass% %bkupdir%\dbBkup_%dbname%_%yy%%mm%%dd%.sql @ECHO Done! New File: dbBkup_%dbname%_%yy%%mm%%dd%.sql It's been running fine until I've had to change the password for this dbuser due to it being hijacked to drop our tables. My problem is, mysqldump now keeps giving me Access denied for this user and the backup job doesn't go through. I can log into MySQL Query Browser and even Administrator fine with the new password however. Any clues/pointers is greatly appreciated! Please cc my email! Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: access denied error
Sorry to have bothered you. I believe I found the problem. I had a 1 (One) in the password instead of a l (L). it was working from the command prompt, because I was typing it in the same way, but from the application, it was stored. So, basically, I had the password wrong. Thanks, Jesse - Original Message - From: Jim Lyons To: Jesse Cc: MySQL List Sent: Friday, October 10, 2008 8:28 AM Subject: Re: access denied error What is the PHP connect string? Are you connecting to the database you have access to? are you connecting as the same user (myuser)? Do other php applications work, so you know it's not a php-mysql issue? On Fri, Oct 10, 2008 at 6:59 AM, Jesse [EMAIL PROTECTED] wrote: I have a PHP application that I inherited. I have it running on a Ubuntu 8.04 virtual machine. I have set up a user to access the MySQL database, and from the command prompt, I can access it just fine. For instance, from the Ubuntu prompt, if I type MySQL -umyuser -p, it asks me for the password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, Access denied for user 'trucksma_db'@'localhost' (using password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
access denied error
I have a PHP application that I inherited. I have it running on a Ubuntu 8.04 virtual machine. I have set up a user to access the MySQL database, and from the command prompt, I can access it just fine. For instance, from the Ubuntu prompt, if I type MySQL -umyuser -p, it asks me for the password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, Access denied for user 'trucksma_db'@'localhost' (using password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access denied error
What is the PHP connect string? Are you connecting to the database you have access to? are you connecting as the same user (myuser)? Do other php applications work, so you know it's not a php-mysql issue? On Fri, Oct 10, 2008 at 6:59 AM, Jesse [EMAIL PROTECTED] wrote: I have a PHP application that I inherited. I have it running on a Ubuntu 8.04 virtual machine. I have set up a user to access the MySQL database, and from the command prompt, I can access it just fine. For instance, from the Ubuntu prompt, if I type MySQL -umyuser -p, it asks me for the password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, Access denied for user 'trucksma_db'@'localhost' (using password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command mysqladmin -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
Varuna Seneviratna írta: I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command mysqladmin -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. 1. Nortan - Norton 2. man mysql - mysql -ufoo -pbar t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
Hi Varuna, I think you're missing the -u option (User for login if not current user.) Try: mysqladmin -u root -p shutdown (-p without a value indicates to prompt for a password from the terminal.) Andy Varuna Seneviratna wrote: I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command mysqladmin -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
Hi Varuna, The problem looks like it is with the command you issued. The correct syntax is: mysqladmin -uroot -p shutdown then supply root password. Without giving the -uroot argument, it doesn't know that you are trying to log in as the root user, which is why it is telling you that access is denied for [EMAIL PROTECTED], rather than [EMAIL PROTECTED] Thanks On Sat, 2008-10-04 at 13:56 +0530, Varuna Seneviratna wrote: I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command mysqladmin -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
Hi Ian Thanks! Your advice worked.I have another problem.I stopped the service from the services shortcut in the Administrative tools.then according to to the reference manual to start the server for the first time the command to run is given as C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console But it didn't work, the following was the displayed message 'C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld' is not recognized as an i nternal or external command, operable program or batch file. *But when I used mysqld-nt The following is the out put* C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt --console 081004 16:56:01 InnoDB: Started; log sequence number 0 43655 081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were used; s o replication may break when this MySQL server acts as a slave and has his hostn ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid this p roblem. 081004 16:56:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: re ady for connections. Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 1 In the reference manual there are three server types how can I start the mysqld server? 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops it stops? 3 After starting the server in above mentioned way How can I use MySQL server Do I have to open another console window and do what? Thanks Varuna On Sat, Oct 4, 2008 at 2:19 PM, Ian Simpson [EMAIL PROTECTED] wrote: Hi Varuna, The problem looks like it is with the command you issued. The correct syntax is: mysqladmin -uroot -p shutdown then supply root password. Without giving the -uroot argument, it doesn't know that you are trying to log in as the root user, which is why it is telling you that access is denied for [EMAIL PROTECTED], rather than [EMAIL PROTECTED] Thanks On Sat, 2008-10-04 at 13:56 +0530, Varuna Seneviratna wrote: I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command mysqladmin -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna -- Ian Simpson System Administrator MyJobGroup
Re: MySQL Error Number 1045 Access denied
Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Andy Shellam Business Systems Architect Network Mail NetServe Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
Alternatively you can try this if the box is unix/linux : sudo mysqld_safe --skip-grant-tables --user=root mysql -u root Change your root password Restart mysql after this. Cheers Sharad Andy Shellam wrote: Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
FYI, I don't think this was sent to the list, forgive me if it was and I didn't see it. Andy -- You probably don't have to reinstall it. If you never gave root a password, just login as Andy says below and, when prompted for the password, just press the ENTER key. Unless you gave root a password and forgot it, you should find yourself in the mysql program. Enter something like: update mysql.user set password = password('new pwd') where user = 'root'; flush privileges; There are other ways to change a pwd, but I use that since it's easier for me to remember one way. Jim On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Andy Shellam Business Systems Architect Network Mail NetServe Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
If you are desperate, you can also start mysqld with --skip-grant-tables option. Then use mysql, update root password using the update statement that Jim wrote about. -Paul On Mon, 2008-08-18 at 17:25 +0100, Andy Shellam wrote: FYI, I don't think this was sent to the list, forgive me if it was and I didn't see it. Andy -- You probably don't have to reinstall it. If you never gave root a password, just login as Andy says below and, when prompted for the password, just press the ENTER key. Unless you gave root a password and forgot it, you should find yourself in the mysql program. Enter something like: update mysql.user set password = password('new pwd') where user = 'root'; flush privileges; There are other ways to change a pwd, but I use that since it's easier for me to remember one way. Jim On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Andy Shellam Business Systems Architect Network Mail NetServe Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul Choi [EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA
Re: MySQL Error Number 1045 Access denied
How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Error Number 1045 Access denied
Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user 'debian-sys-maint'@'localhost'
Hi Jesse, If you're specifying the password in plain text, you shouldn't put the PASSWORD directive in there; you only use PASSWORD if you're using the hashed password that MySQL will actually store. GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'LongPasswordHere' WITH GRANT OPTION or GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'HexadecimalString' WITH GRANT OPTION Also, you will need to execute FLUSH PRIVILEGES once you're done, since MySQL normally only checks the privilege tables on start-up. On Mon, 2008-07-21 at 20:35 -0400, Jesse wrote: OK. This is driving me Nutz 8-p Any time I try to restart mysql, I get the error, Access denied for user 'debian-sys-maint'@'localhost' My understanding is that the password for the debian-sys-maint user is found in /etc/mysql/debian.cnf So, I edit that, and note the password. I then execute the following in MySQL (with the correct password, of course): GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'LongPasswordHere' WITH GRANT OPTION To test it out, I try a mysql -u debian-sys-maint -p, type in the password and get the Access denied error again. What's going on? Why can't I get this to work? Jesse -- Ian Simpson System Administrator MyJobGroup This email may contain confidential information and is intended for the recipient(s) only. If an addressing or transmission error has misdirected this email, please notify the author by replying to this email. If you are not the intended recipient(s) disclosure, distribution, copying or printing of this email is strictly prohibited and you should destroy this mail. Information or opinions in this message shall not be treated as neither given nor endorsed by the company. Neither the company nor the sender accepts any responsibility for viruses or other destructive elements and it is your responsibility to scan any attachments.
Re: Access denied for user 'debian-sys-maint'@'localhost'
That was it. Once I removed PASSWORD, it went through, and I'm able to restart MySQL now. Thanks for your help. Jesse - Original Message - From: Ian Simpson To: Jesse Cc: MySQL List Sent: Tuesday, July 22, 2008 4:48 AM Subject: Re: Access denied for user 'debian-sys-maint'@'localhost' Hi Jesse, If you're specifying the password in plain text, you shouldn't put the PASSWORD directive in there; you only use PASSWORD if you're using the hashed password that MySQL will actually store.
Access denied for user 'debian-sys-maint'@'localhost'
OK. This is driving me Nutz 8-p Any time I try to restart mysql, I get the error, Access denied for user 'debian-sys-maint'@'localhost' My understanding is that the password for the debian-sys-maint user is found in /etc/mysql/debian.cnf So, I edit that, and note the password. I then execute the following in MySQL (with the correct password, of course): GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'LongPasswordHere' WITH GRANT OPTION To test it out, I try a mysql -u debian-sys-maint -p, type in the password and get the Access denied error again. What's going on? Why can't I get this to work? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user 'debian-sys-maint'@'localhost'
Do you login via sock or network ? Didja change the passwd for localhost and % ? --Original Message-- From: Jesse To: MySQL List Sent: Jul 21, 2008 17:35 Subject: Access denied for user 'debian-sys-maint'@'localhost' OK. This is driving me Nutz 8-p Any time I try to restart mysql, I get the error, Access denied for user 'debian-sys-maint'@'localhost' My understanding is that the password for the debian-sys-maint user is found in /etc/mysql/debian.cnf So, I edit that, and note the password. I then execute the following in MySQL (with the correct password, of course): GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'LongPasswordHere' WITH GRANT OPTION To test it out, I try a mysql -u debian-sys-maint -p, type in the password and get the Access denied error again. What's going on? Why can't I get this to work? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Sent via BlackBerry from T-Mobile
Follow Up : Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)
Hello MySQL List, Thanks Ken and HongKong0888 for the advice and suggestions. I hate when these kinds of problems just fade away with no resolution or analysis of the resolved issue. So, with that, here is the explanation for what caused THIS particular problem (can you say user error?). In researching the error message itself, I found ONE relatively OBSCURE reference to making a change in the connect call to the database that fixed their problem but what they did to resolve their problem was not directly applicable to my situation BUT it got me to thinking in the right direction. The MySQL connection class that was implemented by the software I am working on is pretty much the standard mysql connection class that is pretty ubiquitous in PHP applications with the exception that the developers chose to suppress any connect errors with a preceding @ sign at the beginning of the call (this is in addition to other conditionals they have elsewhere to control the error displays in the browser). I decided to see if removing it would give me better information about the nature of the error. When I tried to access the site again, I got an error message on the screen that it didn't know what database connection it was suppose to make. When I looked at the path variable it was trying to use, I saw that it was completely wrong because the variable definitions were missing from the configuration file. Basically, I upgraded the software but not the configuration file which significantly changed on the new version I was installing. Oops! I had assumed that they were the same. Lesson Learned: Shortcuts and Assumptions can and do bite! The error message that displays may not have ANYTHING to do with the cause of the problem. In this case, the error stated is completely bogus relative to the cause of the problem, i.e. red herring. So, that's my story and hope it helps someone prevent premature baldness from troubleshooting obscure database problems... 8-) -- Best regards, mikeszmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)
My guess is that you have the privileges set on your local box that allow connections with those credentials but the same privileges are not set up on your clients machines. Although using apache as a user without a password is quite a security risk. And then mailing those details to a public mailing list is probably madness. I would suggest using a different username and setting a password and then using those details to connect to the database. Then set the same privileges on your client's machine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)
Hello mysql, I just started having this problem and wonder if someone might give me a clue why this is happening. The scenario is that I build a CMS on my local XP system to make sure it is working correctly and customize it per the client's specifications. Almost always the client has some version of this software running on their site, if not the same version. I make mods to the database, test it out and import the tables into the client system. Generally, it works with no problem. But the last two times I have received Acess denied for user [EMAIL PROTECTED] on two completely different systems, even separated by Continents ;-) On the first system, I dropped and replaced all the tables but on this second one, I didn't drop several huge tables that I didn't want to upload redundant data for so I left them intact to save time and bandwidth. I have done this sort of transfer hundreds of times with no trouble but the last two in a row have required that the permissions be reset. I am just looking at the error messages in the emails I am getting and apparently it is not just the Apache user. It is sending access denied for the site account owner too, I just noticed. I am using the same login credentials from the configuration files to connect to the database including username/password yet I get this apache error message. Any ideas or explanations on this greatly appreciated in advanced. -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for GRANT using root yet manual user insertion is fine
The grant flag is enabled on the root account: mysql SELECT Grant_priv FROM user WHERE User='root' AND Host='localhost'; ++ | Grant_priv | ++ | Y | ++ 1 row in set (0.01 sec) mysql SHOW GRANTS FOR 'root'@'localhost'; Grants for [EMAIL PROTECTED] GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH' WITH GRANT OPTION | 1 row in set (0.00 sec) When I execute the GRANT on _ANY_ database, I receive the following error: mysql GRANT ALL PRIVILEGES ON `foo`.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH'; ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'foo' I have tried revoking the grant (with --init-file), then reissuing it. This has not remedied it. It was recently upgraded from MySQL 4, it is currently running on mysql Ver 14.12 Distrib 5.0.27. I have ran 'mysql_fix_privilege_tables'. I have also updated the password to use the updated PASSWORD() hash in the mysql.user table, but the issue persists. The root user is fully operational, users can be inserted via the mysql.user table, This works without a problem! Contents of the my.cnf: # cat /etc/my.cnf [mysqld] set-variable = max_connections=500 safe-show-database log=/var/log/mysql.log old_passwords=0 The server runs on CentOS release 4.5 (Final). Any assistance to rectifying this will be greatly appreciated. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for GRANT using root yet manual user insertion is fine
The grant flag is enabled on the root account: mysql SELECT Grant_priv FROM user WHERE User='root' AND Host='localhost'; ++ | Grant_priv | ++ | Y | ++ 1 row in set (0.01 sec) mysql SHOW GRANTS FOR 'root'@'localhost'; Grants for [EMAIL PROTECTED] GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH' WITH GRANT OPTION | 1 row in set (0.00 sec) When I execute the GRANT on _ANY_ database, I receive the following error: mysql GRANT ALL PRIVILEGES ON `foo`.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH'; ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'foo' I have tried revoking the grant (with --init-file), then reissuing it. This has not remedied it. It was recently upgraded from MySQL 4, it is currently running on mysql Ver 14.12 Distrib 5.0.27. I have ran 'mysql_fix_privilege_tables'. I have also updated the password to use the updated PASSWORD() hash in the mysql.user table, but the issue persists. The root user is fully operational, users can be inserted via the mysql.user table, This works without a problem! Contents of the my.cnf: # cat /etc/my.cnf [mysqld] set-variable = max_connections=500 safe-show-database log=/var/log/mysql.log old_passwords=0 The server runs on CentOS release 4.5 (Final). Any assistance to rectifying this will be greatly appreciated. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for GRANT using root yet manual user insertion is fine
With assistance from a friend this issue has been rectified. The current GRANT was not sufficient. After executing the new GRANT with 'ALL PRIVILEGES' (using the --init-file switch) the root user can now issue GRANTS. Additionally I apologise for duplicate posts, It was not intentional. On 9/2/07, Ed Cradock [EMAIL PROTECTED] wrote: The grant flag is enabled on the root account: mysql SELECT Grant_priv FROM user WHERE User='root' AND Host='localhost'; ++ | Grant_priv | ++ | Y | ++ 1 row in set (0.01 sec) mysql SHOW GRANTS FOR 'root'@'localhost'; Grants for [EMAIL PROTECTED] GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH' WITH GRANT OPTION | 1 row in set (0.00 sec) When I execute the GRANT on _ANY_ database, I receive the following error: mysql GRANT ALL PRIVILEGES ON `foo`.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH'; ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'foo' I have tried revoking the grant (with --init-file), then reissuing it. This has not remedied it. It was recently upgraded from MySQL 4, it is currently running on mysql Ver 14.12 Distrib 5.0.27. I have ran 'mysql_fix_privilege_tables'. I have also updated the password to use the updated PASSWORD() hash in the mysql.user table, but the issue persists. The root user is fully operational, users can be inserted via the mysql.user table, This works without a problem! Contents of the my.cnf: # cat /etc/my.cnf [mysqld] set-variable = max_connections=500 safe-show-database log=/var/log/mysql.log old_passwords=0 The server runs on CentOS release 4.5 (Final). Any assistance to rectifying this will be greatly appreciated. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user on Windows Server
Car Toper wrote: More info... I am able to login with the account via phpMyAdmin on the server. Also, I am trying to use phpMyAdmin to change the permissions, but I cannot figure out the syntax: GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION; Cartoper On 8/21/07, Car Toper [EMAIL PROTECTED] wrote: I have a MySql server running on a Windows box that I cannot connect to from another machine. I first checked to make sure the user has the correct permissions, which the user does, it has the %. I did read something that gave me the impression the user needs to have a tranditional windows account on the machine, so I created one. Still nothing. Is there anything special I need to do to allow access to MySql when the database is running on a different machine? If you're trying to create a superuser on the server, you would use GRANT ALL PRIVILEGES ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION; Although I wouldn't recommend this for security purposes; it's a much more secure idea to selectively grant the privileges as necessary to the user and assign a password, such as GRANT SELECT,INSERT,DELETE ON ppsntracker.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; And so forth. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for user on Windows Server
I have a MySql server running on a Windows box that I cannot connect to from another machine. I first checked to make sure the user has the correct permissions, which the user does, it has the %. I did read something that gave me the impression the user needs to have a tranditional windows account on the machine, so I created one. Still nothing. Is there anything special I need to do to allow access to MySql when the database is running on a different machine? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user on Windows Server
More info... I am able to login with the account via phpMyAdmin on the server. Also, I am trying to use phpMyAdmin to change the permissions, but I cannot figure out the syntax: GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION; Cartoper On 8/21/07, Car Toper [EMAIL PROTECTED] wrote: I have a MySql server running on a Windows box that I cannot connect to from another machine. I first checked to make sure the user has the correct permissions, which the user does, it has the %. I did read something that gave me the impression the user needs to have a tranditional windows account on the machine, so I created one. Still nothing. Is there anything special I need to do to allow access to MySql when the database is running on a different machine? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
Is this a user untz going to do even the create procedure, if yes then you need to grant super previliege to this user. grant super on *.* to 'untz'@'localhost' identified by 'password'; regards anandkl On 6/11/07, untz [EMAIL PROTECTED] wrote: Baron Prathima, Thank for the information! What happened is that I hadn't used MySQL for a long time and looked up on the Internet on how to change my root and individual users' passwords. The last command the URL had me type was flush privileges; and once I did that, I think it created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; +--- --+ | Grants for [EMAIL PROTECTED] | +--- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' +--- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: Hi untz, untz wrote: Hello there, I am using MySQL 5 on OS X Tiger... After starting the server, I tried to create a sample database and this is what what happened: $ mysql -u untz -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
Hi, I think you need to log in as root and grant yourself some privileges then. If you have lost the root password or root doesn't have privileges anymore either, there is a chapter in the manual on how to do this: http://dev.mysql.com/ Cheers Baron untz wrote: Baron Prathima, Thank for the information! What happened is that I hadn't used MySQL for a long time and looked up on the Internet on how to change my root and individual users' passwords. The last command the URL had me type was flush privileges; and once I did that, I think it created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; +-+ | Grants for [EMAIL PROTECTED] | +-+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' +-+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: Hi untz, untz wrote: Hello there, I am using MySQL 5 on OS X Tiger... After starting the server, I tried to create a sample database and this is what what happened: $ mysql -u untz -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Baron Schwartz http://www.xaprb.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
Ananda, Thank you for responding! I just tried this and got the following: mysql grant super *.* to 'untz'@'localhost' identified by 'password'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*.* to [EMAIL PROTECTED] identified by password' at line 1 Can anyone please help me? I am not a DBA Kindest regards, untz On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote: Is this a user untz going to do even the create procedure, if yes then you need to grant super previliege to this user. grant super on *.* to 'untz'@'localhost' identified by 'password'; regards anandkl On 6/11/07, untz [EMAIL PROTECTED] wrote: Baron Prathima, Thank for the information! What happened is that I hadn't used MySQL for a long time and looked up on the Internet on how to change my root and individual users' passwords. The last command the URL had me type was flush privileges; and once I did that, I think it created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; + --- --+ | Grants for [EMAIL PROTECTED] | + --- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' + --- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: Hi untz, untz wrote: Hello there, I am using MySQL 5 on OS X Tiger... After starting the server, I tried to create a sample database and this is what what happened: $ mysql -u untz -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
untz wrote: Ananda, Thank you for responding! I just tried this and got the following: mysql grant super *.* to 'untz'@'localhost' identified by 'password'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*.* to [EMAIL PROTECTED] identified by password' at line 1 Can anyone please help me? I am not a DBA Kindest regards, untz On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote: Is this a user untz going to do even the create procedure, if yes then you need to grant super previliege to this user. grant super on *.* to 'untz'@'localhost' identified by 'password'; regards anandkl On 6/11/07, untz [EMAIL PROTECTED] wrote: Baron Prathima, Thank for the information! What happened is that I hadn't used MySQL for a long time and looked up on the Internet on how to change my root and individual users' passwords. The last command the URL had me type was flush privileges; and once I did that, I think it created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; + --- --+ | Grants for [EMAIL PROTECTED] | + --- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' + --- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: Hi untz, untz wrote: Hello there, I am using MySQL 5 on OS X Tiger... After starting the server, I tried to create a sample database and this is what what happened: $ mysql -u untz -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] The show grants you ran shows you the proper syntax. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access Denied When Trying to Create Database
Looks like words privileges on are missing from GRANT statement you used Should be grant super privileges on *.* to 'untz'@'localhost' identified by 'password'; Not grant super *.* to 'untz'@'localhost' identified by 'password'; Regards, Mikhail Berman -Original Message- From: untz [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 4:02 PM To: Ananda Kumar Cc: mysql@lists.mysql.com Subject: Re: Access Denied When Trying to Create Database Ananda, Thank you for responding! I just tried this and got the following: mysql grant super *.* to 'untz'@'localhost' identified by 'password'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*.* to [EMAIL PROTECTED] identified by password' at line 1 Can anyone please help me? I am not a DBA Kindest regards, untz On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote: Is this a user untz going to do even the create procedure, if yes then you need to grant super previliege to this user. grant super on *.* to 'untz'@'localhost' identified by 'password'; regards anandkl On 6/11/07, untz [EMAIL PROTECTED] wrote: Baron Prathima, Thank for the information! What happened is that I hadn't used MySQL for a long time and looked up on the Internet on how to change my root and individual users' passwords. The last command the URL had me type was flush privileges; and once I did that, I think it created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; + --- --+ | Grants for [EMAIL PROTECTED] | + --- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' + --- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: Hi untz, untz wrote: Hello there, I am using MySQL 5 on OS X Tiger... After starting the server, I tried to create a sample database and this is what what happened: $ mysql -u untz -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
Gerald, I tried this and still got an error! mysql grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog'; ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using password: YES) mysql Can anyone please help me? I am unable to use MySQL at all, at this point... -untz On Jun 11, 2007, at 1:06 PM, Gerald L. Clark wrote: untz wrote: Ananda, Thank you for responding! I just tried this and got the following: mysql grant super *.* to 'untz'@'localhost' identified by 'password'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*.* to [EMAIL PROTECTED] identified by password' at line 1 Can anyone please help me? I am not a DBA Kindest regards, untz On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote: Is this a user untz going to do even the create procedure, if yes then you need to grant super previliege to this user. grant super on *.* to 'untz'@'localhost' identified by 'password'; regards anandkl On 6/11/07, untz [EMAIL PROTECTED] wrote: Baron Prathima, Thank for the information! What happened is that I hadn't used MySQL for a long time and looked up on the Internet on how to change my root and individual users' passwords. The last command the URL had me type was flush privileges; and once I did that, I think it created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; +-- -- --- --+ | Grants for [EMAIL PROTECTED] | +-- -- --- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' +-- -- --- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: Hi untz, untz wrote: Hello there, I am using MySQL 5 on OS X Tiger... After starting the server, I tried to create a sample database and this is what what happened: $ mysql -u untz -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] The show grants you ran shows you the proper syntax. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
Mikhail, I just tried what you suggested and got this: mysql grant super privileges on *.* to 'untz'@'localhost' identified by 'maddog'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'privileges on *.* to 'untz'@'localhost' identified by 'maddog'' at line 1 Many, many thanks, untz On Jun 11, 2007, at 1:21 PM, Mikhail Berman wrote: Looks like words privileges on are missing from GRANT statement you used Should be grant super privileges on *.* to 'untz'@'localhost' identified by 'password'; Not grant super *.* to 'untz'@'localhost' identified by 'password'; Regards, Mikhail Berman -Original Message- From: untz [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 4:02 PM To: Ananda Kumar Cc: mysql@lists.mysql.com Subject: Re: Access Denied When Trying to Create Database Ananda, Thank you for responding! I just tried this and got the following: mysql grant super *.* to 'untz'@'localhost' identified by 'password'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*.* to [EMAIL PROTECTED] identified by password' at line 1 Can anyone please help me? I am not a DBA Kindest regards, untz On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote: Is this a user untz going to do even the create procedure, if yes then you need to grant super previliege to this user. grant super on *.* to 'untz'@'localhost' identified by 'password'; regards anandkl On 6/11/07, untz [EMAIL PROTECTED] wrote: Baron Prathima, Thank for the information! What happened is that I hadn't used MySQL for a long time and looked up on the Internet on how to change my root and individual users' passwords. The last command the URL had me type was flush privileges; and once I did that, I think it created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; +--- - --- --+ | Grants for [EMAIL PROTECTED] | +--- - --- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' +--- - --- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: Hi untz, untz wrote: Hello there, I am using MySQL 5 on OS X Tiger... After starting the server, I tried to create a sample database and this is what what happened: $ mysql -u untz -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]