how to reset da_admin for phpmyadmin's password?

[seachen]

can somebody guide me abt this?

thank you so much

 

[smtalk]

http://help.directadmin.com/item.php?id=45

 

[seachen]

http://help.directadmin.com/item.php?id=45

service mysqld stop (Redhat)
mysqld_safe --skip-grant-tables &

or

service mysqld stop
mysqld_safe --skip-grant-tables &

sorry i m not well in SSH

 

[smtalk]

service mysqld stop
mysqld_safe --skip-grant-tables &

 

[seachen]

use mysql
UPDATE user SET password=PASSWORD('newpass') WHERE user='root';
FLUSH PRIVILEGES;
quit

let said i want to set the password for username da_admin to abc123.

the cmd is as below ?

use mysql
UPDATE user SET password=PASSWORD('abc123') WHERE user='root';
FLUSH PRIVILEGES;
quit

or

use mysql
UPDATE user SET password=PASSWORD(abc123) WHERE user='root';
FLUSH PRIVILEGES;
quit

PS: need to insert ' ' symbol?

 

[smtalk]

This is for root (and not da_admin). 1st command is okay. For da_admin use:

mysql -uroot -p

Enter MySQL root password, then:

GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY '[B]newdapass[/B]' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit

Now change the password in /usr/local/directadmin/conf/mysql.conf.

 

[seachen]

Now change the password in /usr/local/directadmin/conf/mysql.conf.

may i know this section how to do it? from SSH?

 

[smtalk]

nano /usr/local/directadmin/conf/mysql.conf

 

[seachen]

tq so much............