directadmin数据库遇到Error connecting to MySQL: Access denied for user: ‘da_admin@localhost’ (Using password: YES)处理办法

今天帮朋友装da 遇到

Error connecting to MySQL: Access denied for user: ‘da_admin@localhost’ (Using password: YES)

下面是解决办法

service mysqld stop 先停止数据库

mysql -uroot –p 密码为空

进入mysql

use mysql  进入mysql表

UPDATE user SET password=PASSWORD(‘newpass‘) WHERE user=’root’; 修改数据库的密码
       FLUSH PRIVILEGES;
       quit

执行

killall -9 mysqld_safe; killall -9 mysqld  关闭mysql进程

/sbin/service mysqld start 启动mysql

mysql -uroot –p

GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY ‘newdapass‘ WITH GRANT 

OPTION;
     FLUSH PRIVILEGES;
     quit

离开mysql后，

vi   /usr/local/directadmin/conf/mysql.conf

里面改成上面的newdapass

重启mysql  service mysqld restart