mysql5.7.24怎么安装,mysql5.7.24二进制快速安装

1.下载连接

https://dev.mysql.com/downloads/mysql/5.7.html#downloads

2.解压

tar zxf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

3.重命名

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

4.复制到指定目录

cp -r mysql /usr/local/

5.新建组

groupadd mysql

6.新建用户

useradd -g mysql -d /usr/local/mysql -s /sbin/nologin -MN mysql

7.进入mysql根目录

cd /usr/local/mysql/

8.修改拥有者为mysql用户

chown -R mysql:mysql ./

9.将mysql/support-files下的mysql.server 复制到 /etc/init.d/下并自定义为mysql

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

10.修改该服务

vi /etc/init.d/mysql

11.修改的内容

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

12.进入etc目录

cd /etc

13.删除my.cnf

rm -rf my.cnf

14.新建my.cnf

vi my.cnf

[client]

port = 3306

default-character-set=utf8

[mysqld]

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

port = 3306

character-set-server=utf8

default_storage_engine = InnoDB

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

15.进入mysql/bin目录下

cd /usr/local/mysql/bin/

16.执行以下命令

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

17.遇到错误

./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

18.执行以下命令

yum -y install libaio

19.执行初始化

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

20.遇到错误

./mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory

21.执行以下命令

yum -y install numactl.x86_64

22.执行初始化

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

23.执行启动命令

service mysql start

24.登录 进入mysql/bin目录下执行

./mysql -uroot -p

25.输入密码

Enter password:输入默认的临时密码

26.修改密码

set password=password('新密码');

27.设置远程访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '访问密码';

flush privileges;

28.查看自启服务列表

chkconfig --list

29.添加mysql服务到自启服务

chkconfig --add mysql

30.设置自启

chkconfig mysql on

31.环境变量

为了不用在mysql/bin目录下才能连接mysql 将mysql/bin目录设置到环境变量中

vi ~/.bash_profile

# mysql environment

export MYSQL_HOME=/usr/local/mysql

export PATH=$PATH:$MYSQL_HOME/bin

. ~/.bash_profile