Get Paid to Participate - up to $1 per post!     Twitter     Facebook     Google+
Hosting Discussion
 

Hosting Discussion > Web Hosting Forums > Essential Software & Control Panels > One MySQL User For Multiple Databases
forgot password?



Reply


Old
  Post #1 (permalink)   10-09-2009, 03:48 AM
HD Master
 
Zagor's Avatar
 
Join Date: May 2009
Posts: 366

Status: Zagor is offline
I need to manually set up for each of my WordPress sites a database. Since database requires a user with granted privileges to it my question is this: can I create one user and give it privileges to all databases of all sites or should every database have a separate user?

Thanks.
 
 
 


Old
  Post #2 (permalink)   10-09-2009, 10:53 AM
HD Wizard
 
Join Date: Mar 2005
Location: Atlanta, GA
Posts: 2,264

Status: handsonhosting is offline
You CAN use just the one user and connect to multiple databases, however I'd advise not doing this. If someone was to compromise that username & password, they'd then be able to access all other sites.

Also, if you're going to be setting up multiple wordpress installations, you may want to check out the Wordpress MU (multi-user). This would mean you'd only need to keep one software up to date, but have multiple domains/wordpress configurations.
__________________
Emerson Nogueira
http://www.HandsOnWebHosting.com
cPanel Web Hosting, Domain Registration, Managed VPS Servers
 
 
 


Old
  Post #3 (permalink)   10-13-2009, 11:14 AM
HD Master
 
Zagor's Avatar
 
Join Date: May 2009
Posts: 366

Status: Zagor is offline
I understood your first paragraph completely and thanks for the but the second was a bit unclear to me. What is that software that you are talking about?
 
 
 


Old
  Post #4 (permalink)   10-13-2009, 11:43 AM
HD Wizard
 
Join Date: Mar 2005
Location: Atlanta, GA
Posts: 2,264

Status: handsonhosting is offline
There's a product called "Wordpress MU". This is the same software that Wordpress developed for wordpress.org which allows multiple people to have their own individual blog - but there's only one core of files that need to be updated when there's new patches. Each of the users (sites) would use the core files for how the program works, but have their own individual templates for display etc. Databases are separate too.

Check out this link: http://mu.wordpress.org/
__________________
Emerson Nogueira
http://www.HandsOnWebHosting.com
cPanel Web Hosting, Domain Registration, Managed VPS Servers
 
 
 


Old
  Post #5 (permalink)   10-21-2009, 04:21 AM
HD Master
 
Zagor's Avatar
 
Join Date: May 2009
Posts: 366

Status: Zagor is offline
Thanks again! Now why didn't I come up with this? I do have multiple WP installations and this would really come in handy. I'm checking it out right now.
 
 
 
Reply

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Sponsored By: