亚马逊 Linux mysql5.7 安装纪录

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
 

cp /home/admin/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz /usr/local/mysql

#解压压缩包
tar -zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

重命名mysql-5.7.24

mv mysql-5.7.24-linux-glibc2.12-x86_64 mysql-5.7.24

sudo groupadd mysql
sudo useradd -r -g mysql mysql

sudo apt-get install libaio-dev

sudo mkdir -p /usr/local/mysql/mysql-5.7.24/data

sudo chown -R mysql:mysql /usr/local/mysql
sudo chmod -R 755 /usr/local/mysql

#到mysql-5.7.24
cd /usr/local/mysql/mysql-5.7.24
#执行命令
./bin/mysqld  --initialize  --user=mysql  --basedir=/usr/local/mysql/mysql-5.7.24  --datadir=/usr/local/mysql/mysql-5.7.24/data

[Note] A temporary password is generated for root@localhost: p?aTWqj>O1DG

vi /etc/my.cnf

#里面改成如下配置
#切勿偷懒漏配置
[mysqld]
basedir=/usr/local/mysql/mysql-5.7.24
datadir=/usr/local/mysql/mysql-5.7.24/data
socket=/var/lib/mysql/mysql.sock
port=3308
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=10000
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
socket=/var/lib/mysql/mysql.sock

[mysql]
socket=/var/lib/mysql/mysql.sock

sudo mkdir -p /var/log/mariadb
sudo touch /var/log/mariadb/mariadb.log
sudo chown mysql:mysql /var/log/mariadb/mariadb.log
sudo chmod 755 /var/log/mariadb/mariadb.log

sudo mkdir -p /var/lib/mysql
sudo chown mysql:mysql /var/lib/mysql
sudo chmod 755 /var/lib/mysql

sudo /usr/local/mysql/mysql-5.7.24/support-files/mysql.server start

#编辑环境变量
vim /etc/profile

#在文件最后面加入下面配置
export MYSQL_HOME=/usr/local/mysql/mysql-5.7.24
export MYSQL_PATH=${MYSQL_HOME}/bin:${MYSQL_HOME}/lib
export PATH=$PATH:/usr/local/mysql/mysql-5.7.24/bin

export CHKCONFIG_HOME=/usr/sbin
export PATH=/usr/sbin:$PATH

#保存后刷新环境变量
source /etc/profile

#连接mysql
mysql -u root -p

#设置你的密码
set password for root@localhost = password('123456');

修改支持外网ip直接访问，开发的的时候用
use mysql;

update user set user.Host='%' where user.User='root';

flush privileges;

#将服务文件拷贝到init.d下，并重命名为mysql
cp /usr/local/mysql/mysql-5.7.24/support-files/mysql.server /etc/init.d/mysqld
#赋予可执行权限
chmod +x /etc/init.d/mysqld
#添加服务

vim /usr/lib/systemd/system/mysql.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target

[Service]
User=mysql
Group=mysql
ExecStart=/etc/init.d/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
#Restart=on-failure
#RestartPreventExitStatus=1
#PrivateTmp=false

systemctl daemon-reload

systemctl start mysql

systemctl stop mysql