• Resolved freeeye

    (@freeeye)


    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)
  • 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 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

    (@freeeye)

    Thanks. It worked.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘change database user’ is closed to new replies.