transfer ownership of a mysql database to another user

[brianhenson]

is there a way to transfer a database from one user to another?

[pgentoo]

You can probably do this manually... Give this a try (on a test database/user first. )

- 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.

-
pGentoo

[brianhenson]

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. )

- 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.

-
pGentoo

[sci2tech]

You need to also transfer any users added to this database