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 -p<my_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
