Hi folks,


Having tried > 2 hours without a solution. Users can't login Mysql, passwords being correct.


Steps performed as follow;

$ mysql -u user -p
Code:
Enter password: some_password
ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)
$ sudo /etc/init.d/mysql start
Code:
Password:
Starting MySQL database server: mysqld already running.
$ mysql -uroot -p
Code:
Enter password:
Welcome to the MySQL monitor.  Commands end ....

mysql> GRANT ALL PRIVILEGES ON *.* TO user@"%"
    -> IDENTIFIED BY 'some_password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.11 sec)

mysql> exit
Bye
$ mysql -u user -p
Code:
Enter password: some_password
ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)

$ sudo /etc/init.d/mysql start
Code:
Starting MySQL database server: mysqld already running.
$ mysql -u user -p
Code:
Enter password:
ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)
Please help. TIA


B.R.
satimis