How can I find out Mysql root password?

[DA31387]

I cannot figure out mysql root pasword. Any idea how to get it would be very appreciated.
Thank you

 

[scsi]

cat /usr/local/directadmin/conf/mysql.conf

 

[DA31387]

I got it!

I got it. Thank you so much!

 

[wazburn]

cat /usr/local/directadmin/conf/mysql.conf

when i do that command it asks for password,
i input the password i got from these command

bash-4.1# mysqladmin -u root -p version
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

 

[nobaloney]

Possibly your password has been updated before, since the machine was built. The file holding the password is not interactive; it's written once when DirectAdmin is installed.

You can reset a MySQL root password; use Google to search the DirectAdmin knowledgebase at http://help.directadmin.com.

Jeff

 

[ben29]

reset Mysql Root password:

/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -uroot -p ( hit enter, without any password)
use mysql
UPDATE mysql.user SET password=PASSWORD('your_new_password') WHERE user='root';
FLUSH PRIVILEGES;
quit
/etc/init.d/mysqld restart