Title: change database user
Last modified: August 18, 2016

---

# change database user

 *  Resolved [freeeye](https://wordpress.org/support/users/freeeye/)
 * (@freeeye)
 * [18 years, 9 months ago](https://wordpress.org/support/topic/change-database-user/)
 * How do I change the database user for my database? Do I just do it in the config.
   php file or is this too simple. My server told me to change the user name because
   I have the same username for several databases and I sometimes exceed the number
   of max user connections. I have been running wordpress for several years and 
   last night all my database sites (including phpBB3) crashed.
 * Any help would be appreciated.
 * Here is what the server techs said:
 * > Looks like your script uses PConnect function to connect to our sql server.
   > He have to use mysql_connect function instead of pconnect. Please recheck all
   > your scripts and change the PConnect(); function to mysql_connect (); function.
   > 
   > Your websites are working now, but you need to optimize your databases and 
   > scripts. I found that you have used only one sql user to connect to all your
   > databases, but the max_user_connections for the user = 50 connections. You 
   > have to add additional users for all your databases.(Go to Mysql from your 
   > control panel) then you will need to reconfigure all your scripts, set a new
   > sql user for them instead of “h0lapv_rick”

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Jeremy Clark](https://wordpress.org/support/users/jeremyclark13/)
 * (@jeremyclark13)
 * [18 years, 9 months ago](https://wordpress.org/support/topic/change-database-user/#post-616566)
 * **Be sure to back up your databases before doing anything**
 * If you’ve already created the user and given the proper permissions for that 
   user to the worpdress database then changing the username and password in the
   wp-config file is all you have to do for wordpress.
 * If you need a little [help](http://codex.wordpress.org/Installing_WordPress#Step_2:_Create_the_Database_and_a_User)
   with the user. Note you will not need to create a new database just a new user
   to access the same database you’ve already been using.
 * **Also be sure to back up your databases before doing anything**
 *  Thread Starter [freeeye](https://wordpress.org/support/users/freeeye/)
 * (@freeeye)
 * [18 years, 9 months ago](https://wordpress.org/support/topic/change-database-user/#post-616568)
 * Thanks. It worked.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘change database user’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [freeeye](https://wordpress.org/support/users/freeeye/)
 * Last activity: [18 years, 9 months ago](https://wordpress.org/support/topic/change-database-user/#post-616568)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics