Admin-Ahead Community

Linux => Control Panels => DirectAdmin => Topic started by: lijeshk on November 04, 2013, 09:54:13 am

Title: How to access MySQL prompt on a DirectAdmin Server?
Post by: lijeshk 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

--