Admin-Ahead Community

Linux => Control Panels => DirectAdmin => Topic started by: Aby on January 17, 2014, 02:37:10 pm

Title: Moving a database to a different user
Post by: Aby on January 17, 2014, 02:37:10 pm
Moving a database to a different user..

If you want to move the databases from one user, to another user, you can do so with the following command:

Code: [Select]
VERBOSE=1 DBUSER="da_admin" DBPASS="da_adminpass" USERNAME="username" NEWUSERNAME="newusername" /usr/local/bin/php /usr/local/directadmin/scripts/change_database_username.php

Where you can grab the da_adminpass from /usr/local/directadmin/conf/mysql.conf, and of course, replace all bold info with the appropriate info.
***