mysql

mysql8.0 授权外网访问

use mysql;

 

select host, user, authentication_string, plugin from user;

 

 

 

 update user set host='%' where user='root';

 update user set host='%' where user='root';

 

 

https://blog.csdn.net/mouday/article/details/89447263

-- 修改列名称
alter table tablename change col1 col2tinyint(3);

　　

MySQL命令行中给表添加一个字段（字段名、是否为空、默认值）