mysql学习之-5.7安装文档

--install mysql


--检查是否有libaio
rpm -qa | grep libaio
--增加用户和组
groupadd mysql
useradd -r -g mysql mysql
--copy或者解压 tar -zvxf mysql-5.7.28-linux-glibc2.5-x86_64.tar.gz
mkdir -p /opt/mysql
scp -p -r ip:/opt/mysql/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz /opt/mysql/
tar -zvxf mysql-5.7.28-linux-glibc2.5-x86_64.tar.gz
chown -R mysql:mysql /opt/mysql/mysql-5.7.28-linux-glibc2.12-x86_64
ln -s /opt/mysql/mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql

mv mysql-5.7.28-linux-glibc2.12-x86_64 mysql
cd mysql
mkdir log
chown -R mysql:mysql /usr/local/mysql
scp -r ip:/etc/my.cnf /etc/
mkdir -p /u01/mysql/mysql5728/
chown -R mysql:mysql /u01/mysql

--加入环境变量
vi /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
--echo 'export PATH=$PATH:/opt/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin' >> /etc/profile
source /etc/profile
--查看是否有mysql命令
which mysql

--初始化，如果报错。则清除/u01/mysql/mysql5722/的文件再试
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/u01/mysql/mysql5728
cd /opt/mysql/mysql-5.7.28-linux-glibc2.12-x86_64
./start.sh启动mysql
--#!/bin/sh
--nohup bin/mysqld_safe --defaults-file=/etc/my.cnf --user=root >/dev/null 2>&1 &

--找到初始化密码
more /usr/local/mysql/log/mysql.log
mysql -uroot -p
--输入密码

--修改密码
SET PASSWORD = PASSWORD('123@2018');
--给远程登录权限
grant all privileges on *.* to root@"%" identified by "123@2018" with grant option;
flush privileges;

--create user
create user 'user1' identified by '123!123$';
grant select,delete,update,insert on *.* to 'user1';
flush privileges;

--关闭防火墙和seliunx防火墙
service firewalld stop/systemctl stop firewalld
systemctl disable firewalld
vi /etc/selinux/config
--修改为disabled
SELINUX=disabled
--安装完毕，尝试远程登录。


--参数
lower_case_table_names = 1 --表名不区分大小写