centos7 mysql5.7 安装与使用

安装

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server

启停

systemctl start mysqld.service
systemctl restart mysqld.service
systemctl status mysqld.service
systemctl stop mysqld.service

初始密码

grep "password" /var/log/mysqld.log

日志里有显示，注意冒号后全部都是

登录

mysql -uroot -p

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'abcd,1234';
grant all privileges on *.* to 'root'@'%' identified by 'abcd,1234';
grant all privileges on *.* to 'root'@'%' identified by 'abcd,1234' with grant option;
flush privileges;

创建用户

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

执行SQL文件

source  SQL文件路径

导出数据库

mysqldump -uroot -p 数据库名 > 文件名.sql

导入数据库

mysql -uroot -p 数据库名 < 文件.sql

注意UTF8MB4

编码用utf8mb4

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

查询是否锁表

show OPEN TABLES where In_use > 0;

查询到相对应的进程 === 然后 kill id

查询进程

 show processlist