Hi,
How can I Create MySQL Database and Its Users ?
MySQL users cannot exist separately from MySQL databases. You must stick to the following sequence:
1. Create a database
2. Add MySQL users to each created database.
However, MySQL users can be shared by different databases.
To create a MySQL database, do the following:
1. Click MySQL Server on your control panel home page.
2. Click Add database at the bottom of the form:
3. On the form that shows enter the name of the database and database description if needed
4. agree with additional charges if any.
5. In the form that appears, create a new user or grant privileges to users of other databases:
* Add a new user to the database you have just created.
* Choose roles for users of other databases so they can use your new database.
6. Click Finish to complete creating your MySQL database.
Editing MySQL databases (phpMyAdmin)
You can edit the content of your databases using the phpMyAdmin utility that comes with your control panel. To run phpMyAdmin, do the following:
1. Click MySQL Server on your control panel home page.
2. In the form that appears, click the name of the existing MySQL Database you want to edit or the Edit icon on its right:
3. In the form that appears, click Built in phpMyAdmin control panel to start editing your database
4. Follow the instructions of the phpMyAdmin control panel to edit your MySQL DB.
Leave a Reply
You must be logged in to post a comment.