Knowledgebase

How do I add a new MySQL database?

Most programs that help you design your web site will require a place to store all kinds of different data (like which theme you're using or what that last comment said). This is true for both Wordpress, Joomla and any other major CMS (Content Management System) you can use to build a website. In general only media such as images and computer code are stored as files on the webhotel.

A place for storing data is called a database and there are mainly two kinds - MySQL or MSSQL. If you have a webhotel using PHP, you can create MySQL databases. 

MySQL is the most common type and is used by large systems like Wordpress. In case you would need to create a new MySQL database, you've come to the right place. Just follow the steps below and you'll have your database ready in just a few minutes!

1.  Begin by logging in Here


2. If you have multiple webservices, you must choose the webservice containing the domain you want to use the database with. If you have many and are in doubt which webservice you need, you can click here.


3. When you have expanded the webservice, click on Databases in the Hosting section.

Databases


4. You will now see a new page, which shows you any already created databases. Click Add next to Databases.

Add


5. In the dialog box that pops up, you can choose a name for your database, and give it a description (optional) to help you remember what the database was created for later on, in case you have more than one database.

  1. Choose a database name. This can contain numbers (0-9), letters (A-Z), (a-z), and the characters - and _
  2. Optionally, write a description for your database.
  3. Press the Add button

Add


6. The database is now added! Before you can use it, you will need to add a user as well. Directly to the right of each database are a few buttons, which can be used to set up the database. Under Actions  you will find a button named Add login. This will open a new popup window.

Login


7. In the newly opened popup window, you can create a new user or allow an existing database user to also log in to the new database. By entering a new username and password, you will create a new user. If you look at the bottom of the popup window, you will see Grant an existing user permissions . A description on how to do both is below the image.

7a. Adding a new user: In the dialog box that pops up, we have to fill out a user name, a password, and we have to set the permission level of the user. The available options are read, read/write, or dba.

  1. The user name must be 2-8 characters, and may consist of letters and numbers (A-Z), (a-z), (0-9)
  2. You can choose your own password, or let the system generate a code for you by pressing the Generate strong password link. If you choose to generate a password, remember to check the Show Password box to display the generated password and write it down for use later on in the guide.
    Add MySQL user
  3. Here, you set the User permissions for the database user. As a rule of thumb, always choose dba (DataBase Administrator) when you create a database user.
  4. Press Add.

    Add MySQL user 2

7b. Granting an existing user access: To allow an already existing user to log into the database, look in the bottom of the popup window. Below Grant an existing user permissions you will find a drop down menu called Choose userClick this and choose which user will get access. In the drop down menu next to it, called User permission, you can choose between read, read/write and dba. As a rule of thumb, always choose dba (DataBase Administrator). Finally click the button labeled Grant to allow the user to log into the database.


8. You will now be back at the overview of your databases, and will be able to see your new database and any new users you may have created.

Contact
Should you not find what you are looking for then feel free to ask our support

Create A Ticket
Service Desk
Are you facing bigger challenges which requires a bit more know-how and time than you have?

Surftown Service Desk is services where we do the work to you. Our Service desk will get the job done.

Do it for me