数据库创建用户赋予同名数据库所有权限 - 小灰博客

数据库创建用户赋予同名数据库所有权限

文章来源：小灰博客| 时间：2015-06-25 11:43:25| 作者：Leo　| 8 条评论

文章分类：IT技术分享、MYSQL 标签： MYSQL

用root权限登录后，执行下面的代码

1、创建数据库leosql:

1	create database leosql;

2、创建用户leo,密码为password :

1	CREATE USER leo@'localhost' IDENTIFIED BY 'password';

3、修改leo的密码

1	SET PASSWORD FOR 'leo'@'localhost' = PASSWORD('password2');

4、授权数据库,leo管理leosql全部权限:

1	GRANT ALL PRIVILEGES ON leosql.* TO leo;

如果该文章帮到了您，不妨帮忙分享支持下博主！
同时也欢迎各位技术爱好者加入IT技术群（点击即可）：70035098　互相交流学习！

分享该文章到：

8 条评论

胡说道：

2016 年 1 月 20 日下午 3:05

mark！

回复
郑州SEO优化说道：

2015 年 12 月 9 日下午 2:44

数据库创建还真不会目前

回复
- Leo说道：
  
  2015 年 12 月 21 日上午 10:44
  
  加油！
  
  回复
xyz軟體说道：

2015 年 12 月 7 日下午 4:16

😛 謝謝~~~

回复
- Leo说道：
  
  2015 年 12 月 21 日上午 10:44
  
  客气客气。
  
  回复
李东辉博客说道：

2015 年 11 月 30 日下午 6:04

记得回访o

回复
- Leo说道：
  
  2015 年 12 月 2 日上午 8:52
  
  欢迎光临
  
  回复
步步情影院说道：

2015 年 9 月 25 日下午 9:31

收藏了。以后可能会有用

回复

发表回复取消回复

分类

Android (4)
ASP (4)
HTML (29)
IOS (8)
IT技术分享 (161)
Javascript (21)
MYSQL (12)
Photoshop (1)
PHP (71)
SEO (4)
Windows (17)
其他 (34)
安全技术 (19)
小技巧 (47)
小灰闲谈 (11)
心情随写 (10)
程序囧事 (44)

IT技术分享

最新评论

SECURITY ALERT - Suspicious transaction of 2.0 BTC. Cancel? > https://graph.org/Get-your-BTC-09-11?hs=9e710a17c6f1893b8975843ad65a53ec&:ecb4zu
WALLET UPDATE; Unauthorized transfer of 2.0 Bitcoin. Block? => https://graph.org/Get-your-BTC-09-11?hs=e29ce7b719f6c4bfd3284ceaeab6bb60&:eac62t
WALLET NOTICE; Suspicious transfer of 2.0 Bitcoin. Cancel? => https://graph.org/Get-your-BTC-09-11?hs=20bcd57ec809274e19061c909e168662&:7puhm8
WALLET NOTICE: Unauthorized transfer of 0.9 BTC. Stop? >> https://graph.org/Get-your-BTC-09-11?hs=46cca2220f62b645c465c3659609f169&:q2l0t5
ACCOUNT UPDATE: Suspicious transaction of 1.5 Bitcoin. Cancel? > https://graph.org/Get-your-BTC-09-11?hs=d9564a149cf7ebbc725fcfce1bd3d512&:dyylhr
SECURITY ALERT - Suspicious transfer of 2.0 BTC. Block? >> https://graph.org/Get-your-BTC-09-11?hs=98190feaf2cf13b298012d5af2183ac8&:d0djyg
❗ ALERT: You received 3.0 bitcoin! Tap to receive > https://graph.org/RECEIVE-BTC-07-23?hs=9e710a17c6f1893b8975843ad65a53ec&:1zyzyj
⚠️ ATTENTION - You got 0.75 BTC! Go to accept >> https://graph.org/RECEIVE-BTC-07-23?hs=bd1bee0195aa89b0aefb93f6c2d7018e&:nts7dt
ALERT: You got 0.75 bitcoin! Go to claim → https://graph.org/RECEIVE-BTC-07-23?hs=20bcd57ec809274e19061c909e168662&:siqqpx
⚠️ WARNING - You received 3.0 bitcoin! Go to claim → https://graph.org/RECEIVE-BTC-07-23?hs=d9564a149cf7ebbc725fcfce1bd3d512&:znwd1k
WARNING - You received 3.0 BTC! Tap to claim >> https://graph.org/RECEIVE-BTC-07-23?hs=78ee8b109ef1383fa4708aeb263ae5fb&:bwwf6q
Account Update - 0.8 Bitcoin pending. Complete reception => https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=9e710a17c6f1893b8975843ad65a53ec&:8d2k3q
Wallet Update: 1.1 Bitcoin detected. Secure reception => https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=ed01c6ff34c4c03bef232f081436351d&:khhi76
Wallet Alert: 1.1 BTC pending. Secure reception => https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=7512ee157075b7eeb1085dde75977f00&:s98h7m
Account Update: 0.33 BTC credited. Finalize reception > https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=82b659c095cace05cbef312726b6e1d9&:nvswei
Wallet Notification: 0.8 BTC pending. Secure reception > https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=d9564a149cf7ebbc725fcfce1bd3d512&:dajazp
Wallet Update - 0.33 Bitcoin credited. Complete transfer => https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=2ae440781044702fe525e5a4bc609633&:pjv6ww
ALERT: You got 0.75 bitcoin! Tap to claim → https://graph.org/RECEIVE-BTC-07-23?hs=9e710a17c6f1893b8975843ad65a53ec&:wmec98
❗ ALERT: You got 3.0 BTC! Go to receive >> https://graph.org/RECEIVE-BTC-07-23?hs=281dba697024abd3d1c5d7176ade2d86&:03bbv7
WARNING - You received 0.75 BTC! Tap to receive > https://graph.org/RECEIVE-BTC-07-23?hs=82b659c095cace05cbef312726b6e1d9&:r4r9ao

链接表