How do I create or delete a database and change the password?

MySQL Manager is used to create databases. The first time you create a database in MySQL Manager a user name will automatically be created for the database and you will be asked to set a password for it.

Create a MySQL user

  1. In MySQL Manager, Click on Add Database User.
  2. Choose a password and enter this into the Enter Password field.
  3. A user name will automatically be created - this cannot be changed.

Change the password for a MySQL user

  1. If you've got an existing website you'll need to update your config file with the new password after this step. Otherwise your site may no longer work.
  2. Open the MySQL Manager application.
  3. Click anywhere on the row containing the relevant database information.
  4. Underneath this table in the section called Login Details check the box saying Yes, I want to change the password for selected user.
  5. Enter your new password in the Enter NEW password and Confirm NEW password boxes.
  6. Click Apply.

Delete a MySQL User

  1. This step will wipe ALL databases associated with that user. We'd strongly recommend backing up your databases using phpMyAdmin before proceeding.
  2. Open the MySQL Manager application.
  3. Click on the red minus button (Mark for Deletion) on row containing the relevant database information.
  4. Click on the Apply button underneath to confirm deletion.

Create a MySQL database

  1. Open the MySQL Manager application.
  2. Select the database user name you wish to create a database for.
  3. Underneath in the section Login Details enter your password and click Login.
  4. In the first box select CREATE.
  5. In the second box select DATABASE.
  6. Enter a name for your database in the Please enter a Database name field.
  7. Click Build Query.
  8. This button will now change to Run Query, click this.
  9. Your database is now created.

Delete a MySQL database

  1. This step will wipe ALL databases associated with that user. We'd strongly recommend backing up your databases using phpMyAdmin before proceeding.
  2. Open the MySQL Manager application.
  3. Select the database user name you wish to delete a database from.
  4. Underneath in the section Login Details enter your password and click Login.
  5. In the first box select DROP.
  6. In the second box select DATABASE.
  7. In the third box select the database for deletion.
  8. Click Build Query.
  9. This button will now change to Run Query, click this.
  10. The database is now deleted.
 
 

Artboard 1 copy 2 Need more help?


 
Contact us