mysql

1:

select Host,User,max_questions,max_updates,max_connections,authentication_string,password_expired,password_last_changed,account_locked from user;

update user set account_locked='Y' where Host='%' and User='root';

2:

create database cloud;

GRANT all ON cloud.* TO jxin@'%' IDENTIFIED BY 'JxApi123';

flush privileges; 

 

3:

SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name="base_user";
alter table base_user  auto_increment = 1;

展开阅读全文
©️2019 CSDN 皮肤主题: 大白 设计师: CSDN官方博客
应支付0元
点击重新获取
扫码支付

支付成功即可阅读