Creating SQL Databases
MySQL is by far one of the widest used and most popular database solutions for web servers. You’ll often see MySQL listed as an essential system requirement for various systems like contact forms, forum software, content management systems, self-hosted analytics, e-commerce and even complete web publishing systems like Wordpress and Concrete5. MySQL is built for power and reliability. All Chillidog Hosting plans already include support for MySQL, and you can easily create new databases when you’re developing new websites or web apps.
Step One
Sign into your CPanel (control panel) using your normal username and password combination. Scroll down to the **Databases** section and click on the **MySQL® Database Wizard** button. Scroll down to the Databases section and click on the MySQL® Database Wizard button.
Database options in CPanel
Step Two
Follow the onscreen instructions. Start by giving your database a new name and click Next Step. On the second screen, create a username and password (to be used for accessing the database). Enter a password and ensure this is suitably secure by using a mixture of uppercase, lowercase letters, random numbers and characters. If you need help, use the Password Generator option. Click the Create User button when done.
Creating a user for the new database
Step Three
Next you need to say what privileges your database requires. Commonly it is often easier to just tick the All Privileges option. You don’t normally need to select individual privileges, unless you’re doing something very specialist and have otherwise been informed to change certain privileges.
Setting the database privileges
Finishing the setup
From this point onwards, your new MySQL Database is setup and is ready for use. With Chillidog Hosting, database creation is instant, and unlike other hosting companies, you wont have to wait an hour before your database is ready or wait for a member of support staff to set it up for you! You can create new databases yourself at any time and they are instantly available. It would be wise at this point to write down your database name, username and password for future reference.
Deleting unused databases
If you have a MySQL database that is no longer being used, you can delete it from within your control panel. This may free-up some disk space for you. To do this, log into your control panel and scroll down to the Databases section.
Database options in CPanel
Click on MySQL® Databases (the first option). On this page you’ll see a table with a list of your databases in. In the Actions column, click the Delete Database link, next to the database you want to delete. If you scroll further down the page, you can also delete users. Take care not to delete any databases or users which are still in active use!
