guoguos-MacBook-Pro:myblog guoguo$ mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3334
Server version: 5.7.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type \’help;\’ or \’\h\’ for help. Type \’\c\’ to clear the current input statement.
创建库
mysql> create database blog;
Query OK, 1 row affected (0.01 sec)

用户赋权
mysql> grant all privileges on blog.* to \’blog\’@\’locahost\’ identified by \’blog\’;
Query OK, 0 rows affected, 1 warning (0.02 sec)

mysql> grant all privileges on blog.* to \’blog\’@\’%\’ identified by \’blog\’;
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye

确认操作
guoguos-MacBook-Pro:myblog guoguo$ mysql -ublog -pblog
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3338
Server version: 5.7.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type \’help;\’ or \’\h\’ for help. Type \’\c\’ to clear the current input statement.

mysql>
mysql>
mysql> show databases;
+——————–+
| Database           |
+——————–+
| information_schema |
| blog               |
+——————–+
2 rows in set (0.00 sec)

mysql> guoguo

版权声明：本文为sxwen原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/sxwen/p/7843777.html