创建用户并设置密码:
mysql
create user test IDENTIFIED BY '1234546';
为新用户分配权限:
mysql
//为该用户分配所有的权限
GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost' IDENTIFIED BY '123456';
//查看当前用户的权限
SHOW GRANTS;
//撤销上一次的授权
REVOKE ALL PRIVILEGES ON *.* FROM 'test'@'localhost'
/继续阅读 »
1.编码
1.查看数据库编码
show variables like 'char%';
修改编码格式:
mysql
set character_set_database = utf8;
set character_set_server = utf8;
more
2.查看建库语句
mysql
show create database your_database_name;
更改编码:
alter database `file` default character set utf8 collate utf8_general_ci;
在mysql中反引号 `` 用于用于用户自定义的量,而单引号'' 用于系统变量
3.修改继续阅读 »