Moving DB

[FeeReD]

Alright, I was wondering how I would go about moving a MySQL database to another user.

[mickalo]

Alright, I was wondering how I would go about moving a MySQL database to another user.

grant the appropriate privileges to the other user and delete or revoke the current user assigned to the database if the current user no longer access to the database in question.

Mickalo

[FeeReD]

How would I go about changing privileges for the users?

[mickalo]

How would I go about changing privileges for the users?

this should explain it very well http://dev.mysql.com/doc/refman/4.1/...ge-system.html

Mickalo

[FeeReD]

That basically explains the structure of MySQL and how it works. I didn't see anything about moving the database to a whole new account.

[mickalo]

That basically explains the structure of MySQL and how it works. I didn't see anything about moving the database to a whole new account.

it explains how to setup your user privileges. the actual database is just a directory within the /var/lib/mysql folder. If you want to move the entire database to a different location, this involve reconfiguring MySQL. from your post, you said you wanted to assign a new user to this database. So assigning the new user the appropriate privileges to this database, would allow them access to it.

Mickalo

[FeeReD]

My bad, that I did. I ment a whole new linux account.

I'll see what I can do, thanks

[mickalo]

My bad, that I did. I ment a whole new linux account.

I'll see what I can do, thanks

you could use the mysqldump utility to dump the database then set it up to the new location.

Mickalo