1.You have to login to your cpanel to create mysql database.
2.Then you need to select mysql databases.
3.Type your database name. Then click create database button. Here, my database name is 'new'.
Now you'll get successful message as created database successfully as follows as:
4.Then you have to create new user. Type your user name here.
Then click password generator to get password for your user name in mysql. The pop up box is opened as follows as.
Select the checked box and click use password button. Then you the strength password is loaded. Then click create user button.
Now the user name is created.
5. Then you need to add your user name to mysql database. Select your user name and database as follows as. then click Add button.
6. Now you select all the privileges. Then click Make changes button.
7. Finally you will get a message like this:
Now you created a mysql database , user in cpanel and add user to mysql database. Then you back to home and click phpmyadmin.
Then you can create table in your mysql database.
2.Then you need to select mysql databases.
3.Type your database name. Then click create database button. Here, my database name is 'new'.
Now you'll get successful message as created database successfully as follows as:
4.Then you have to create new user. Type your user name here.
Then click password generator to get password for your user name in mysql. The pop up box is opened as follows as.
Select the checked box and click use password button. Then you the strength password is loaded. Then click create user button.
Now the user name is created.
5. Then you need to add your user name to mysql database. Select your user name and database as follows as. then click Add button.
6. Now you select all the privileges. Then click Make changes button.
7. Finally you will get a message like this:
Now you created a mysql database , user in cpanel and add user to mysql database. Then you back to home and click phpmyadmin.
Then you can create table in your mysql database.
No comments:
Post a Comment