mysql添加用户_MySQL
程序员文章站
2022-06-17 17:14:44
...
bitsCN.com
mysql添加用户
先以root用户登入
选择要添加的数据库(jbpm)
use jbpm
grant all on jbpm to scott@localhost identified by scott
删除用户
mysql -uroot -proot
use mysql
delete from user where user=scott and host=localhost;
flush privileges; bitsCN.com
先以root用户登入
选择要添加的数据库(jbpm)
use jbpm
grant all on jbpm to scott@localhost identified by scott
删除用户
mysql -uroot -proot
use mysql
delete from user where user=scott and host=localhost;
flush privileges; bitsCN.com
上一篇: MySQL高级操作指令汇总