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