天天看点

sql语句

mysql

【创建账号】:

create user 'finance'@'%' identified by ‘xxx’;

【给数据库权限】:

grant all on database.* to 'finance'@'%';

all可以换成 select,update,….

【撤销权限】:

revoke all on *.* from 'finance'@'%';

【跳过权限检测启动mysql】

解决root账号无权限的方法:

mysqld_safe --skip-grant-tables & 

update user set password=password(‘root’) where user=‘root’;

mysql -u root -p

【修改mysql库和表的编码】

set character_set_client = utf8;

create database name character set utf8;

alter database `finance` default character set utf8 collate utf8_general_ci;  

alter table `finance`.`f_company` default character set utf8 collate utf8_general_ci;  

alter table `finance`.`f_condition` default character set utf8 collate utf8_general_ci;  

alter table `finance`.`f_config` default character set utf8 collate utf8_general_ci;  

alter table `finance`.`f_user` default character set utf8 collate utf8_general_ci;  

【修改表引擎】

alter table table_name engine=innodb;  

alter table table_name engine=myisam;  

【修改表编码】

alter table third.t_order_driver default character set utf8 collate utf8_general_ci;

【每次创建时时间】mysql 5.6+

current_timestamp

【每次更新时修改时间】mysql 5.6+

current_timestamp on update current_timestamp