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 -p 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 : > 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 : > > > >> > >> 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 > >>> > >>> 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= > >> > >> *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)
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 : > > 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 > > > > 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= > > *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)
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 :
> 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 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
>>
>> 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
>>
>
>
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 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
error - ould be looked up with ./bin/resolveip
hi I am facing the following : mac:mysql-5.6.16-linux-glibc2.5-x86_64 ericomtx$ sudo scripts/mysql_install_db --user=mysql sh: ./bin/my_print_defaults: cannot execute binary file FATAL ERROR: Neither host 'mac.local' nor 'localhost' could be looked up with ./bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option how my /etc/hosts file should look like so I can fix this ?
Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin
ok I have tried these : ifconfig -a lo0: flags=8049 mtu 16384 inet6 ::1 prefixlen 128 inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 inet 127.0.0.1 netmask 0xff00 gif0: flags=8010 mtu 1280 stf0: flags=0<> mtu 1280 fw0: flags=8863 mtu 4078 lladdr 70:cd:60:ff:fe:eb:72:ea media: autoselect status: inactive en1: flags=8863 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=8863 mtu 1500 ether c8:2a:14:1a:47:ea media: autoselect (none) status: inactive wc2: flags=822 mtu 1500 ether 00:02:55:11:19:76 media: 1000baseT () = 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 > 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 > 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>> > > > > 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 <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 > >
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 > 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 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 > On 13 January 2014 13:25, Érico 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 > > > >> I forgot this. Do it too. > >> > >> On 13 January 2014 13:01, Erick Ocrospoma 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 > >> ; > >> $> 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 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 > >> >>> > >> >>> 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 -h localhost -P 3306 > &g
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 > I forgot this. Do it too. > > On 13 January 2014 13:01, Erick Ocrospoma 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 > ; > $> 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 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 > >>> > >>> 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 -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 > 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
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 > 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 -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 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 > > > 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 > > > >
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
installing mysql from src
I have followed the steps from bellow to install mysql from src on my linux ( red hat 6 ) : shell> groupadd mysql shell> useradd -r -g mysql mysql # Beginning of source-build specific instructions shell> tar zxvf mysql-VERSION.tar.gz shell> cd mysql-VERSION shell> cmake . shell> make shell> make install all these as root the point is that it did not install into /usr/local but into /usr/share these worked fine : # Postinstallation setup shell> cd /usr/local/mysql shell> chown -R mysql . shell> chgrp -R mysql . but I can not create the DB or start the server : 1. [root@ericomtx bin]# pwd /usr/bin [root@ericomtx bin]# ls -la mysql* -rwxr-xr-x. 1 root root 4984411 Nov 15 13:26 mysql -rwxr-xr-x. 1 root root 110776 Nov 15 13:24 mysqlaccess -rwxr-xr-x. 1 root root1702 Apr 9 2010 mysqlaccess.conf -rwxr-xr-x. 1 root root 4290406 Nov 15 13:26 mysqladmin -rwxr-xr-x. 1 root root 4841390 Nov 15 13:26 mysqlbinlog -rwxr-xr-x. 1 root root 10349 Nov 15 13:24 mysqlbug -rwxr-xr-x. 1 root root 4281034 Nov 15 13:26 mysqlcheck -rwxr-xr-x. 1 root root 4994249 Nov 15 13:26 mysql_client_test -rwxr-xr-x. 1 root root6456 Nov 15 13:24 mysql_config -rwxr-xr-x. 1 root root4169 Nov 15 13:24 mysql_convert_table_format -rwxr-xr-x. 1 root root 22389 Nov 15 13:24 mysqld_multi -rwxr-xr-x. 1 root root 21432 Nov 15 13:24 mysqld_safe -rwxr-xr-x. 1 root root 4473050 Nov 15 13:26 mysqldump -rwxr-xr-x. 1 root root6602 Nov 15 13:24 mysqldumpslow -rwxr-xr-x. 1 root root3245 Nov 15 13:24 mysql_find_rows -rwxr-xr-x. 1 root root 483 Nov 15 13:24 mysql_fix_extensions -rwxr-xr-x. 1 root root 32209 Nov 15 13:24 mysqlhotcopy -rwxr-xr-x. 1 root root 4287853 Nov 15 13:26 mysqlimport -rwxr-xr-x. 1 root root 14472 Nov 15 13:24 mysql_install_db -rwxr-xr-x. 1 root root7694 Nov 15 13:24 mysql_secure_installation -rwxr-xr-x. 1 root root 16689 Nov 15 13:24 mysql_setpermission -rwxr-xr-x. 1 root root 4278732 Nov 15 13:26 mysqlshow -rwxr-xr-x. 1 root root 4331143 Nov 15 13:26 mysqlslap -rwxr-xr-x. 1 root root 4845542 Nov 15 13:26 mysqltest -rwxr-xr-x. 1 root root 729588 Nov 15 13:26 mysql_tzinfo_to_sql -rwxr-xr-x. 1 root root 1017021 Nov 15 13:26 mysql_upgrade -rwxr-xr-x. 1 root root 888746 Nov 15 13:26 mysql_waitpid -rwxr-xr-x. 1 root root3818 Nov 15 13:24 mysql_zap [root@ericomtx bin]# ./mysql_install_db --user =mysql 121116 14:50:18 [ERROR] Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50080, now running 50504. Please use mysql_upgrade to fix this error. ERROR: 1558 Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50080, now running 50504. Please use mysql_upgrade to fix this error. 121116 14:50:18 [ERROR] Aborting but I CAN NOT update MySQL ... it doesn allow me to : [root@ericomtx bin]# ./mysql_upgrade Looking for 'mysql' as: ./mysql Looking for 'mysqlcheck' as: ./mysqlcheck Running 'mysqlcheck with default connection arguments ./mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed [root@ericomtx bin]# also ... you may say to me so I need to create the DB from my install dir ... ok : [root@ericomtx mysql-5.5.4-m3]# scripts/mysql_install_db --user=mysql WARNING: The host '' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Installing MySQL system tables... 121116 14:53:47 [Note] Buffered information: Performance schema disabled (reason: start parameters). 121116 14:53:47 [ERROR] Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50080, now running 50504. Please use mysql_upgrade to fix this error. ERROR: 1558 Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50080, now running 50504. Please use mysql_upgrade to fix this error. 121116 14:53:47 [ERROR] Aborting 121116 14:53:47 [Note] /usr/sbin/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can try to start the mysqld daemon with: shell> /usr/sbin/mysqld --skip-grant & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/. Please check all of the above before mailing us! And rememb
