mysql> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select host,user,password from user ;+-----------+------+-------------------------------------------+| host | user | password |+-----------+------+-------------------------------------------+| localhost | root | *87F2746835A04895BB77E12AA5054A767******* || qxyw | root | || 127.0.0.1 | root | || localhost | | || qxyw | | |+-----------+------+-------------------------------------------+5 rows in set (0.00 sec)
2.创建数据库
mysql> create database [databasename] default character set utf8 collate utf8_general_ci;Query OK, 1 row affected (0.00 sec)
3.创建用户
mysql> create user 'dba'@'%' identified by '*******';Query OK, 0 rows affected (0.00 sec)
user表中host列的值的意义% 匹配所有主机localhost localhost不会被解析成IP地址，直接通过UNIXsocket连接127.0.0.1 会通过TCP/IP协议连接，并且只能在本机访问；::1 ::1就是兼容支持ipv6的，表示同ipv4的127.0.0.1
4.对dba用户给予针对指定数据库进行增删改查的权限
mysql> grant select,insert,update,delete,create on [databasename].* to dba;Query OK, 0 rows affected (0.00 sec)
注意：修改完权限以后 一定要刷新服务，或者重启服务，刷新服务用：FLUSH PRIVILEGES
5.可以通过show grants命令查看权限，若想要在原来的基础上增加权限则继续执行grant
AI建筑知识问答
用人工智能ChatGPT帮你解答所有建筑问题
22 查看详情
mysql> grant drop on [databasename].* to dba;Query OK, 0 rows affected (0.00 sec)mysql> show grants for dba;+----------------------------------------------------------------------------------------------------+| Grants for dba@% |+----------------------------------------------------------------------------------------------------+| GRANT USAGE ON *.* TO 'dba'@'%' IDENTIFIED BY PASSWORD '*****************************************' || GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `[databasename]`.* TO 'dba'@'%' |+----------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)
6.通过revoke命令可以移除用户的相关权限
mysql> revoke drop on [databasename].* from dba;Query OK, 0 rows affected (0.00 sec)mysql> show grants for dba;+----------------------------------------------------------------------------------------------------+| Grants for dba@% |+----------------------------------------------------------------------------------------------------+| GRANT USAGE ON *.* TO 'dba'@'%' IDENTIFIED BY PASSWORD '*****************************************' || GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON `[databasename]`.* TO 'dba'@'%' |+----------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)
以上就是详解MySQL创建数据库与创建用户以及授权的详细内容，更多请关注创想鸟其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/400912.html
微信扫一扫 
支付宝扫一扫 
