Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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}}
  




Copyright © GEO IT Services Ltd 2017
UK Reg. 10323297