Jump to content



Photo

Fixing Database Error for DirectAdmin Users - Undecided4


  • Please log in to reply
No replies to this topic

#1 Cryo Kinesis

Cryo Kinesis

    Haphost Staff

  • Moderators
  • 128 posts
  • LocationGridania, Eorzea

Posted 05 August 2014 - 04:56 PM

Good Day!

Due to the recent upgrade of our servers, SQL users needs to be recreated to be compatible with the new software installed on the machine.

If you are receiving sql errors for your account, Please do one of the following procedures:

A. Reassign User to Database
1. Log into your account.
2. Go to SQL Management.
3. Click on your database.
4. Delete the user on the database.
5. Click on Create New Database User.
6. Input your credentials and click create.

NOTE: Only perform the procedure below if procedure A doesn't work.

B. Recreate Database
1. Log into your account.
2. Go to SQL Management.
3. Download a backup of your database.
4. After completing the download, Delete your current database from the server.
5. Create a new database and upload your backup to the server.

After doing that, your SQL connection should be up.
If you are having problems performing the said procedures, don't hesitate to post in this thread for assistance. Thank you! smiley-grin.png


Cryo%20Kinesis%20Haphost%20Sig2.png





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users