Lost of mysql root password

[satimis]

Hi folks,


Ubuntu 7.04 server amd64
mysql-server 5.0.38
mysql-admin 1.2.5rc-1
mysql-admin-common 1.2.5rc-1
mysql-client 5.0.38
libmysqlclient15-dev 5.0.38

$ sudo mysql -u root mysql

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

Please advise how to recreate new mysql root password w/o the old password? TIA


B.R.
satimis

 

[chatwizrd]

The master user login should be in /usr/local/directadmin/conf/mysql.conf

Other wise you need to follow a guide like this:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

 

[satimis]

The master user login should be in /usr/local/directadmin/conf/mysql.conf

Other wise you need to follow a guide like this:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Hi chatwizrd,


Thanks for your advice and URL. I fixed my problem by following;

http://www.cyberciti.biz/tips/recover-mysql-root-password.html



B.R.
satimis