One User For Multiple Databases

Zohann · #1 (**permalink**) 11-27-09, 06:21

I have multiple WordPress sites and I have heard that when creating databases for WP sites you should create a new user for each one, because using just 1 user on multiple DB posses a security threat. Can someone elaborate on this? Thanks.

CustomServer · #2 (**permalink**) 11-27-09, 08:31

You are right, it is a security threat, because if someone hacks one of your users than he can exploit all your databases. So be sure to create a different user and assign his permissions for each database.

Jonathan · #3 (**permalink**) 11-27-09, 09:30

Not sure what user do you mean? Do you mean on your admin user for the WordPress blog or do you mean user that is connected to the MySQL database?

webnubie · #4 (**permalink**) 12-12-09, 05:14

I think it is about the user connected to the MySQL database. I agree with CustomServer, it is just to make the hackers work harder if they want to abuse your blogs. It's even better if time by time you change the passwords.

Zohann · #5 (**permalink**) 06-23-10, 07:01

Yes I guess so. This is why I changed all the data across my databases and created a new user for each one. It took me a while but I guess it's worth it.

Crazzy · #6 (**permalink**) 06-23-10, 07:30

I got this good advice a long time ago and I stick to it fiercely. It's not wise to put all your eggs in one basket. Spread them around, it's safer. ;)