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
[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
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
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: 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]
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]
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Hi, I installed mysql 4.1.22 for Debian testing. I launched the manual installation. However, when I do : mysql -u root I get : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I tried to reinstall it, but it fails. Thanks for help, Thibaud. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Thibaud... If you have already set your MySQL root password, then you need to login to mysql like this: mysql -u root -p You should be prompted for the mysql root password. If you haven't set your mysql root password, then you need to do this: mysqladmin -u root password 'new-password' You may have to give the complete path to mysqladmin. CheersCassj -Original Message- From: Thibaud Hulin [EMAIL PROTECTED] Sent: May 9, 2007 4:13 PM To: mysql@lists.mysql.com Subject: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Hi, I installed mysql 4.1.22 for Debian testing. I launched the manual installation. However, when I do : mysql -u root I get : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I tried to reinstall it, but it fails. Thanks for help, Thibaud. -- 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]
mysql_upgrade not running mysql_check: Access denied for user 'root'@'localhost'
Hi, When I try mysql_upgrade I get a connection problem, $ mysql_upgrade -p Enter password: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect Error executing '/usr/bin/mysqlcheck --check-upgrade --all-databases --auto-repair --user=root' but I am able to run mysql_check directly without a problem, $ mysqlcheck --check-upgrade --all-databases --auto-repair -u root -p Enter password: main.provider OK main.request_dispatch OK mysql.columns_priv OK mysql.db OK mysql.func OK mysql.help_categoryOK mysql.help_keyword OK mysql.help_relationOK mysql.help_topic OK mysql.host OK mysql.proc OK mysql.procs_priv OK mysql.tables_priv OK mysql.time_zoneOK mysql.time_zone_leap_secondOK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_typeOK mysql.user OK Does anyone know why this would be? This is my version information: $ mysqladmin version mysqladmin Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on i486 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.0.32-Debian_7etch1-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Cheers, -Janek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
Hi. Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday): - [EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) -- I created a '/root/root.sql' file: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xx'); And killed the process and restarted: [EMAIL PROTECTED] ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql [1] 2494 [EMAIL PROTECTED] ~]# Starting mysqld daemon with databases from /usr/local/mysql/var But I get the same error message :( In my '/usr/local/mysql/var/server.err' file there's no error message: -- 070220 07:03:40 mysqld started 070220 07:03:40 InnoDB: Started; log sequence number 0 3758734 /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution --- What am I doing wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
Hi. Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday): - [EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) -- I created a '/root/root.sql' file: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xx'); And killed the process and restarted: [EMAIL PROTECTED] ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql [1] 2494 [EMAIL PROTECTED] ~]# Starting mysqld daemon with databases from /usr/local/mysql/var But I get the same error message :( In my '/usr/local/mysql/var/server.err' file there's no error message: -- 070220 07:03:40 mysqld started 070220 07:03:40 InnoDB: Started; log sequence number 0 3758734 /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution --- What am I doing wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'
Fixed: []# kill `cat /usr/local/mysql/var/server.pid` []# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables []# /usr/local/mysql/bin/mysql mysql update user set password = password('xxx') where user = 'root' and host='localhost'; On 2/20/07, thomas Armstrong [EMAIL PROTECTED] wrote: Hi. Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday): - [EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) -- I created a '/root/root.sql' file: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xx'); And killed the process and restarted: [EMAIL PROTECTED] ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql [1] 2494 [EMAIL PROTECTED] ~]# Starting mysqld daemon with databases from /usr/local/mysql/var But I get the same error message :( In my '/usr/local/mysql/var/server.err' file there's no error message: -- 070220 07:03:40 mysqld started 070220 07:03:40 InnoDB: Started; log sequence number 0 3758734 /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution --- What am I doing wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost
Thank you very much James, i flush the privilegies and restart the mysql service and all result fine :-) I can access from anyhost Aron L. James Barros wrote: Can this use log in from localhost successfully? Try flushing privileges again? If that failed, I'd drop the user and recreate? ( Theres really not alot to this, sorry I don't have any more ideas :( ) -- James On Jun 7, 2006, at 1:07 PM, Aron Levy wrote: Hi James i follow your recomendation and verify that the hash produced matches the password field in user exactly. -- Aron L. James Barros wrote: Well, for starters don't worry about ports being open. If you werent able to connect, it would give you a different error message. select password('yourpassword'); and verify that the hash produced matches the password field in user exactly. -- James On Jun 7, 2006, at 11:48 AM, Aron Levy wrote: Hi good afternoon, i am triying to connect with my company's mysql server using a client program from shell and I keep receiving the following answer: [EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com Enter password: ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209' (using password: YES) [EMAIL PROTECTED] ~]# I already checked the user was configured for any host (%), the port 3306 is open (checked with nmap), but i dont know what i need to do or see other variables. I am 100% sure of the passwords i am using for this users, and i am attaching some info about the database. Thank you in advance, mysql select * from user; +---+--+--+- +-+-+-+- +--- +-+---+-- +--- ++-+ ++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+- +-+-+-+- +--- +-+---+-- +--- ++-+ ++ | % | user1 | 5804b8eebr456240 | N | N| N | N | N | N | N| N | N| N | N | N | N | N | | % | user4 | 6f37d73jsdred201d | N | N| N | N | N | N | N| N | N| N | N | N | N | N | [EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07 09:57 VET Interesting ports on xx.xx.xx.xx: (The 1653 ports scanned but not shown below are in state: closed) PORT STATESERVICEVERSION 21/tcp open ftpProFTPD 1.2.10 22/tcp open sshOpenSSH 3.9p1 (protocol 1.99) 25/tcp open smtp netqmail smtpd 1.04 53/tcp open domain 80/tcp open http Apache httpd 2.0.53 ((Fedora)) 106/tcp open pop3pw poppassd 110/tcp open pop3 Courier pop3d 111/tcp open rpcbind 2 (rpc #10) 135/tcp filtered msrpc 139/tcp filtered netbios-ssn 143/tcp open imap Courier Imapd (released 2004) 443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora)) 445/tcp filtered microsoft-ds 465/tcp open ssl/smtp netqmail smtpd 1.04 593/tcp filtered http-rpc-epmap 993/tcp open ssl/imap Courier Imapd (released 2004) 995/tcp open ssl/pop3 Courier pop3d 1720/tcp filtered H.323/Q.931 3306/tcp open mysql MySQL 4.1.15 /tcp filtered krb524 8443/tcp open http Apache httpd 1.3.33 ((Unix) mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4) Device type: general purpose Running: Linux 2.6.X OS details: Linux 2.6.5 - 2.6.11 Uptime 26.627 days (since Thu May 11 18:56:31 2006) Service Info: OS: Unix Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds mysql MySQL Support Active Persistent Links Active Links Client API version 4.1.15 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient -- 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
ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost
Hi good afternoon, i am triying to connect with my company's mysql server using a client program from shell and I keep receiving the following answer: [EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com Enter password: ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209' (using password: YES) [EMAIL PROTECTED] ~]# I already checked the user was configured for any host (%), the port 3306 is open (checked with nmap), but i dont know what i need to do or see other variables. I am 100% sure of the passwords i am using for this users, and i am attaching some info about the database. Thank you in advance, mysql select * from user; +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | % | user1 | 5804b8eebr456240 | N | N | N | N | N | N | N | N | N| N | N | N | N | N | | % | user4 | 6f37d73jsdred201d | N | N | N | N | N | N | N | N | N| N | N | N | N | N | [EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07 09:57 VET Interesting ports on xx.xx.xx.xx: (The 1653 ports scanned but not shown below are in state: closed) PORT STATESERVICEVERSION 21/tcp open ftpProFTPD 1.2.10 22/tcp open sshOpenSSH 3.9p1 (protocol 1.99) 25/tcp open smtp netqmail smtpd 1.04 53/tcp open domain 80/tcp open http Apache httpd 2.0.53 ((Fedora)) 106/tcp open pop3pw poppassd 110/tcp open pop3 Courier pop3d 111/tcp open rpcbind 2 (rpc #10) 135/tcp filtered msrpc 139/tcp filtered netbios-ssn 143/tcp open imap Courier Imapd (released 2004) 443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora)) 445/tcp filtered microsoft-ds 465/tcp open ssl/smtp netqmail smtpd 1.04 593/tcp filtered http-rpc-epmap 993/tcp open ssl/imap Courier Imapd (released 2004) 995/tcp open ssl/pop3 Courier pop3d 1720/tcp filtered H.323/Q.931 3306/tcp open mysql MySQL 4.1.15 /tcp filtered krb524 8443/tcp open http Apache httpd 1.3.33 ((Unix) mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4) Device type: general purpose Running: Linux 2.6.X OS details: Linux 2.6.5 - 2.6.11 Uptime 26.627 days (since Thu May 11 18:56:31 2006) Service Info: OS: Unix Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds mysql MySQL Support Active Persistent Links Active Links Client API version 4.1.15 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost
Well, for starters don't worry about ports being open. If you werent able to connect, it would give you a different error message. select password('yourpassword'); and verify that the hash produced matches the password field in user exactly. -- James On Jun 7, 2006, at 11:48 AM, Aron Levy wrote: Hi good afternoon, i am triying to connect with my company's mysql server using a client program from shell and I keep receiving the following answer: [EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com Enter password: ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209' (using password: YES) [EMAIL PROTECTED] ~]# I already checked the user was configured for any host (%), the port 3306 is open (checked with nmap), but i dont know what i need to do or see other variables. I am 100% sure of the passwords i am using for this users, and i am attaching some info about the database. Thank you in advance, mysql select * from user; +---+--+--+- +-+-+-+-+--- +-+---+--+--- ++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+- +-+-+-+-+--- +-+---+--+--- ++-+++ | % | user1 | 5804b8eebr456240 | N | N | N | N | N | N | N | N | N| N | N | N | N | N | | % | user4 | 6f37d73jsdred201d | N | N | N | N | N | N | N | N | N| N | N | N | N | N | [EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07 09:57 VET Interesting ports on xx.xx.xx.xx: (The 1653 ports scanned but not shown below are in state: closed) PORT STATESERVICEVERSION 21/tcp open ftpProFTPD 1.2.10 22/tcp open sshOpenSSH 3.9p1 (protocol 1.99) 25/tcp open smtp netqmail smtpd 1.04 53/tcp open domain 80/tcp open http Apache httpd 2.0.53 ((Fedora)) 106/tcp open pop3pw poppassd 110/tcp open pop3 Courier pop3d 111/tcp open rpcbind 2 (rpc #10) 135/tcp filtered msrpc 139/tcp filtered netbios-ssn 143/tcp open imap Courier Imapd (released 2004) 443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora)) 445/tcp filtered microsoft-ds 465/tcp open ssl/smtp netqmail smtpd 1.04 593/tcp filtered http-rpc-epmap 993/tcp open ssl/imap Courier Imapd (released 2004) 995/tcp open ssl/pop3 Courier pop3d 1720/tcp filtered H.323/Q.931 3306/tcp open mysql MySQL 4.1.15 /tcp filtered krb524 8443/tcp open http Apache httpd 1.3.33 ((Unix) mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4) Device type: general purpose Running: Linux 2.6.X OS details: Linux 2.6.5 - 2.6.11 Uptime 26.627 days (since Thu May 11 18:56:31 2006) Service Info: OS: Unix Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds mysql MySQL Support Active Persistent Links Active Links Client API version 4.1.15 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient -- 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: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost
Hi James i follow your recomendation and verify that the hash produced matches the password field in user exactly. -- Aron L. James Barros wrote: Well, for starters don't worry about ports being open. If you werent able to connect, it would give you a different error message. select password('yourpassword'); and verify that the hash produced matches the password field in user exactly. -- James On Jun 7, 2006, at 11:48 AM, Aron Levy wrote: Hi good afternoon, i am triying to connect with my company's mysql server using a client program from shell and I keep receiving the following answer: [EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com Enter password: ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209' (using password: YES) [EMAIL PROTECTED] ~]# I already checked the user was configured for any host (%), the port 3306 is open (checked with nmap), but i dont know what i need to do or see other variables. I am 100% sure of the passwords i am using for this users, and i am attaching some info about the database. Thank you in advance, mysql select * from user; +---+--+--+- +-+-+-+-+--- +-+---+--+--- ++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+- +-+-+-+-+--- +-+---+--+--- ++-+++ | % | user1 | 5804b8eebr456240 | N | N | N | N | N | N | N | N | N| N | N | N | N | N | | % | user4 | 6f37d73jsdred201d | N | N | N | N | N | N | N | N | N| N | N | N | N | N | [EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07 09:57 VET Interesting ports on xx.xx.xx.xx: (The 1653 ports scanned but not shown below are in state: closed) PORT STATESERVICEVERSION 21/tcp open ftpProFTPD 1.2.10 22/tcp open sshOpenSSH 3.9p1 (protocol 1.99) 25/tcp open smtp netqmail smtpd 1.04 53/tcp open domain 80/tcp open http Apache httpd 2.0.53 ((Fedora)) 106/tcp open pop3pw poppassd 110/tcp open pop3 Courier pop3d 111/tcp open rpcbind 2 (rpc #10) 135/tcp filtered msrpc 139/tcp filtered netbios-ssn 143/tcp open imap Courier Imapd (released 2004) 443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora)) 445/tcp filtered microsoft-ds 465/tcp open ssl/smtp netqmail smtpd 1.04 593/tcp filtered http-rpc-epmap 993/tcp open ssl/imap Courier Imapd (released 2004) 995/tcp open ssl/pop3 Courier pop3d 1720/tcp filtered H.323/Q.931 3306/tcp open mysql MySQL 4.1.15 /tcp filtered krb524 8443/tcp open http Apache httpd 1.3.33 ((Unix) mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4) Device type: general purpose Running: Linux 2.6.X OS details: Linux 2.6.5 - 2.6.11 Uptime 26.627 days (since Thu May 11 18:56:31 2006) Service Info: OS: Unix Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds mysql MySQL Support Active Persistent Links Active Links Client API version 4.1.15 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient -- 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: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost
On 6/7/06, Aron Levy [EMAIL PROTECTED] wrote: Hi James i follow your recomendation and verify that the hash produced matches the password field in user exactly. -- Aron L. Well, that's weird, should be working. A shot in the dark: try starting your server with --old-passwords as an option and see if it works. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost
Can this use log in from localhost successfully? Try flushing privileges again? If that failed, I'd drop the user and recreate? ( Theres really not alot to this, sorry I don't have any more ideas :( ) -- James On Jun 7, 2006, at 1:07 PM, Aron Levy wrote: Hi James i follow your recomendation and verify that the hash produced matches the password field in user exactly. -- Aron L. James Barros wrote: Well, for starters don't worry about ports being open. If you werent able to connect, it would give you a different error message. select password('yourpassword'); and verify that the hash produced matches the password field in user exactly. -- James On Jun 7, 2006, at 11:48 AM, Aron Levy wrote: Hi good afternoon, i am triying to connect with my company's mysql server using a client program from shell and I keep receiving the following answer: [EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com Enter password: ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209' (using password: YES) [EMAIL PROTECTED] ~]# I already checked the user was configured for any host (%), the port 3306 is open (checked with nmap), but i dont know what i need to do or see other variables. I am 100% sure of the passwords i am using for this users, and i am attaching some info about the database. Thank you in advance, mysql select * from user; +---+--+--+- +-+-+-+- +--- +-+---+-- +--- ++-+ ++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+- +-+-+-+- +--- +-+---+-- +--- ++-+ ++ | % | user1 | 5804b8eebr456240 | N | N| N | N | N | N | N| N | N| N | N | N | N | N | | % | user4 | 6f37d73jsdred201d | N | N| N | N | N | N | N| N | N| N | N | N | N | N | [EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07 09:57 VET Interesting ports on xx.xx.xx.xx: (The 1653 ports scanned but not shown below are in state: closed) PORT STATESERVICEVERSION 21/tcp open ftpProFTPD 1.2.10 22/tcp open sshOpenSSH 3.9p1 (protocol 1.99) 25/tcp open smtp netqmail smtpd 1.04 53/tcp open domain 80/tcp open http Apache httpd 2.0.53 ((Fedora)) 106/tcp open pop3pw poppassd 110/tcp open pop3 Courier pop3d 111/tcp open rpcbind 2 (rpc #10) 135/tcp filtered msrpc 139/tcp filtered netbios-ssn 143/tcp open imap Courier Imapd (released 2004) 443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora)) 445/tcp filtered microsoft-ds 465/tcp open ssl/smtp netqmail smtpd 1.04 593/tcp filtered http-rpc-epmap 993/tcp open ssl/imap Courier Imapd (released 2004) 995/tcp open ssl/pop3 Courier pop3d 1720/tcp filtered H.323/Q.931 3306/tcp open mysql MySQL 4.1.15 /tcp filtered krb524 8443/tcp open http Apache httpd 1.3.33 ((Unix) mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4) Device type: general purpose Running: Linux 2.6.X OS details: Linux 2.6.5 - 2.6.11 Uptime 26.627 days (since Thu May 11 18:56:31 2006) Service Info: OS: Unix Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds mysql MySQL Support Active Persistent Links Active Links Client API version 4.1.15 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient -- 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 for user: 'apache@localhost' (Using password: NO)
I haven't tried it yet, but I'll try it next time it happens, to see if the problema disappears. We actually have some connection problems that can be relevant to my problem: Warning: Lost connection to MySQL server during query in /home/httpd/...some.php on line 9 We solved them by the PHP code: Now we reconnecto to mysql if the mysql_connect() command fails. If the connect command fails, then we try 10 more times. Could be that the connect command fails, then I start trying and trying, and then the server blocks because it receives too many connections? Then the error message would be the one that I'm getting? Thanx in advance, Jorge From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Date: Mon, 18 Apr 2005 18:38:54 +0300 Hello. It is strange that refusing message says you're not using passwords. Does the problem disappear after the FLUSH HOSTS statement, instead of restarting MySQL server? Jorge Cambra Aused [EMAIL PROTECTED] wrote: I have a web application running with Apache with PHP 4.1.2 (revision 7.2.6) and MySQL 3.23.58. The access from the PHP code to the MySQL server using the IP of the machine with MySQL, an username and a password, and it works fine. But sometimes we get the MySQL error: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) All the connections to the database fails for this reason, and we are sure that we are passing correctly the username, password and IP address. If we restart MySQL, then the problems disappears, and it works fine, but we don't know why it happens. The username that we are using to access MySQL is not 'apache', apache, as you can guess, is the name of the user that is running Apache. Thanx in advance, Jorge Cambra _ Descarga gratis la Barra de Herramientas de MSN http://www.msn.es/usuario/busqueda/barra?XAPID=2031DI=1055SU=http%3A//www.hotmail.comHL=LINKTAG1OPENINGTEXT_MSNBH -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Descubre la descarga digital con MSN Music. Más de medio millón de canciones. http://music.msn.es/ -- 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: 'apache@localhost' (Using password: NO)
Hello. Could be that the connect command fails, then I start trying and trying, and then the server blocks because it receives too many connections? Then the error message would be the one that I'm getting? I also thought about this and therefore I gave you that advice. What is in MySQL error log? Jorge Cambra Aused [EMAIL PROTECTED] wrote: I haven't tried it yet, but I'll try it next time it happens, to see if the problema disappears. We actually have some connection problems that can be relevant to my problem: Warning: Lost connection to MySQL server during query in /home/httpd/...some.php on line 9 We solved them by the PHP code: Now we reconnecto to mysql if the mysql_connect() command fails. If the connect command fails, then we try 10 more times. Could be that the connect command fails, then I start trying and trying, and then the server blocks because it receives too many connections? Then the error message would be the one that I'm getting? Thanx in advance, Jorge -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for user: 'apache@localhost' (Using password: NO)
I have a web application running with Apache with PHP 4.1.2 (revision 7.2.6) and MySQL 3.23.58. The access from the PHP code to the MySQL server using the IP of the machine with MySQL, an username and a password, and it works fine. But sometimes we get the MySQL error: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) All the connections to the database fails for this reason, and we are sure that we are passing correctly the username, password and IP address. If we restart MySQL, then the problems disappears, and it works fine, but we don't know why it happens. The username that we are using to access MySQL is not 'apache', apache, as you can guess, is the name of the user that is running Apache. Thanx in advance, Jorge Cambra _ Descarga gratis la Barra de Herramientas de MSN http://www.msn.es/usuario/busqueda/barra?XAPID=2031DI=1055SU=http%3A//www.hotmail.comHL=LINKTAG1OPENINGTEXT_MSNBH -- 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: 'apache@localhost' (Using password: NO)
Hello. It is strange that refusing message says you're not using passwords. Does the problem disappear after the FLUSH HOSTS statement, instead of restarting MySQL server? Jorge Cambra Aused [EMAIL PROTECTED] wrote: I have a web application running with Apache with PHP 4.1.2 (revision 7.2.6) and MySQL 3.23.58. The access from the PHP code to the MySQL server using the IP of the machine with MySQL, an username and a password, and it works fine. But sometimes we get the MySQL error: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) All the connections to the database fails for this reason, and we are sure that we are passing correctly the username, password and IP address. If we restart MySQL, then the problems disappears, and it works fine, but we don't know why it happens. The username that we are using to access MySQL is not 'apache', apache, as you can guess, is the name of the user that is running Apache. Thanx in advance, Jorge Cambra _ Descarga gratis la Barra de Herramientas de MSN http://www.msn.es/usuario/busqueda/barra?XAPID=2031DI=1055SU=http%3A//www.hotmail.comHL=LINKTAG1OPENINGTEXT_MSNBH -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
Howdy all, I keep getting this error when I try to issue: mysql mysql -u root -p the same thing happens when I substitute any other database name, not just mysql. I have another,nearly identical machine from which I copied the contents of /var/lib/mysql/mysql/ . The permissions all appear to be fine. This is a new problem, it started after I changed the firewall settings to activate port 3306.. don't know if that's what caused this somehow. Oddly enough, I can access the database from a remote machine with no problem. Any help would be much appreciated. sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Hello. mysqladmin:connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' ... shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid --skip-grand-tables [1] 28712 shell Starting mysql deamon with databses from /var/db/mysql 050303 21:04:02 mysql ended Looks like mysqld didn't started properly. What is in the error log? shell mysql -u root -p mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt old password or without password. We'll check this after solving the problem with the daemon's start. Deniss Hennesy [EMAIL PROTECTED] wrote: Hi, I have had to change mysql root passwd My procedure is just below shell mysql -u root -p mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt old password or without password. Now neither new passwd nor old passwd also empty passwd is not acceped I change my mind and I tried that procedure shell kill `cat /var/db/host_name.pid` shell mysqld_safe --skip-grant-tables shell mysqladmin -u root flush-privileges password newpwd mysqladmin:connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysql is running and that the socket:'/tmp/mysql.sock' exits! 3rd way is shell/usr/local/etc/rc.d/mysql-server.sh stop then shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid --skip-grand-tables [1] 28712 shell Starting mysql deamon with databses from /var/db/mysql 050303 21:04:02 mysql ended So I suppose that it is not initialize MySQL deamon isnt it??? How I can recover mysql password?!?? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Hi, I have had to change mysql root passwd My procedure is just below shell mysql -u root -p mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt old password or without password. Now neither new passwd nor old passwd also empty passwd is not acceped I change my mind and I tried that procedure shell kill `cat /var/db/host_name.pid` shell mysqld_safe --skip-grant-tables shell mysqladmin -u root flush-privileges password newpwd mysqladmin:connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysql is running and that the socket:'/tmp/mysql.sock' exits! 3rd way is shell/usr/local/etc/rc.d/mysql-server.sh stop then shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid --skip-grand-tables [1] 28712 shell Starting mysql deamon with databses from /var/db/mysql 050303 21:04:02 mysql ended So I suppose that it is not initialize MySQL deamon isnt it??? How I can recover mysql password?!?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Hi, I have had to change mysql root passwd My procedure is just below shell mysql -u root -p mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt old password or without password. Now neither new passwd nor old passwd also empty passwd is not acceped I change my mind and I tried that procedure shell kill `cat /var/db/host_name.pid` shell mysqld_safe --skip-grant-tables shell mysqladmin -u root flush-privileges password newpwd mysqladmin:connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysql is running and that the socket:'/tmp/mysql.sock' exits! 3rd way is shell/usr/local/etc/rc.d/mysql-server.sh stop then shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid --skip-grand-tables [1] 28712 shell Starting mysql deamon with databses from /var/db/mysql 050303 21:04:02 mysql ended So I suppose that it is not initialize MySQL deamon isnt it??? How I can recover mysql password?!?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Deniss Hennesy wrote: Hi, I have had to change mysql root passwd My procedure is just below shell mysql -u root -p mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql flush privileges; YOu may be need to execute command mysqladmin -u root password (yourpassword) for the creation of password. I m not sure, not expert in DBA. Sam and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt old password or without password. -- 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
Hello. I successufully connected to MySQL server using your parameters in odbc.ini and odbcinst.ini files from php. [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) You have specified the user and the password in the ODBC configuration files, but your scripts don't use them. I think the problem is in your connection string which you are specifying in the odbc_connect(). Dan Wareham [EMAIL PROTECTED] wrote: Hello, I have a Linux server running Apache, MySQL, unixODBC, MyODBC In my odbcinst.ini file I have the following: [MySQL] Description= ODBC for MySQL Driver = /usr/local/lib/libmyodbc3.so FileUsage = 1 I have setup the following system DSN in the odbc.ini file: [PbDatabase] Description = System DSN Driver = /usr/local/lib/libmyodbc3.so Host = localhost Server = localhost User = username Password = password Port = 3306 Database = Database01 Option = 3 However, when I use the System DSN name in my scripts I get the following error: 350 Native SQL Error Code [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) The user apacheusr is the username that the Apache webserver is running under. I've tried adding this user to the MySQL user table but the error still shows. However, if I add the Username and Password along with the DSN name to my scripts within my HTML pages then the connection is made and records from the database returned. Any ideas why this might be happening?? Is it a permissions issue with MySQL or with unixODBC or Apache?? Any help would be greatly appreciated. Thanks in advance [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access Denied For User
Hello, I have a Linux server running Apache, MySQL, unixODBC, MyODBC In my odbcinst.ini file I have the following: [MySQL] Description= ODBC for MySQL Driver = /usr/local/lib/libmyodbc3.so FileUsage = 1 I have setup the following system DSN in the odbc.ini file: [PbDatabase] Description = System DSN Driver = /usr/local/lib/libmyodbc3.so Host = localhost Server = localhost User = username Password = password Port = 3306 Database = Database01 Option = 3 However, when I use the System DSN name in my scripts I get the following error: 350 Native SQL Error Code [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) The user apacheusr is the username that the Apache webserver is running under. I've tried adding this user to the MySQL user table but the error still shows. However, if I add the Username and Password along with the DSN name to my scripts within my HTML pages then the connection is made and records from the database returned. Any ideas why this might be happening?? Is it a permissions issue with MySQL or with unixODBC or Apache?? Any help would be greatly appreciated. Thanks in advance [EMAIL PROTECTED] -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 266.4.0 - Release Date: 22/02/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for user - I cant work this out
Hi All, I am consistently getting; Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I am connecting through php with the same script I use all the time, I have checked it and dbl checked it for problems. I can connect to mysql in a prompt and I have added new users with all priv's and connected with them - obviously its more a server issue than mysql (I think)... MySQL version is 4.0.21 PHP Version 4.3.8 On a Win2k server using apache 2 (just a local testing server). Any info would be muchly appreciated. Christian -- 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 - I cant work this out
hi you are not passing a password to mysql - check your code to see if this is correct. Peter -Original Message- From: Christian Biggins [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 12:27 To: mysql@lists.mysql.com Subject: Access denied for user - I cant work this out Hi All, I am consistently getting; Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I am connecting through php with the same script I use all the time, I have checked it and dbl checked it for problems. I can connect to mysql in a prompt and I have added new users with all priv's and connected with them - obviously its more a server issue than mysql (I think)... MySQL version is 4.0.21 PHP Version 4.3.8 On a Win2k server using apache 2 (just a local testing server). Any info would be muchly appreciated. Christian -- 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 for user - I cant work this out
Hi Peter, There is a password being suppled - see code (btw, its local testing only, hence the root user) //Database Settings $db_host = 'localhost'; //database hostname $db_name = 'powerpla_powerplay'; //database name $db_user = 'root'; //database USER name $db_pass = 'rootpass'; // database password function db_connect() { if ($dbc = @mysql_connect($db_host, $db_user, $db_pass)) { if (!mysql_select_db($db_name)) { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } else { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 January 2005 12:27 AM To: Christian Biggins; mysql@lists.mysql.com Subject: RE: Access denied for user - I cant work this out hi you are not passing a password to mysql - check your code to see if this is correct. Peter -Original Message- From: Christian Biggins [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 12:27 To: mysql@lists.mysql.com Subject: Access denied for user - I cant work this out Hi All, I am consistently getting; Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I am connecting through php with the same script I use all the time, I have checked it and dbl checked it for problems. I can connect to mysql in a prompt and I have added new users with all priv's and connected with them - obviously its more a server issue than mysql (I think)... MySQL version is 4.0.21 PHP Version 4.3.8 On a Win2k server using apache 2 (just a local testing server). Any info would be muchly appreciated. Christian -- 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 for user - I cant work this out
The problem is with your php. Just as a test, print $db_host,$db_user,$db_pass in your function before you try the connect. My guess is that they will be blank. The reason for this is that you assign them outside of the function. This means you either need to pass them to the function or explicitly state that they are global. Since these are all blank, it is using the defaults, which on windows are localhost, ODBC, and no password. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Christian Biggins Sent: Wednesday, January 26, 2005 7:30 AM Subject: RE: Access denied for user - I cant work this out Hi Peter, There is a password being suppled - see code (btw, its local testing only, hence the root user) //Database Settings $db_host = 'localhost'; //database hostname $db_name = 'powerpla_powerplay'; //database name $db_user = 'root'; //database USER name $db_pass = 'rootpass'; // database password function db_connect() { if ($dbc = @mysql_connect($db_host, $db_user, $db_pass)) { if (!mysql_select_db($db_name)) { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } else { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } -Original Message- From: Peter Lovatt Sent: Thursday, 27 January 2005 12:27 AM To: Christian Biggins; mysql@lists.mysql.com Subject: RE: Access denied for user - I cant work this out hi you are not passing a password to mysql - check your code to see if this is correct. Peter -Original Message- From: Christian Biggins Sent: 26 January 2005 12:27 To: mysql@lists.mysql.com Subject: Access denied for user - I cant work this out Hi All, I am consistently getting; Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I am connecting through php with the same script I use all the time, I have checked it and dbl checked it for problems. I can connect to mysql in a prompt and I have added new users with all priv's and connected with them - obviously its more a server issue than mysql (I think)... MySQL version is 4.0.21 PHP Version 4.3.8 On a Win2k server using apache 2 (just a local testing server). Any info would be muchly appreciated. Christian -- 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 - I cant work this out
Hi If this is verbatim code the connection string is inside the function and the connection parameters are outside, so they will not be available to the mysql_connect() Try function db_connect() { //Database Settings $db_host = 'localhost'; //database hostname $db_name = 'powerpla_powerplay'; //database name $db_user = 'root'; //database USER name $db_pass = 'rootpass'; // database password if ($dbc = @mysql_connect($db_host, $db_user, $db_pass)) { if (!mysql_select_db($db_name)) { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } else { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } HTH Peter -Original Message- From: Christian Biggins [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 13:30 To: 'Peter Lovatt'; mysql@lists.mysql.com Subject: RE: Access denied for user - I cant work this out Hi Peter, There is a password being suppled - see code (btw, its local testing only, hence the root user) //Database Settings $db_host = 'localhost'; //database hostname $db_name = 'powerpla_powerplay'; //database name $db_user = 'root'; //database USER name $db_pass = 'rootpass'; // database password function db_connect() { if ($dbc = @mysql_connect($db_host, $db_user, $db_pass)) { if (!mysql_select_db($db_name)) { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } else { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 January 2005 12:27 AM To: Christian Biggins; mysql@lists.mysql.com Subject: RE: Access denied for user - I cant work this out hi you are not passing a password to mysql - check your code to see if this is correct. Peter -Original Message- From: Christian Biggins [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 12:27 To: mysql@lists.mysql.com Subject: Access denied for user - I cant work this out Hi All, I am consistently getting; Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I am connecting through php with the same script I use all the time, I have checked it and dbl checked it for problems. I can connect to mysql in a prompt and I have added new users with all priv's and connected with them - obviously its more a server issue than mysql (I think)... MySQL version is 4.0.21 PHP Version 4.3.8 On a Win2k server using apache 2 (just a local testing server). Any info would be muchly appreciated. Christian -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1044 (42000): Access denied for user 'root'
Hello. What says: show grants for current_user(); [EMAIL PROTECTED] wrote: Hi, As the root user I created a DB a populated with tables... but when I want to create a user to handle that DB i get this error message: mysql grant all on db.* to [EMAIL PROTECTED] identified by 'password'; ERROR 1044 (42000): Access denied for user 'root' What could be the reason??? I though the mysql root user was analogous to the unix counterpart Thanks a lot in advance for your help. Regards, Ed -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1044 (42000): Access denied for user 'root'
Hi, As the root user I created a DB a populated with tables... but when I want to create a user to handle that DB i get this error message: mysql grant all on db.* to [EMAIL PROTECTED] identified by 'password'; ERROR 1044 (42000): Access denied for user 'root' What could be the reason??? I though the mysql root user was analogous to the unix counterpart Thanks a lot in advance for your help. Regards, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 1044 (42000): Access denied for user 'root'
Ed, It sounds like root doesn't have the GRANT permission for the localhost. You can check by querying the User table in mysql. --Dave David W. Juntgen Medical Informatics Engineering Inc. Phone: 260.459.6270 Fax : 260.459.6271 -Original Message- From: Guru Vai Kernel-Hacker!!! [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: ERROR 1044 (42000): Access denied for user 'root' Hi, As the root user I created a DB a populated with tables... but when I want to create a user to handle that DB i get this error message: mysql grant all on db.* to [EMAIL PROTECTED] identified by 'password'; ERROR 1044 (42000): Access denied for user 'root' What could be the reason??? I though the mysql root user was analogous to the unix counterpart Thanks a lot in advance for your help. Regards, Ed -- 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]
ERROR 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)
User mysqladmin has not the rights to access mysql? How can that be? Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)
mysqladmin is an executable. Did you set up an user named mysqladmin that can connect from the localhost? -Original Message- From: Laurent To: [EMAIL PROTECTED] Sent: 7/19/04 6:55 AM Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) User mysqladmin has not the rights to access mysql? How can that be? Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- 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: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)
On Monday 19 July 2004 14:59, Victor Pendleton wrote: mysqladmin is an executable. Did you set up an user named mysqladmin that can connect from the localhost? Exactly, it should be able to connect, but it doesn't. Should I change the name from mysqladmin to mysql or something similar? I'll try. Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)
On Mon, 19 Jul 2004, Laurent wrote: On Monday 19 July 2004 14:59, Victor Pendleton wrote: mysqladmin is an executable. Did you set up an user named mysqladmin that can connect from the localhost? Exactly, it should be able to connect, but it doesn't. Should I change the name from mysqladmin to mysql or something similar? I'll try. Laurent Laurent, with a fresh install, use 'root' as username and no password. Be sure to set a password later. Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)
Have you tried another user. -Original Message- From: Laurent To: [EMAIL PROTECTED] Sent: 7/19/04 8:07 AM Subject: Re: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (U sing password: YES) On Monday 19 July 2004 14:59, Victor Pendleton wrote: mysqladmin is an executable. Did you set up an user named mysqladmin that can connect from the localhost? Exactly, it should be able to connect, but it doesn't. Should I change the name from mysqladmin to mysql or something similar? I'll try. Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- 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: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)
Laurent [EMAIL PROTECTED] wrote: User mysqladmin has not the rights to access mysql? How can that be? Have you created the mysqladmin user? By default there is no such user and it's not supposed to be there. There is no special meaning for it - mysqladmin usually logs in as root user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for user: 'root@localhost' (Using password: NO)
Hi - I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would get the error of 'Access denied for user: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' (Using password: NO)'. Could someone please tell me what I need to set or did not set. Thank you. -- 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: 'root@localhost' (Using password: NO)
Re-installing does not get rid of your old passwords. You need to use the -p option. Nguyen, Long P (Mission Systems) wrote: Hi - I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would get the error of 'Access denied for user: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' (Using password: NO)'. Could someone please tell me what I need to set or did not set. Thank you. -- 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: 'root@localhost' (Using password: NO)
shouldn't I be able to issue commands at the shell it goes and does it thing and give back output? or does this mean I have a passwd already set and it's secured? -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 8:57 AM To: Nguyen, Long P (Mission Systems) Cc: [EMAIL PROTECTED] Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Re-installing does not get rid of your old passwords. You need to use the -p option. Nguyen, Long P (Mission Systems) wrote: Hi - I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would get the error of 'Access denied for user: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' (Using password: NO)'. Could someone please tell me what I need to set or did not set. Thank you. -- 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: 'root@localhost' (Using password: NO)
On Thursday 01 July 2004 09:08 am, Nguyen, Long P (Mission Systems) wrote: shouldn't I be able to issue commands at the shell it goes and does it thing and give back output? or does this mean I have a passwd already set and it's secured? http://dev.mysql.com/doc/mysql/en/User_Account_Management.html This might help you out. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)
Marc Tardif [EMAIL PROTECTED] wrote: I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release 9 (Shrike). First, I create a database and user to connect to this database using the following commands: mysql CREATE DATABASE foo; mysql GRANT ALL PRIVILEGES ON foo.* TO foo@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; mysql GRANT ALL PRIVILEGES ON foo.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH GRANT OPTION; mysql FLUSH PRIVILEGES; Then, I try to connect to the database using the host parameter but I get the following error message: # mysql --user=foo --password=password -h host foo ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I've only managed to find a single thread about this issue which was a bug in the installation of mysql on RedHat 7. Many months have gone by since then so I wonder if this is still the same issue. Delete from the table User entry for user ''@'localhost' and then FLUSH PRIVILEGES. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)
I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release 9 (Shrike). First, I create a database and user to connect to this database using the following commands: mysql CREATE DATABASE foo; mysql GRANT ALL PRIVILEGES ON foo.* TO foo@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; mysql GRANT ALL PRIVILEGES ON foo.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH GRANT OPTION; mysql FLUSH PRIVILEGES; Then, I try to connect to the database using the host parameter but I get the following error message: # mysql --user=foo --password=password -h host foo ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I've only managed to find a single thread about this issue which was a bug in the installation of mysql on RedHat 7. Many months have gone by since then so I wonder if this is still the same issue. -- Marc Tardif Sitepak (514) 866-8883 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
Dear friends, I have a question about mysql. I installed mysql on windows 2000, after I started the mysql, I tried to create a database, but I was denied, I got message: mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql CREATE DATABASE menagerie; ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' I have read the documentation again and again, it show I can create a host file, but ite does not say what kind file it is and where I should put it. How can I fix it? Thank you for your help Luke Sui - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger
Re: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
c s wrote: Dear friends, I have a question about mysql. I installed mysql on windows 2000, after I started the mysql, I tried to create a database, but I was denied, I got message: mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql CREATE DATABASE menagerie; ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' You did not start mysql as root. mysql -u root I have read the documentation again and again, it show I can create a host file, but ite does not say what kind file it is and where I should put it. How can I fix it? Read the section of the manual on permissions. Thank you for your help Luke Sui - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)
I'm having a problem similar to the one mentioned in the list message http://lists.mysql.com/mysql/165952 * I built, installed, and run MySQL 4.0.18 o gcc 2.95.3 on Solaris 9 * I created a user abcd and used MyPHPAdmin to give this user a password xxyyzzaa * I can login using the command-line 'mysql -u abcd' * I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa' o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) * As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have verified the password field for 'abcd' was instantiated. Can anyone inform me how to cause MySQL to use passwords? Thank you. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain
Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)
Jack Woehr wrote: I'm having a problem similar to the one mentioned in the list message http://lists.mysql.com/mysql/165952 * I built, installed, and run MySQL 4.0.18 o gcc 2.95.3 on Solaris 9 * I created a user abcd and used MyPHPAdmin to give this user a password xxyyzzaa * I can login using the command-line 'mysql -u abcd' * I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa' o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) * As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have verified the password field for 'abcd' was instantiated. Can anyone inform me how to cause MySQL to use passwords? Thank you. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain From your description, I would guess that: - You created the user as [EMAIL PROTECTED] - You have not deleted the anonymous user, ''@localhost. When connecting, mysql looks for the best match of user and host. Best match is done host first, user second. Hence, ''@localhost is chosen over [EMAIL PROTECTED] when [EMAIL PROTECTED] connects. You can verify this by entering SELECT CURRENT_USER(); at the mysql prompt. You have two options: 1) Most people, I believe, solve this by deleting the anonymous user: mysql -u root -p mysql DELETE FROM user WHERE User=''; FLUSH PRIVILEGES; 2) Create an explicit entry for [EMAIL PROTECTED], which will take precedence over ''@localhost, as both the host and user will match. A few notes on security: * Deleting the anonymous user is probably a good idea anyway. As long as it's there, anyone can connect. * Make the host part of your users as specific as possible. Do you really want abcd to be able to connect from any IP in the world? One option would be to only allow localhost connections. Then abcd would have to ssh to your server and run mysql locally. Of course, that requires giving abcd shell access, which you may not want. In that case, consider if you can limit the set of machines from which connections should be allowed. Perhaps [EMAIL PROTECTED] or [EMAIL PROTECTED] * Don't put the password on the command line. That makes it visible to anyone running ps at the right moment. Instead, just use -p to be prompted for the password. I.e. mysql -u abcd -p See the manual http://dev.mysql.com/doc/mysql/en/Privilege_system.html for the details. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)
Jack Woehr [EMAIL PROTECTED] wrote: I'm having a problem similar to the one mentioned in the list message http://lists.mysql.com/mysql/165952 * I built, installed, and run MySQL 4.0.18 o gcc 2.95.3 on Solaris 9 * I created a user abcd and used MyPHPAdmin to give this user a password xxyyzzaa * I can login using the command-line 'mysql -u abcd' Seems you connected as anonymous user. Check it with SELECT CURRENT_USER() function. * I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa' o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) * As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have verified the password field for 'abcd' was instantiated. Can anyone inform me how to cause MySQL to use passwords? Thank you. Connect as a root and delete from table mysql.user entry for user ''@'localhost'. Then execute FLUSH PRIVILEGES command. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED
I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to login without password, MySQL interestingly interprets that as even known users with passwords MUST log in without passwords. My two solutions were either to delete the ANY privileges or to create a second account for [EMAIL PROTECTED] with a password required to supplement the [EMAIL PROTECTED] with a password required. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED
Jack Woehr wrote: I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to login without password, MySQL interestingly interprets that as even known users with passwords MUST log in without passwords. Well, that seems to be the effect, but that's not what it is doing. Mysql sorts possible matches of incoming [EMAIL PROTECTED] against the mysql.user table hostname first. So, you had two matches when abcd connected from localhost: ''@localhost and [EMAIL PROTECTED] Explicit text is preferred to wildcards in ranking by specificity, so localhost is a better hostname match than %, hence ''@localhost is chosen. My two solutions were either to delete the ANY privileges or to create a second account for [EMAIL PROTECTED] with a password required to supplement the [EMAIL PROTECTED] with a password required. Right. Either of these will work. If you add an [EMAIL PROTECTED] entry, when abcd connects from localhost, mysql finds three matches: [EMAIL PROTECTED], ''@localhost, and [EMAIL PROTECTED] Again, localhost is preferred over %, and within localhost abcd is preferred over '', so you get [EMAIL PROTECTED] as the match. On the other hand, if you remove the anonymous user, then [EMAIL PROTECTED] is the only possible match when abcd connects from localhost, so it is chosen. Michael -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for user: 'root@localhost' (Using password: NO)
Hello, I would be happy to solve the following problem : I get every week the following message on my Linux root mail account : /etc/cron.daily/logrotate: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' I looked many times on Internet for this kind of problem, and I found many pages and suggestions about it, but none of them seem to work. Most suggest to add lines to the files $HOME/.my.cnf or /etc/my.cnf So I have now : $HOME/.my.cnf = [client] # The following password will be sent to all standard MySQL clients password=myrootpassword # of course you will not know the actual password :-) After spending some time on it, I finished by gaving up, as this mail file is not as much annoying than the time needed for finding the information, and the database seems to work otherwise. This was at least one year ago. But now I get the same message when trying to install another product (i.e. the perl script DBD::mysql), so I am unable to install it. The log file for mysqld doesn't give better information, it tells the same thing : Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) If I just type mysql at command line (as root), it works without error, and without asking me any password. So I suppose that .my.cnf is correctly read : if I remove the password from it, this last command no longer works without password. I have one user 'root' in the table 'mysql.user' with a password and all permissions. My Linux's process list shows me two processes running about it : safe_mysqld running as root, and mysqld-max running as mysql. (changing the latter one to root doesn't solve the problem) I use MySQL version 4.0.13-Max on Linux RedHat 9.0 Please, could someone tell me how to make MySQL handling my root password correctly ? Thank you very much for any advice. Gingko. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for user: 'root@localhost'
Hi All, I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time seemed to actually got somewhere! however, my existing PHP scripts failed to connect to localhost as the password has not been set after the install. I ran the following command (obviously seriously misunderstood the docs) mysqladmin -u root password new-password I thought the above syntax would ask me for the password but it didn't now all commands return 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' How do I actually set a password, and more importantly, how do I reset the password for root, and what did I do? Any help will be greatly appreciated. TIA Phil. -- 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: 'root@localhost'
Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote: Hi All, I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time seemed to actually got somewhere! however, my existing PHP scripts failed to connect to localhost as the password has not been set after the install. I ran the following command (obviously seriously misunderstood the docs) mysqladmin -u root password new-password I thought the above syntax would ask me for the password but it didn't now all commands return 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' How do I actually set a password, and more importantly, how do I reset the password for root, and what did I do? Any help will be greatly appreciated. Initially user root doesn't have a password. If you set password you should specify password when you connect to the MySQL server with -p option for command-line clients. For example: shell mysql -uroot -proot_password or shell mysql -uroot -p and then type a password. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for user 'lrmt@iidcm063' ( Using password: YES)
hi all I have installed mysql and I created an users call lrmt and password is lrmt. So from command line(mysql -u lrmt -p lrmt) i can enter to mysql with out any problem and also with mysql -u root -p socket. I used this command to give permission to user GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'mysqlpassword' GRANT ALL ON database.* TO mysqlusername\@'%' IDENTIFIED BY 'mysqlpassword' But through script I cannot access the database it shows an error message DBI connect ('lab:iidcm063.iidc.lucent.com','lrmt',...) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at test.cgi line 20. This script is running from apache. The apache log file displays the same message when I run the script through Internet browser. And also I got this error message when I run this script from command line.. Please help me to solve the problem. to access database through script what permission I have to set in mysql databases and table (user, db, host, table) .. if possible just send me the query that I can execute on mysql database to solve this problem. Regards joby james -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]