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
./mysql -h 127.0.01 --port=3306 --protocol=TCP -u root -p mysql-admin
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN