mysql创建数据库及用户

first go to mysql install dir

mysql.exe -u root -p

enter your password.

 

check exist databases:

mysql>show databases;

 

create the db:

mysql>create database abc;

create the db use some charset beside default:
mysql>create database if not exists abc default charset utf8mb4 COLLATE utf8mb4_unicode_ci;
ps: for some unusual chinese characters utf8mb4 is better than utf8;

cerate user:

1.local user:

mysql> create user user1@localhost identified by '123';

2.remote user:

mysql> create user user1@'%'identified by '123';

 

授权:

所有权限

mysql> grant all privileges on abc.* to  user1@localhost;

部分权限

mysql> grant select, insert, update, delete on abc.* to  user1@'%';

mysql> flush privileges;

 

修改密码

mysql> set password for user1 =‘456’;
for mysql after 5.5
mysql> set password for user1 =password(‘456’);

mysql> flush privileges;

或者

mysql> use mysql;
mysql> update user set password = '456' where user = 'user1';
for mysql after 5.5
mysql> update user set password = password('456') where user = 'user1';
mysql> flush privileges;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值