To change the root password i connected to mysql: bin/mysql
mysql>connect mysql localhost
mysql>UPDATE user set Password='***' where User='root';
->No problems
mysql>SELECT User,Password FROM user;
-> to verify if the pass was set... it was.
then i stopped mysql and restart it and it was impossib
i can now connect to mysql but when i login as root with the root
password i get the ERROR 1044 : Access denied.
if i don't give any password i can connect but if i write:
mysql> use mysql
i've got the same message, so i can't do anything neither connect nor
create database,tables...
-i made the
hi,
i've Mysql installed on linux, binary install,
i launched the server : bin/safe_mysqld &
and if i try to connect to mysql ( mysql -u root -p mysql ) i get this
message :
Can't connect to local Mysql server (111)
i tried : mysql -u root test but i get the same message.
how to debug this ???