Linux下部署MySQL并且免密登录

• MySQL的下载
• https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
• 创建用户和用户组

groupadd mysql
useradd -r -g mysql mysql

• 将安装目录所有及所属组改为MySQL

chown -R mysql.mysql /usr/local/mysql

• 创建data文件夹，存放数据库和表之类的数据

mkdir data

• 安装依赖

yum install libaio

• 初始化数据库

/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize

• 配置/etc/my.cnf文件

[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
# 取消密码验证
skip-grant-tables
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

• 将mysql添加到服务中

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

• 设置开机启动

chkconfig mysql on

• 启动MySQL服务

service mysql start

• 跳过密码免密登录

/usr/local/mysql/bin/mysql -uroot -p