MySQL Tutorial
To create a user:
Go to Cpanel
Click on the MySQL databases link/icon
At bottom of page you will see this:
Users:
Access Hosts:
Add name of Data base in field shown and click add db button
Then add a User and Password and click button to add.
Now you need to add "the newly created user" to the database(so you can access later from scripts)
Note That the 1st field contains "usrnameSERVER_usrnameDB" , usrnameServer is the main hosting acct username(used to access Cpanel)
"usrnameDB" is the username that you have just created in the above step.Next Field is usrnameSERVER_DBname.
For fear of confusion:
usrnameSERVER=your hosting account username
usrnameDB=username you have added in add user.
DBname=database database name created above
Click Add usr to database button.
Going back to database screen :
You have now created a user account in MySQL
To see the databse table:
Click on phpMyamin link at bottom of page
Click on the drop down list choosing the correct database
NEXT SCREEN:
Database UsernameServer_DBname running on localhost
Structure -- SQL -- Export --
Click on SQL
NEXT SCREEN:
Run SQL query/queries on database usernameServer_DBname [Documentation]
To learn more about oue hosting services please use the links at the left or top of the page.
QUESTIONS?
Have an unanswered question about the MySQL in cpanel?Please go here and we will try to help you .