mysql常用部分

忘记密码：/etc/my.config 中的mysqld添加skip-grant-tables

不区分大小写：lower_case_table_names=1

不能远程连接：grant all privileges on *.* to 'root'@‘%’ identified by 'wangyi' with grant option;

    flush privilege;

更新：update table_name set col="new_value" where col="sth"