Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: How to access MySQL prompt on a DirectAdmin Server?  (Read 3850 times)

0 Members and 1 Guest are viewing this topic.

lijeshk

  • Guest
How to access MySQL prompt on a DirectAdmin Server?
« on: November 04, 2013, 09:54:13 am »

By default MySQL installations on Linux have root user that has full access permissions. In DirectAdmin, there is another Database user da_admin as database user with full access permissions as root. Password for it is stored inside /usr/local/directadmin/conf/mysql.conf.

MySQL can be accessed directly on a DirectAdmin server as follows:

#mysql -user=da_admin -password=`cat /usr/local/directadmin/conf/mysql.conf | grep passwd |cut -d= -f2`

To access mysqladmin on DirectAdmin system, use the following command:

#mysqladmin –user=da_admin –password=`cat /usr/local/directadmin/conf/mysql.conf | grep passwd |cut -d= -f2` processlist

--