Multiple MySQL DB access by one user

[fsci]

How is it possible to specify the same user to be able to access multiple MySQL databases? I can find no way via Plesk to do so - and yet now cannot easily backup a database via phpMyAdmin by copying it (or create/copy) into another database.

I do this while testing certain SQL's as I develop scripts so that I can see exactly what is being done - and easily copy back and forth the tables I need to change, or even the full database.

Also, is there a way to access phpMyAdmin so that these higher functions are accessible? Do I need to configure the phpMyAdmin set-up to do so (allow a root login, etc.)? I have configured phpMyAdmin on dev servers, but realize that root access is not exactly desired on a production server - another method maybe?

I also do not know if such will affect the Plesk control - or will Plesk overwrite changes made directly to any phpMyAdmin scripts when further changes are implemented in Plesk.

Any hints on how to implement any higher functionality into the default Plesk and phpMyAdmin on these VPS's is appreciated.

Nolan M.
FSCI

[asterisk]

I am also wondering how to specify the same user for multiple MySQL databases. Did you happen to figure out how? Would appreciate any help.

[Soul]

You should be able to login directly via ssh and create a db and give user access directly to the user that needs access.

http://www.devarticles.com/c/a/MySQL/Creating-Users-and-Setting-Permissions-in-MySQL/1/

[asterisk]

Thanks for the pointer, Soul. That did the job. :)

A note to others who may find this helpful as well, when accessing MySQL, use admin instead of root which is disabled by default in Plesk.

[Soul]

Thanks for the pointer, Soul. That did the job. :)

A note to others who may find this helpful as well, when accessing MySQL, use admin instead of root which is disabled by default in Plesk.

Yeah I forgot to mention that :) I found that out just be screwing around trying to get in one day.