Differences
This shows you the differences between two versions of the page.
— |
databases:how_do_i_create_a_new_database [2018/01/25 16:05] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== How do I create a new database? ===== | ||
+ | The easiest way to create a new database is using the Database Wizard.\\ | ||
+ | To create a new database using the database wizard: | ||
+ | - Click //MySQL Database Wizard// in the control panel. | ||
+ | - In the //New Database// text box, enter a name for the database and click Next Step. \\ The name can be up to 55 characters long. | ||
+ | - Click //Next Step//. | ||
+ | - In the //Username// text box, enter a name for the user account which you wish to allow to manage the database. \\ \\ Enter and confirm the new password in the appropriate text boxes. You can use the //Password Generator// button to create a strong password if you prefer. \\ \\ There is an indicator below the password boxes showing how strong the password is. \\ {{:email:email_accounts:password_strength.png?nolink|}} \\ You must choose a password stronger than 65. This is to help protect your database accounts from hacking. A secure password contains uppercase and lowercase letters, numbers and symbol and is not a dictionary word. \\ \\ | ||
+ | - Click //Create User//. | ||
+ | - Select the checkboxes that correspond to the privileges that you want to grant the user, or select //ALL PRIVILEGES//, which will give the user account full access. | ||
+ | - Click //Next Step//. | ||
+ | - The system will display a message confirming success. | ||
+ | |||
+ | If you do not wish to use the wizard you can create a database manually: | ||
+ | - Click //MySQL Databases// in the control panel. | ||
+ | - In the //New Database// text box, enter a name for the database and click //Next Step//. | ||
+ | - The name can be up to 55 characters long. | ||
+ | - Click //Create Database//. | ||
+ | |||
+ | |||
+ | {{tag>database create new mysql}} | ||