[Mysql-admin-updates] Access denied for user 'root'@localhost' (using password: YES / NO)
Brought to you by:
berniwa
From: Érico <eri...@gm...> - 2014-01-16 18:24:25
|
Hi I have installed mysql admin on my macbook pro ( 10.6.8 ) 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> ... I am also albe to access the db through eclipse using jconnector ... but I can't access the aplication through the web ( apache 2.2.26 ) I get the error : Access denied for user 'root'@'localhost' (using password: YES) or Access denied for user 'root'@'localhost' (using password: NO) ... this also works ... my environment : ifconfig -a lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 16384 inet6 ::1 prefixlen 128 inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 inet 127.0.0.1 netmask 0xff000000 gif0: flags=8010<POINTOPOINT,MULTICAST> mtu 1280 stf0: flags=0<> mtu 1280 fw0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 4078 lladdr 70:cd:60:ff:fe:eb:72:ea media: autoselect <full-duplex> status: inactive en1: flags=8863<UP,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 0xffff0000 broadcast 169.254.255.255 media: autoselect status: active en0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500 ether c8:2a:14:1a:47:ea media: autoselect (none) status: inactive wc2: flags=822<BROADCAST,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 ffffff801403c280 stream 0 0 0 ffffff801403b200 0 0 /tmp/mysql.sock ffffff801403a9c0 stream 0 0 ffffff801bbb78b8 0 0 0 /tmp/mysql.sock ========================================================================= mac:lib ericomtx$ ps xa | grep mysqld 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 my /etc/hosts : 127.0.0.1 localhost.local localhost ::1 localhost6.local6 localhost6 127.0.0.1 mac mac mac: ericomtx ========================================================================= and ... my PASS.php : <?php // Connection settings $RMUSER = "root"; //username for mysql server $RMPASS = "my_correct_pwd"; //password for mysql server $RMSERVER = "localhost"; //server address $RMDATABASE = "mysql-admin"; //database name ?> please any idea on what this be ? |