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;

展开阅读全文

没有更多推荐了,返回首页