MySQL database wizard (cPanel)
From JumbaWiki
MySQL Database Wizard is a cPanel option that makes it easier to create a MySQL database and database user than using the MySQL databases option.
The wizard helps you through these steps:
- The first page gives a general description of databases and asks for a database name.
Enter a name and press the 'Next Step' button
- Give your database a name that is unique to your account, but chose something that relates to what you want to store in your database so it makes it easier to maintain.
- Give your database a name that is unique to your account, but chose something that relates to what you want to store in your database so it makes it easier to maintain.
- The second page sets up the username & password that are required to connect to the database.
Enter the details required and press the 'Next Step' button
- Choosing a strong password is important to prevent your MySQL database being compromised. The 'Password Strength' indicator will show you how strong your password is.
- Choosing a strong password is important to prevent your MySQL database being compromised. The 'Password Strength' indicator will show you how strong your password is.
- The third step sets permissions for the user in the database. It is recommended that the database only be given permissions that it needs such as INSERT, UPDATE and SELECT if your website will never delete from the database or create new tables directly.
- It is possible to add multiple users to a database to perform multiple actions. For Example: Adding 2 users, one of which can insert and update and one which can only select increases security as the Insert and Update permissions will only be available on pages where this action takes place so therefore hampers the efforts of hackers as there are less pages for them to use when editing the database.
- It is possible to add multiple users to a database to perform multiple actions. For Example: Adding 2 users, one of which can insert and update and one which can only select increases security as the Insert and Update permissions will only be available on pages where this action takes place so therefore hampers the efforts of hackers as there are less pages for them to use when editing the database.
- This completes the process of adding a database to your website. You can now go and add more users to the database in the MySQL databases page. This page shows all your databases and what users are connected to the databases.
See also
| Databases (cPanel options) | ||||||
|---|---|---|---|---|---|---|
 MySQL Databases | MySQL Database Wizard |  phpMyAdmin |  Remote MySQL |  PostgreSQL Databases |  PostgreSQL Database Wizard |  phpPgAdmin |
