[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 ?
|