mysql如何实现用户创建

这篇文章主要介绍mysql如何实现用户创建，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！mysql> create database test;Query OK, 1 row affected (0.00 sec)mysql>mysql> create user ‘chenyj’@’*’ identified by ‘chenyj’;Query OK, 0 rows affected (0.01 sec)mysql>mysql> grant all on test.* to chenyj@’*’;Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.01 sec)mysql>mysql> grant all on test.* to ‘chenyj’@’*’;Query OK, 0 rows affected (0.01 sec)mysql> grant connect to ‘chenyj’@’*’;ERROR 3523 (HY000): Unknown authorization ID `connect`@`%`mysql>mysql> create user ‘chenyj’@’%’ identified by ‘chenyj’;Query OK, 0 rows affected (0.01 sec)mysql>mysql> grant all on test.* to ‘chenyj’@’%’;Query OK, 0 rows affected (0.01 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)测试：[root@mysql8-01 ~]# mysql -h localhost -u chenyj -pEnter password:ERROR 1045 (28000): Access denied for user ‘chenyj’@’localhost’ (using password: YES)[root@mysql8-01 ~]#[root@mysql8-01 ~]# mysql -h localhost -u chenyj -pEnter password:ERROR 1045 (28000): Access denied for user ‘chenyj’@’localhost’ (using password: YES)[root@mysql8-01 ~]# mysql -h localhost -u chenyj -pEnter password:ERROR 1045 (28000): Access denied for user ‘chenyj’@’localhost’ (using password: YES)[root@mysql8-01 ~]#[root@mysql8-01 ~]# mysql -h localhost -u chenyj -pEnter password:Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 13Server version: 8.0.14 MySQL Community Server – GPLCopyright (c) 2000, 2019, Oracle and/or its a免费主机域名ffiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/免费主机域名or itsaffiliates. Other names may be trademarks of their respectiveowners.Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.mysql>mysql>需要注意的是通配符应该采用’%’以上是“mysql如何实现用户创建”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注云技术行业资讯频道！

相关推荐: oracle统计信息查看与收集的方法是什么

这篇文章主要讲解了“oracle统计信息查看与收集的方法是什么”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“oracle统计信息查看与收集的方法是什么”吧！一、查看表统计信息备注：通过脚本查看统计信息,参考MO…