How to change the Global MySQL password on DirectAdmin server Print

MySQL root password DirectAdmin, Change root MySQL password DirectAdmin, Find root password for MySQL in DirectAdmin
11

Quick method — DirectAdmin uses da_admin for MySQL, not root directly:

Find current password:

   cat /usr/local/directadmin/conf/mysql.conf

Change it in MySQL:

   mysql -uda_admin -p
   ALTER USER 'da_admin'@'localhost' IDENTIFIED BY 'new_password';
   FLUSH PRIVILEGES;

Update DirectAdmin config:

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

Change the passwd= line to your new password.

If you actually need the MySQL root password (less common), it's in /usr/local/directadmin/scripts/setup.txt under mysql=.

Was this answer helpful?

Related Articles

Locations of Common Log Files on cPanel Servers Apache Apache is the web server that is typically utilized by cPanel. On cPanel servers... How to find the hostname for a domain behind Cloudflare DNS Finding out what the hostname is for a website using Cloudflare is pretty easily actually. You'll... How to block libwww-perl You can block libwww-perl at the website level with htaccess.Simply add this code into your... How to install NGINX on a cPanel server Adding NGINX on a cPanel server just got a lot easier with it being added to Easy Apache. These... How do I stop cron emails? Just add> /dev/null 2>&1to the end of your cron job command line code. It will work...