Multiple Users

[Frenchy]

I knew there was some risk. Now I have to go and create a gazillion new users and set their privileges for each database. I hate such tasks!

[manolis]

I agree with Buldog it's a security risk, in the other hand if you can keep your passwords absolutely safe then you can go on, but as we all know....passwords are almost never safe enough.

[Buldog]

It is a security risk for simple reason that if someone hacks your user it will gain access to all your databases. Always create multiple users for your different databases.

[Frenchy]

I create new database for each WordPress installation. But I have only one user on the server and I gave it access to all DBs. Is that a security risk and should I create a user for each DB?