Current time: 05-20-2022, 10:48 AM Hello There, Guest! (LoginRegister)


Post Reply 
transfer ownership of a mysql database to another user
Author Message
brianhenson Offline
Junior Member
*

Posts: 16
Joined: May 2008
Reputation: 0
Post: #1
transfer ownership of a mysql database to another user
is there a way to transfer a database from one user to another?
02-11-2009 01:53 PM
Find all posts by this user Quote this message in a reply
pgentoo Offline
Member
*****
Dev Team

Posts: 326
Joined: Mar 2007
Reputation: 0
Post: #2
RE: transfer ownership of a mysql database to another user
You can probably do this manually... Give this a try (on a test database/user first. Smile)

- Edit the domain_id field of the corresponding record in the sql_database table, to change from the old domain, to the new domain.

I think this should work, but no promises. Smile

-
pGentoo
02-11-2009 02:43 PM
Find all posts by this user Quote this message in a reply
brianhenson Offline
Junior Member
*

Posts: 16
Joined: May 2008
Reputation: 0
Post: #3
RE: transfer ownership of a mysql database to another user
it worked perfectly after doing it and reloading mysql. thanks

(02-11-2009 02:43 PM)pgentoo Wrote:  You can probably do this manually... Give this a try (on a test database/user first. Smile)

- Edit the domain_id field of the corresponding record in the sql_database table, to change from the old domain, to the new domain.

I think this should work, but no promises. Smile

-
pGentoo
02-24-2009 04:01 AM
Find all posts by this user Quote this message in a reply
sci2tech Away
Senior Member
****

Posts: 1,285
Joined: Jan 2007
Reputation: 23
Post: #4
RE: transfer ownership of a mysql database to another user
You need to also transfer any users added to this database Wink
02-24-2009 04:50 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)