北大青鸟小游网:值得大家信赖的游戏下载站!
发布时间:2021-06-30 11:15:57来源:北大青鸟手游网作者:北大青鸟手游网
仅新建一个newuser用户
方法一:
MariaDB [(none)]> create user newuser@localhost identified by ‘123456’; Query OK, 0 rows affected (0.22 sec)MariaDB [(none)]> select user from mysql.user; +———+ | user | +———+ | aa | | root | | root | | | | aa | | bb | | lcz | | my | | mytest | | newuser | | nome | | root | | | | root | +———+ 14 rows in set (0.00 sec)MariaDB [(none)]>
方法二:
MariaDB [(none)]> insert into mysql.user(user,host,password) values(‘ggo’,’localhost’,password(‘1234’)); Query OK, 1 row affected, 4 warnings (0.24 sec)MariaDB [(none)]> flush privileges; Query OK, 0 rows affected (0.25 sec)
效果
[root@localhost ~]# mysql -uggo -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 4 Server version: 5.5.52-MariaDB MariaDB ServerCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.MariaDB [(none)]>
新建一个my用户并且授权全部操作权限
MariaDB [(none)]> grant all privileges on *.* to my@localhost identified by ‘123456’; Query OK, 0 rows affected (0.00 sec)MariaDB [(none)]> select user from mysql.user; +——–+ | user | +——–+ | aa | | root | | root | | | | aa | | bb | | lcz | | my | | mytest | | nome | | root | | | | root | +——–+ 13 rows in set (0.14 sec)MariaDB [(none)]>
查看用户权限
MariaDB [(none)]> show grants for my@localhost; +——————————————————————————————————————–+ | Grants for my@localhost | +——————————————————————————————————————–+ | GRANT ALL PRIVILEGES ON *.* TO ‘my’@’localhost’ IDENTIFIED BY PASSWORD ‘*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9’ | +——————————————————————————————————————–+ 1 row in set (0.00 sec)MariaDB [(none)]>
指定部分授权
grant insert,update,delete,select on *.* to mytest@localhost;
和平精英通讯塔是什么 和平精英通讯塔玩法详细解析
跑跑卡丁车手游制霸赛场挑战任务全攻略
神雕侠侣2手游氪金玩家消费指南
王牌战士幽灵实战技巧讲解
王者荣耀王者模拟战即将上线 王者模拟战玩法介绍
王牌战士团战如何切入详细讲解
第五人格先知天赋怎么加点
崩坏3精英工坊新加入了什么武器圣痕 精英工坊新武器圣痕一览
古今江湖童姥牌组搭配使用技巧攻略
坠落星界
其它游戏
炽姬无双
角色扮演
王者荣耀
角色扮演
和平精英
枪战射击
邪恶疯人院
休闲益智
神雕侠侣2
角色扮演
一刀传世
角色扮演
九州天空城3D
角色扮演
斗罗大陆手游
角色扮演