Databases offer a method for managing large amounts of information easily over the web. They are necessary to run many web-based applications such as forums, content management systems, and online shopping carts.
NOTE: If you plan on setting up a specific software like Wordpress or an e-commerce system, you do not need to setup a MySQL database manually. When you use the Softaculous auto-install tool in the Control Panel, it will automatically setup the MySQL database for you.
Setting up MySQL Manually
1. Log into cPanel and click on the MySQL Database Wizard tool.
2. In the New Database field, enter a name for the database. Click Next Step.
3. In the Username field, enter a name for the user allowed to manage the database.
4. In the Password field, type the user’s password. The password must be 7 letters or shorter. For help generating a strong password, click the Password Generator button. Retype the password in the Password (Again) field.
5. Click Create User.
6. Select the privileges you wish to grant the user, or select ALL PRIVILEGES.
7. Click Next Step.
Next, the Control Panel will display a message stating that the database and user account were successfully set up. From here, you may select 1 of 3 options:
- Add another database: Returns to the start of the MySQL Database Wizard.
- Add another user using the MySQL Databases Area: Opens the MySQL® Databases page, wherein you may create additional user accounts and assign them to a database.
- Return to Home: Opens the cPanel home screen.
NOTE: When you add a user and database using the MySQL Database Wizard, the user is automatically given access to the database; there is no need to use the Add User to Database feature.
Using phpMyAdmin to Manage MySQL
phpMyAdmin is a third-party tool included with our Control Panel, used for managing MySQL databases online. Using phpMyAdmin, you can add and drop databases, create, alter, and delete tables, add, edit, and delete fields, execute SQL statements, and manage users, keys, and permissions.
For more information regarding all of phpMyAdmin’s functions and a complete guide on how to use them, visit http://www.phpmyadmin.net/home_page/docs.php.