If you get the following error message:

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

that means the user: da_admin has not been setup correctly. To solve this problem, do the following.

1. Make sure that the root mysql password is working. If you know it, skip to Step 2. The MySQL root password (if has not been deleted) can be found in the file:

/usr/local/directadmin/scripts/setup.txt

It should be under the header mysql=

If the password cannot be found, mysqld will have to be restarted with the following switch: --skip-grant-tables

To start up MySQL, and access MySQL prompt,without the need for a root password:

• /sbin/service mysqld stop
• mysqld_safe --skip-grant-tables &

Once at MySQL prompt, run the following commands to reset the root password:

• use mysql
• update user set password=PASSWORD('YOUR_NEW_PASSWORD') where user='root';
• flush privileges;
• quit

Shut down and then restart mysqld

• killall -9 mysqld_safe
• killall -9 mysqld
• /sbin/service mysqld start

2. Now, you can reset da_admin mysql user. Access MySQL prompt:

• mysql -uroot -YOUR_NEW_PASSWORD'

At MySQL prompt, run these commands:

• GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY 'YOUR_NEW_PASSWORD' WITH GRANT OPTION;
• flush privileges;
• quit

3. 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=YOUR_NEW_PASSWORD'

Other articles in this Category

HowTo :: optimize MySQL server