using same mysql user with many databases

Well it’s really not good practise, but this depends on how you’re accessing the other databases.

For example, I have a server that hosts 10+ different WordPress sites.

I have two options for connecting to the databases:

  1. Use the root login in all my wp-config.php files as it’s easier
  2. Create a user and logins associated with each database for each site

Number 1 is useful when I’m developing locally/on a virtual machine as the databases aren’t accessible to the outside world.

Number 2 is definitely the best practise when you’re running a live server with multiple databases. At most if your password does get compromised you’re only exposing one database.

Related Posts:

  1. Using wpdb to connect to a separate database
  2. How to fetch Data in WordPress using MySQLi or $wpdb
  3. wpdb->insert multiple record at once
  4. How to define composite keys with dbDelta()
  5. Inserting Post Meta From SQL
  6. Why does dbDelta() not catch MysqlErrors?
  7. What causes the “max_user_connections” warning on WordPress frontend?
  8. How to execute mulitple statement SQL queries using $wpdb->query?
  9. Database slowdown after update to 3.4.1
  10. wpdb_prepare with multiple or condition
  11. WordPress database error – Error in SQL syntax – I can’t identify any error?
  12. Advanced SELECT query with condtional statements
  13. Redirecting to old domain after migration website
  14. Create table from array with prepare
  15. WordPress running SQL query to update database from form
  16. Have working sql query… trying to adjust it to use $wpdb
  17. Custom WordPress Table wpdb
  18. Best practice to limit results in get_row()?
  19. Trouble running $wpdb->query() with last_insert_id
  20. Query Column of Specific ID from Database Table
  21. How to create more than one new wpdb object?
  22. How to connect and insert data in database of wordpress?
  23. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  24. “BS_” rows in postmeta table
  25. Where is the HTML-handler part in the wpdb class?
  26. WordPress Database Query works in phpMyAdmin but not in the code
  27. insert data from a form:: Warning Empty query mysqli::query()
  28. How can I get $wpdb to show MySQL warnings?
  29. How To connect to the same WordPress database with different database user
  30. Uploading to WordPress Database
  31. Rename a table in MySQL
  32. How should I tackle –secure-file-priv in MySQL?
  33. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  34. Checking if Database Table exists
  35. Connect to database using wordpress wp-config file
  36. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  37. Does wpdb add considerable overhead on queries with large result sets?
  38. Is it possible to define two databases for one installation?
  39. Hook into $wpdb
  40. Display data from a non wordpress database on a page template
  41. Connecting to external oracle database
  42. Huge wp_options table
  43. “MySQL server has gone away” since update to 3.8
  44. Can’t save ajax value to database
  45. Updating all rows of table with $wpdb
  46. Is $wpdb->prepare escaping to much? How to use it properly?
  47. Can I transfer a mysql database to another site?
  48. MySQL Syntax Error upon restoring database from backup [closed]
  49. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  50. Remove database entries where post_date > expiration date
  51. Is it safe to convert tables from MyISAM to InnoDB?
  52. Emojis getting converted to “?”
  53. How to use a different database to list and manage comments in the backend
  54. How do I properly update the WordPress database password?
  55. $wpdb->insert is not working
  56. WordPress Install and Database on separate hosting?
  57. wpdb custom post_type problem
  58. In what part of the WordPress core does the users table and usermeta table get joined?
  59. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  60. Using GROUP CONCAT in my-sql query with wp_usermeta table
  61. Help With MySQL to WPDB Query Conversion
  62. Migrating from PDO using SQLite to clean new install using MySQL
  63. $wpdb->insert Giving duplicates
  64. Duplicated site isn’t recognized as a site
  65. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  66. Changing root password in PHPMyAdmin for WordPress Database when going live
  67. How to properly check if a table exists in WordPress Database using Show Tables Query
  68. Can’t update WordFence Options, clear data manually
  69. How to fetch records from database WordPress
  70. How and where is wordpress adding mySQL content to database?
  71. AJAX wp-mysql running too slow
  72. How to delete a particular row in a database table
  73. Files on Localhost, Database on Server
  74. Remote database -> massive response time increase?
  75. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  76. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  77. DB prefix not updating
  78. Replacing javascript link in WordPress database without getting mysql syntax errors
  79. How to edit custom table data in frontend
  80. Writing a function for WP Cron to run a SQL command daily
  81. local wordpress broke after changing URL
  82. how to access 2nd Mysqli Database from different server for wordpress
  83. Error establishing a database connection – WordPress setup, everything else is working
  84. Help posting values to DB on submit using $wpdb->query
  85. How to map data on CSV to web pages?
  86. How to add download link from database on custom page template?
  87. How to create index (sql) to a meta_key?
  88. Search and Replace in Windows XAMPP site
  89. WPCLI search and replace in a particlar site dir effect another site-dir
  90. How can i syn wordpress user table with a stand-alone php script?
  91. How to get specific table by current user login
  92. Accessing content from third party as native posts in WordPress
  93. WordPress Database Posts Table query
  94. Hang Up Followed By Can’t select database
  95. Mysql Queries per Visit – Crazy High
  96. Pulling values from a sepcific row in table
  97. Inserting into data into external DB using WPDB
  98. Insert Extra fields added in the front end registration form to DB
  99. export individual posts to text files or a single csv file
  100. $wpdb->insert not working for last select option