前言

• mysql 5.6.47

mysql創建賬號并賦予權限

為新的數據庫flowdb，創建賬戶flowdba。將flow庫的所有權限賦予flowdba賬戶。

操作步驟

創建flowdba賬戶

mysql> use mysql; Database changed mysql> create user 'flowdba'@'%' identified by '123456'; Query OK, 0 rows affected (0.00 sec) mysql> select host,user,password from user; +-------------------------+---------+------------------------------------------- + | host | user | password | +-------------------------+---------+------------------------------------------- + | localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | izm5e0k0bexacam32zw837z | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | 127.0.0.1 | root | | | ::1 | root | | | localhost | | | | izm5e0k0bexacam32zw837z | | | | % | flowdba | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | +-------------------------+---------+------------------------------------------- + 7 rows in set (0.00 sec) # 將flow數據庫所有權限賦給flowdba用戶 mysql> grant all privileges on flow.* to 'flowdba'@'%' with grant option; Query OK, 0 rows affected (0.00 sec) # 刷新權限 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)

參考

https://www.cnblogs.com/anzerong2012/p/10738186.html

總結

以上是生活随笔為你收集整理的mysql创建账号并赋予权限的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。