How to Use phpMyadmin to create a Mysql database

Source: Internet
Author: User
Tags vps how to use phpmyadmin myadmin
How to Use phpMyadmin to create a Mysql database? A total of 7 steps: 1. First, we need to log on to phpMyAdmin. Click the control panel management tool Internet Information Service Manager. The Internet Information Service Manager window is displayed. Find index. php on the homepage of the phpMyAdmin website under [default website], right-click it, and open phpMyAdmin.

How to Use phpMyadmin to create a Mysql database? A total of 7 steps: 1. First, we need to log on to phpMyAdmin. Click the control panel management tool Internet Information Service Manager. The Internet Information Service Manager window is displayed. Find index. php on the homepage of the phpMyAdmin website under [default website], right-click it, and open phpMyAdmin.

How to Use phpMyadmin to create a Mysql database? A total of 7 steps:
1. First, log on to phpMyAdmin. Click "Control Panel"> "Administrative Tools"> "Internet Information Service Manager". The "Internet Information Service Manager" window is displayed. Under "default website", locate the homepage index of phpMyAdmin. php, right-click to browse and open the management login page of phpMyAdmin. You can also open the URL http: // localhost/phpmyadmin/index. php In vps. [MYSQL Default Administrator Account: root Password: name of your host room member]
2. Create a database. For example, in the right window of php MyAdmin, enter the Database Name and click Create.


~
For example, here we create a database named cncmstest
If the creation is successful, the following message is displayed:


3. Click the Home button in the upper left corner to return to the main interface of php MyAdmin:


4. Click "permission" on the right of the main interface to create a database account.


5. On the permission page, click "Add new user"


6. On this page, enter the username, access range, and password of the database to be created.

For example, if the user name is cncmsuser, the database user only allows access from the local computer, and the host is selected as the local computer, the password is automatically generated, click "Generate" below to Generate a random password, and then click "Copy" to automatically fill in the password box.
If none of the following boxes is selected, you can directly pull them to the bottom of the page to create a new user.
If the database user is created successfully, the following page is returned:


7. The most important step is to set the user's database access permissions.
You can directly set permissions on the page returned when the database user is successfully added. Here we choose to specify permissions by database:

For example, if you select the cncmstest created in the Database List, the permission settings page of the database is automatically displayed.

In the permission settings, we select all the permissions listed in "data" and "structure", and do not select any management permissions. Click to execute.
Note: If you are in trouble or cannot understand it, you can use the website management assistant in vps to create a MYSQL database.
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.