创建用户
[root@VM010centos ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.19 MySQL Community Server - GPL
···
mysql> use yipaydb
Database changed
mysql> DROP USER yi@'%';
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE USER 'yi'@'%' IDENTIFIED BY '123';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON yipaydb.* TO 'yi'@'%';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql>
