How to create a MYSQL database

Databases are used with popular content management systems such as WordPress, Joomla or OpenCart. LCN Web Hosting and WordPress hosting packages provide the ability to create a new MySQL database from your LCN account.  

Let’s get started… 

How to create a MYSQL database

1. Log in to your LCN account and head to your Control Panel. 

2. Click on the domain you’d like to add a database to. 

3. Now click Hosting Settings followed by MySQL. 

4. Next click Add database. 

5. You will now be presented with boxes to fill in for your Databases details.  

• Database name – The name will need to be up to 12 characters and consisting only of letters and numbers. As a recommendation we have prefilled the box with our suggested name, we suggest this is used as we have already confirmed that this is unique for the server indicated. 
• MySQL server –  Choose between the MySQL servers provided. The server that is currently serving the lowest number of databases is selected by default, and it is recommended that you adhere to this selection. However, you may choose a different server if you require a particular MySQL version, or your database must be on the same server as another database. 
• Default charset – Our recommended charset will be automatically selected; we suggest that you leave it like that unless you particularly need to use another one. The most popular are latin1 and utf8. For more information on MySQL character set support, please refer to the MySQL documentation. 
• Username – Enter a username of up to 12 characters and consisting only of letters and numbers. We would recommended that you use our suggested username that is provided, as we have already confirmed that this is unique for the server indicated. 
• Password – Enter the password you would like for your Database. Make sure your chosen password is secure it is recommended to be 5 to 8 characters long and include at least 3 of the following: Lower case letter, upper case letter, number, special character. For a guide on making a secure password click here. 
• Confirm password – Confirm your password that you entered above. 
• Remote access? – To ensure maximum security, by default your database will not accept connections from any location outside of the hosting cluster and we strongly recommend that databases are developed on your own machine. Once complete, the database can be uploaded to the live server via your MySQL control panel. However, in exceptional circumstances, you may need to enable remote access to your database. You will need a fixed IP address which you must provide to our Support team who can then permit access through the firewall. 

6. When you are happy with your entries click Create 

That’s it! You’ve successfully created a database.