MySQL A typical database build table build user process

Source: Internet
Author: User
  • CMD command does not answer ";"
  • MySQL command followed by ";"

1. Log in to MySQL as an administrator

Mysql-u root–p

2. Select MySQL Database

Use MySQL;

3. Create a user and set a password

Create user ' test ' @ ' localhost ' identified by ' 123456 ';

4. Make the Operation effective

Flush privileges;

5. Create a database for users

Create DATABASE TestDB;

6, give the user the operation database testdb all permissions

Grant all privileges the testdb.* to test@localhost identified by ' 123456 ';

7. Make the Operation effective

Flush privileges;

8. Log in with a new user

Mysql-u test–p

9. View all users and permissions in MySQL database

SELECT DISTINCT CONCAT (' User: ', user, ' @ ', host, '; ') as query from Mysql.user;

10. Display Database List

show databases;

11. Display the data table in the library

Use MySQL;

Show tables;

12. Quit MySQL

Quit

MySQL A typical database build table build user process

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.