Need help setting up an email. Check through our amazing guides

How to edit your MYSQL database settings

If you already have a MYSQL database set up or are using one of our Web Apps (which come with a database pre-configured) you can edit the settings through the LCN.com control panel. How to edit a manually created database Log in to your LCN.com account. Click Hosting and select the package you wish to manage. Click Databases in the Current Site menu on the left and you will be redirected to a page where you can see all databases associated with your hosting package. Here you have the option to create a new database or edit one that already exists. Selecting Details next to a database name will allow you to change the password or manage it directly from your browser. To access your database, make a note of the username and password and click Manage Your Database to access the phpmyadmin login screen. Warning If you are updating your MYSQL database password remember to update any code that connects to it. How to edit a database created by a Web App If you have a Web App, the database will not be displayed in the Databases section of your account. You would need to access it by adding /phpmyadmin to your domain name. For example: http://www.yourname.com/phpmyadmin You would also need to locate the database username and password. These details are found in the configuration files of the Web App you are using. below is a list of the most common locations of these details: If you are using Wordpress, these can be found in the wp-config.php file If you are using Joomla, these can be found in the configuration.php file If you are using OpenCart, these can be found in the config.php file When logging in via /phpmyadmin to connect to a database used by a Web App, ensure that the Server Choice is set to appdb1.lcn.com.

How to create a MYSQL database

If your website requires a connection to a MYSQL database, you can create one easily from your account. Databases are used with popular content management systems such as WordPress, Joomla or OpenCart.Whilst our Web Apps will take care of the hard work of creating these for you, you still get the access to create a manual database should you need it. Here's how to create a database for your website: Log in to your LCN.com account. Click the Hosting icon and select the package you wish to manage. Click Databases in the Current Hosting menu on the left. In the Database Name field enter a name for you database (this will be prefixed with your domain name). In the Username field enter a unique username. In the Password field enter a password for your database. Click the Add Database button and allow up to 10 minutes for your database to be created. MYSQL version Our hosting packages currently offer MYSQL 5.0.95. Here is a quick demonstration

Managing your MYSQL database

You can manage your database anywhere through an internet browser with phpMyAdmin, which is provided free with all of our database enabled web hosting packages. Simply type http://www.domain.com/phpmyadmin/ into your browser's address bar (replace domain.com with your actual domain name). You will be prompted to enter your MYSQL database username and password, which you set when you created your database. If you need to update your MYSQL database password see our How to edit your MYSQL database settings guide.

How to backup your MYSQL database

We advise that you take regular backups of your database. Creating backups not only protects you from data loss it can also protect you from accidental deletion and human error. Go to http://domain.com/phpmyadmin (replace domain.com with your actual domain name). Log in to phpMyAdmin with your database username and password. Click on the database you want to backup in the left hand column. Click on the Export tab. You shouldn't need to change any of the default options. Finally, click the Go button and your browser will start to download your database backup file. You can use your backup file to restore your MYSQL database to the state it was when the backup was taken in future if required. Here is a quick demonstration

How to manage databases on Cloud hosting using Vesta control panel

This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel. For cloud hosting customers using cPanel, please click here for the relevant support guide. Creating databases: To add a database within the Vesta control panel, select the 'DB' link from the Vesta menu: Then select the + icon to add a database: You will then need to complete the following fields: Database: database name (will be prefixed with admin_) User: database user-name (will be prefixed with admin_ and should be no longer than 16 characters together with the prefix) Password: Select ‘generate’ to automatically generate a strong password Once the required fields are filled out, select ‘add’ to create the database. Access to Phpmyadmin: To access Phpmyadmin, go to the ‘DB’ section of the control panel and select the link provided on this page for Phpmyadmin. Then enter your database username and database password to log in. To manage databases in Phpmyadmin, select the database name that you want to manage from the column on the left side of the page: You can then select from the options in the header area of the page, to import/export, edit, manage or browse the database contents:

How to restore your MYSQL database

If you are looking to restore a MySQL databases from a backup, we offer a tool called phpMyAdmin which makes this really easy to do. You need to first make sure you have an active database or create one following the guide at the link below: How to create a mysql database Firstly, log into the phpMyAdmin control panel for your domain. This is found by typing /phpmyadmin after your domain name. For example: http://www.lcnsupport.co.uk/phpmyadmin Once logged in, select the Import tab. Click the Choose File button and select the backup file you wish to restore your database from. You should not need to change any of the settings on the page. Click the Go button at the bottom of the page and phpMyAdmin will restore your database from the backup file you have chosen. If successful, it will generate a message to let you know and also give you a breakdown of the queries executed.

How to manage databases on Cloud hosting using cPanel

This guide will explain how to create and manage databases for domains on Cloud hosting using cPanel For Cloud hosting customers using the Vesta control panel, please click here for the relevant support guide. Adding a database: To create a database in cPanel you will first need to add a domain account via the WHM control panel. Then log in to cPanel using the username/password for the domain account or via the link from the WHM control panel. Enter a database name and select ‘Create Database’: You can then create a new database user or add access to an existing database user to the new database you have created. Adding database users:To create a database user, fill out the required fields to set the database username and password and select ‘create user’. You can enter a password manually, or click the password generator link to automatically generate a strong password for the database user. Adding users to databases You can then assign the database user, to the database you have created by selecting the database username and database name in the drop-down menus provided and selecting ‘Add’. Accessing Phpmyadmin: To log in to Phpmyadmin select the Phpmyadmin icon in cPanel: This should automatically log you in to access databases via Phpmyadmin. To manage databases in Phpmyadmin, select the database name that you want to manage from the column on the left side of the page: You can then select from the options in the header area of the page, to import/export, edit, manage or browse the database contents:

Your MYSQL database hostname

When you create a database it is added to our dedicated database servers which help improve its performance. To connect to your database you will need to use the hostname database.lcn.com rather than localhost in any script or application. If you are using one of our web apps, the database will be hosted on a different server. The address for this is appdb1.lcn.com. Have a look at our PHP and Perl guides on how to connect to your database using those scripting languages.

How to change your WordPress database password

This guide will explain how to change your WordPress database password for customers using LCN.com web hosting and WordPress hosting. If you’ve installed WordPress using one of our Web Apps you will need to get in touch to change the password. However, if you’ve uploaded WordPress manually via FTP simply follow the steps listed below. Let’s get started… Changing the password Login to your LCN.com account and click Hosting Click Manage site Click Manage databases which is located under Site Summary Click Details Next, enter and confirm your new database password under the Change Password section Click UPDATE PASSWORD Success! You’ve changed your WordPress database password. Making this change will cause your website to display an Error establishing a database connection message until you’ve completed the steps listed in the second half of this guide. Your browser does not support the video tag. Updating the WordPress configuration file Now you’ll need to update the password in the WordPress configuration file. To do this you will need to access your hosting using FTP which you can learn more about here. Using your FTP client, navigate to the Web folder Right-click the wp-config.php file and select View/Edit Select Use default editor for text files and click OK Once the file has opened, find the section below: define('DB_PASSWORD', 'oldPassword123!'); Replace the password inside the quotation marks with the new database password you chose earlier Click the X in the top right of your text editor to close it You’ll be prompted to save the file you’ve just edited, click Save A box will appear notifying you that A file previously opened has been changed. Click Yes. That’s it! You’ve changed your WordPress database password and updated your WordPress configuration file. Your browser does not support the video tag.

Need a hand? Search over a hundred step-by-step support guides