Mysql 集合

最新推荐文章于 2024-07-28 03:32:21 发布

什么问题

最新推荐文章于 2024-07-28 03:32:21 发布

阅读量649

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/a1092484359/article/details/53404781

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.添加用户并添加与用户相同的数据库名且给该数据库授予全部权限

mysql> use mysql;
Database changed
mysql> insert into user(Host,User,Password) value('%','users',password('xxgcsoft1101'));
Query OK, 1 row affected
mysql> flush priveges;
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'priveges' at line 1
mysql> flush privil
eges;
Query OK, 0 rows affected

mysql> create Database userDB;
Query OK, 1 row affected
mysql> grant all privileges on userDB.* to users@localhost identified by 'users.me';
Query OK, 0 rows affected
mysql> flush privileges;
Query OK, 0 rows affected

2.mysql 初始化

mysql -u root -p
use mysql;
select user,Host,password from user;
update user set Host='%',password=password('password') where user='root' and Host='::1' ;
flussh privileges;