How to handle all of MySQL databases in phpMyAdmin

[zedemm]

Pls suggest me, how I can create a single user ID with same password for all of my databases and how all the databases can be hosted on a single server?

Whenever I add a user in my one of the databases, which is already used in one of the other databases, which are all mine, there is an error message to create a unique user ID, etc.

Please suggest me solutions.

Thanks and regards

Zafar Malik
www.alnoors.com

[RTH10260]

Pls suggest me, how I can create a single user ID with same password for all of my databases and how all the databases can be hosted on a single server?

Whenever I add a user in my one of the databases, which is already used in one of the other databases, which are all mine, there is an error message to create a unique user ID, etc.
You cannot handle database creation or modification, nor username creation in phpmyadmin. You perform these functions in OPS > package > MySql. Several databases can share the same database username, but the database usernames must be unique among all Powweb customers. You have no choice where your databases are allocated, the database definition will assign by rules given by Powweb. There is no advantage to have all databases on a single server (apart from easily keeping track of server names per database). Having a database on an other server may even be preferrable, one could export to an appearantly lighter used server.

[zedemm]

Pls tell me how several databases can share the same database username? I have 5 databases and I want to share my "user1" user in "db1" in other databases "db2", "db3" and so on.

[extras]

Pls tell me how several databases can share the same database username? I have 5 databases and I want to share my "user1" user in "db1" in other databases "db2", "db3" and so on.
You just have to create/modify the user in OPS, I guess.
I use same username/pass for two of my databases (they are on different server).
I don't know if you can use same username/pass if databases are on the same server.
Try and report the result, please.

There is no advantage to have all databases on a single server (apart from easily keeping track of server names per database).
Actually, it's handy to have them on the same server because you can use them mixed in the query.
But I don't think it's possible as PowWeb seems to assign the server randomly.
(It can happen accidently, though....)


Having a database on an other server may even be preferrable, one could export to an appearantly lighter used server.
True. But you have to keep them in sync, which isn't necessarily easy and it comes with overhead.

[RTH10260]

Pls tell me how several databases can share the same database username? I have 5 databases and I want to share my "user1" user in "db1" in other databases "db2", "db3" and so on.As I mentioned, sign into OPS > package > MySql and then assign the usernames/passwords to one database, then select the next database from the dropdown, and repeat until done.