How to Set Up a Database Using cPanel
- ARTICLES |
Databases make it possible to manage large amounts of information on the Internet. They are the crucial back end to many web-based applications such as CMS (Content Management Systems) blogs and online catalog websites.
CPanel makes creating databases simple and easy. You can either use the MySQL Database Wizard or you can create databases and users directly.
Create a database
Let's begin by creating a MySQL Database. In the 'databases' section on your cPanel dashboard screen, click on the 'MySQL Databases' graphic. If this is the first time you will be creating a database, you might want to take a moment and watch the video tutorial.
To get started, type in the name of your database in the 'Create New Database' field and then click the 'Create Database' button. Click the 'Go Back' button and you will see the database you just created in the current table's database.
Create a database user
Your next step will be to create a database user and give them privileges so that they can populate and manage the database. These MySQL accounts are separate and distinct from email or web administrator user name and passwords. To create a database user, either scroll down past the current databases or click on the 'Jump to MySQL Users' button. Enter a username under 'Add New User,' and enter a password that is 7 letters or less. If you can't think of a good password, you can use the password generator. Type the password again and then click 'create user.'
When you are finished you will see you new database has been added to the list of current databases, and your new user has been added to the list of current users.
Deleting a database
To delete a database from your account, simply find the database in the list of current databases table and click, 'Delete Database.' You will then be asked to confirm that you want to permanently delete the database by clicking 'Yes.'
Deleting a user
If you want to remove a user from managing a database simply click on the red 'x' that is next to the name of the user in the 'Current users,' menu and confirm by clicking, 'Yes.'
phpMyAdmin
This is a third-party tool that cPanel makes available to users. It is used to manipulate MySQL databases on the Internet. You would use phpMyAdmin when you want to add and delete databases, create, alter or delete tables, add, edit or delete fields, execute SQL statements, and manage users, keys and permissions.
Remote MySQL
If you have a need to make your databases in cPanel available to be remotely accessed by other web servers, Remote MySQL can be used to grant secure access. You can also revoke that access in the future if you need to. Remote MySQL has a wizard that walks you through, step-by-step, on how to give remote servers access to the databases on your server.
All of these features that are included within cPanel make administering databases convenient and easy with everything you need all in one place.
Are you ready to learn more about Internet marketing, SEO, email or affiliate marketing? Visit, http://www.mcreasite.com, where you will find a ton of resources for building an online business and making money online today.
CPanel makes creating databases simple and easy. You can either use the MySQL Database Wizard or you can create databases and users directly.
Create a database
Let's begin by creating a MySQL Database. In the 'databases' section on your cPanel dashboard screen, click on the 'MySQL Databases' graphic. If this is the first time you will be creating a database, you might want to take a moment and watch the video tutorial.
To get started, type in the name of your database in the 'Create New Database' field and then click the 'Create Database' button. Click the 'Go Back' button and you will see the database you just created in the current table's database.
Create a database user
Your next step will be to create a database user and give them privileges so that they can populate and manage the database. These MySQL accounts are separate and distinct from email or web administrator user name and passwords. To create a database user, either scroll down past the current databases or click on the 'Jump to MySQL Users' button. Enter a username under 'Add New User,' and enter a password that is 7 letters or less. If you can't think of a good password, you can use the password generator. Type the password again and then click 'create user.'
When you are finished you will see you new database has been added to the list of current databases, and your new user has been added to the list of current users.
Deleting a database
To delete a database from your account, simply find the database in the list of current databases table and click, 'Delete Database.' You will then be asked to confirm that you want to permanently delete the database by clicking 'Yes.'
Deleting a user
If you want to remove a user from managing a database simply click on the red 'x' that is next to the name of the user in the 'Current users,' menu and confirm by clicking, 'Yes.'
phpMyAdmin
This is a third-party tool that cPanel makes available to users. It is used to manipulate MySQL databases on the Internet. You would use phpMyAdmin when you want to add and delete databases, create, alter or delete tables, add, edit or delete fields, execute SQL statements, and manage users, keys and permissions.
Remote MySQL
If you have a need to make your databases in cPanel available to be remotely accessed by other web servers, Remote MySQL can be used to grant secure access. You can also revoke that access in the future if you need to. Remote MySQL has a wizard that walks you through, step-by-step, on how to give remote servers access to the databases on your server.
All of these features that are included within cPanel make administering databases convenient and easy with everything you need all in one place.
Are you ready to learn more about Internet marketing, SEO, email or affiliate marketing? Visit, http://www.mcreasite.com, where you will find a ton of resources for building an online business and making money online today.