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: Moving a database to a different user  (Read 7606 times)

0 Members and 1 Guest are viewing this topic.

Aby

  • Guest
Moving a database to a different user
« 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.
***