HostSEO Blog

Stories and News from IT Industry, Reviews & Tips | Technology Blog


How to rest mysql root password in directadmin

When connecting to the MySQL screens in DirectAdmin, if this error appears, that would indicated that the “da_admin” user has not been setup correctly.  Also you are reset the mysql root password too. To resolve this do the following.

/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &

That should start up mysql without the need for a root password.  Once in, type

mysql
use mysql;
update user set Password=PASSWORD('newpass') where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'da_admin'@'localhost' IDENTIFIED BY 'newpass' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit;

Now we need to make sure it’s setup correctly for DA to use.   Edit /usr/local/directadmin/conf/mysql.conf and set

user=da_admin
passwd=newdapass

Now edit the file /root/.my.cnf  and add the following lines

[client]
pass="newpass"
user=root

Subscribe Now

10,000 successful online businessmen like to have our content directly delivered to their inbox. Subscribe to our newsletter!

Archive Calendar

SatSunMonTueWedThuFri
 1234
567891011
12131415161718
19202122232425
262728293031 

Born in 2004 ... Trusted By Clients n' Experts

SEO Stars

They never made me feel silly for asking questions. Help me understand how to attract more people and improve my search engine ranking.

Read More

Emily Schneller Manager at Sabre Inc
SEO Stars

Took advantage of Hostseo's superb tech support and I must say, it is a very perfect one. It is very fast, servers reliability is incredible.

Read More

Leena Mäkinen Creative producer
SEO Stars

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

Read More

Ziff Davis CEO at Mashable
SEO Stars

It’s very comfortable to know I can rely about all technical issues on Hostseo and mostly that my website and emails are safe and secured here.

Read More

Isaac H. Entrepreneur
SEO Stars

With hostseo as a hosting partner we are more flexible and save money due to the better packages with great pricing, free SEO n' free SSL too!

Read More

Madeline E. Internet Professional