mysql常用指令

##mysql常用指令

###用户权限

 CREATE USER yy@'%' IDENTIFIED BY '123';
 
 GRANT ALL PRIVILEGES ON *.* TO user@localhost
 
  flush privileges;
  
  select host,user from mysql.user;

###utf8 -> utf8mb4

vi /etc/my.cnf [client]

default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4


[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

###导出表结构和数据

mysqldump -u用户名 -p密码 数据库名 > 数据库名.sql
mysqldump -uroot -p abc > abc.sql

###导入备份 mysql -uabc_f -p abc < abc.sql

###centos7安装mysql-server

centos7 yum instlal mysql-server 失败，需要加入
rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
yum install mysql

###删除库 drop database xxx

###数据 MySQL默认的数据文档存储目录为/var/lib/mysql /etc/目录下有配置文件my.cnf