mysql 5.7插入很慢_centos7安装mysql

安装Mysql

通常使用5.7版本即可
建议使用解压版安装
下载地址 Mysql5.7

# 解压
tar -zxf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
​
# 移动到/usr/local/mysql
mv mysql-5.7.31-linux-glibc2.12-x86_64 /usr/local/mysql
​
# 初始化
cd /usr/local/mysql
​
# 创建数据目录
mkdir data
​
# 创建用户和用户组
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql/
​
# 初始化数据库
./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
​
# 把mysql放到本地服务中
cp -a ./support-files/mysql.server /etc/init.d/mysqld

替换配置 vim /etc/my.cnf 插入下面内容

[mysqld]
basedir=/usr/local/mysql
​
datadir=/usr/local/mysql/data
​
socket=/tmp/mysql.sock
​
user=mysql
​
port=3306
​
character-set-server = utf8mb4
​
collation-server = utf8mb4_unicode_ci
​
init_connect='SET NAMES utf8mb4'
​
symbolic-links=0
​
max_connections=200
​
default-storage-engine=INNODB
​
lower_case_table_names=1
​
max_allowed_packet=32M
​
explicit_defaults_for_timestamp=true
​
[mysqld_safe]
​
log-error=/var/log/mysql/mysql.log
​
pid-file=/var/run/mysql/mysql.pid

创建授权og-error、pid-file路径

mkdir /var/log/mysql
​
mkdir /var/run/mysql
​
chmod -R 777 /var/log/mysql/
​
chmod -R 777 /var/run/mysql/

启动mysql

service mysqld start

查看密码并登陆修改

cat /root/.mysql_secret
​
alias mysql=/usr/local/mysql/bin/mysql
​
mysql -uroot -p
​
SET PASSWORD FOR 'root'@localhost=PASSWORD('123456');
​
# 允许远程访问
use mysql;
​
update user set host = '%' where user = 'root';
​
FLUSH PRIVILEGES;

配置mysql环境变量，修改/etc/profile文件，在最下方添加配置，加入开机自启

vi /etc/profile
​
增加如下配置：
​
export PATH=$PATH:/usr/local/mysql/bin
​
立即生效
​
source /etc/profile

开机自启配置

chmod +x /etc/init.d/mysqld
​
chkconfig --add mysqld
​
chkconfig --list
​
# 如果看到mysql的服务，并且3,4,5都是on的话则成功，如果是off，则键入
​
chkconfig --level 345 mysqld on