Mysql settings

If you are running PHP scripts then you almost certainly will need databases. These are created and deleted here and managed (edited, imported, exported, etc.,) via phpMyAdmin.

Add a Database

You will need to manually add a MySQL database when required as these are not automatically created by scripts, however scripts will generally set up the database tables and default values once you have given your script the connection details (ie. database name, username, password and mysql user – usually:  localhost ).

1.) From your Account Manager click on Mysql settings from the main menu.

2.) Click the Add database button. Then enter your new Database name suffix (ie. all databases will start with your account username (in our case uks12345).

3.) Enter details in the description field as all domains on this account share the Mysql so you might need to document what domain and script this is for.

4.) Click the ‘Add database‘ button to complete this task.

Add a MySQL User

It is possible to use one MySQL User (and therefore password) for one or many databases and scripts but for security reasons we recommend a new user is setup for each database or script.

1.) From your Account Manager click on Mysql settings from the main menu.

2.) Click the Add user button. Then enter your new Username suffix (ie. all usernames will start with your account username – in our case uks12345).

3.) Enter a Password for this User.

4.) For security we would recommend assigning a specifc database to the user although you can assign a user to All databases if required.

5.) Click the ‘Add user‘ button to complete this task.