Portal Home > Knowledgebase > Articles Database > How do I change database owner from beta account to live account

How do I change database owner from beta account to live account

Posted by Mac Write, 09-03-2007, 01:43 AM

In moving my site to Drupal, I have had it on a "Beta" account on the same server. I need to move the DB to the "Live" site. How do I re-assign it using the master PHPMyAdmin through WHM to change the owner of the DB from "Beta site" to "Live site"? Thanks

---

Posted by david510, 09-03-2007, 01:50 AM

Assuming you have done the configuration part on the new site. Make a database on the new site. Restore the database from the earlier database dump file. Create the user with the same password as earlier from the cpanel mysql area of the new site. Add the user to the new database. There you go.

---

Posted by Mac Write, 09-03-2007, 01:51 AM

The long route, I just though there was an easier way.

---

Posted by david510, 09-03-2007, 01:58 AM

You create a new database user in the beta site and add that user that database and supply those values in the new site conf file. Here the database used by the new site will be the same database.

---

Add to Favourites    Print this Article

Reseller Account with Rsync capability. (Views: 820)

Any comments on Ancilenet (Views: 833)

Has anyone used: Isqsolutions (Views: 836)

backups (Views: 754)

mysql for high traffic (Views: 805)