Return to "MySQL"
Creating a MySQL Database
To create a database:
1. Login to your account control panel
2. Select “MySQL Databases” from the Databases section.
3. Enter the new database name and click “Create Database”.
4. Click go back
5. Next create a database user using the form “Add New User”.
6. Finally, add the user to the new database by using the “Add User to Database” form. Select the user and the database from the drop down menus and click “Add”. Select the privileges the user should have with that database and click “Make Changes”. Typically a database will only need one user and that user can be given “All Privileges”.
Important Note: A database can have multiple users assigned to it with different privileges. A single user can assigned to multiple databases with different or similar privileges for each database.
Important Note: The database host will be always be “localhost” when your applications request this information (remote access to databases is not available except through SSH tunneling).
Related Video:
Related Articles:
