MYSQL Password Problem cant login

[inflock]

MYSQL Password Problem cant login
Hello;

I cant change the mysql password for root in any way. When i try to login to mysql with this command:

mysql -u root -p

Im getting these errors

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: No)

- With this method Happening ... :

[root@server ~]# /etc/init.d/mysqld stop
Shutting down MySQL... SUCCESS!
[root@server ~]# mysqld_safe --skip-grant-tables &
[1] 1932
[root@server ~]# Starting mysqld daemon with databases from /var/lib/mysql

As you see its freezing like this and nothing happens and i try to kill all process and try again

[root@server ~]# pgrep -u mysql mysqld
1914
1915
1916
1917
1918
1919
1973
1974
1975
1976
[root@server ~]# killall mysqld
root@server ~]# mysqld_safe --skip-grant-tables &
[1] 3097
[root@server ~]# Starting mysqld daemon with databases from /var/lib/mysql

Its again freezing like this.

Then tried to reset password like this.

[root@server ~]# service mysqld stop
Shutting down MySQL... SUCCESS!
[root@server ~]# pgrep -u mysql mysqld
[root@server ~]# nano /root/mysql.reset.sql

I created file this this and added following lines in it

UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root';
FLUSH PRIVILEGES;

Then;

[root@server ~]# service mysqld stop
Shutting down MySQL. SUCCESS!
[root@server ~]# pgrep -u mysql mysqld

So as you see no process at the moment

[root@server ~]# mysqld_safe --init-file=/root/mysql.reset.sql &
[1] 3471
[root@server ~]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/server.xxxx.xxx.pid
110725 01:26:58 mysqld ended

And gives this output and freeze like this.

Can someboty assist me why mysql causing such problem. I dont have any complaint about direct admin everyhing works great at the moment but because of this i cant install things and cant login to mysql with root.

Thanks for the assist.

 

[SeLLeRoNe]

Try reinstall mysql for that problem.

Regarding root password you can check /usr/local/directadmin/scripts/setup.txt created during directadmin installation

If not present you should use da_admin user with password stored in /usr/local/directadmin/conf/mysql.conf

Regards

 

[inflock]

Hello ;

Thanks for the answer exacly its stored in the setup text.

Regards.