CentOS安装mysql5.7的方法步骤

1

2

3

4

#进入local目录

cd /usr/local/

#下载mysql

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

1

2

3

tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql

mkdir data

1

2

3

groupadd mysql

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

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

1

2

3

4

yum -y install libaio-devel

./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

cp -a ./support-files/my-default.cnf /etc/my.cnf

cp -a ./support-files/mysql.server /etc/init.d/mysqld

1

2

3

4

5

#打开配置目录

vi /etc/my.cnf

#增加目录配置

basedir=/usr/local/mysql/

datadir=/usr/local/mysql/data

1

2

3

4

5

6

7

8

#修改环境变量配置文件

vi /etc/profile

#增加mysql全局变量，使service mysqld start可以在任意位置使用

export PATH=$PATH:/usr/local/mysql/bin

#即时生效

source /etc/profile

#启动mysql

service mysqld start

1

2

3

4

5

6

7

8

9

10

#mysql刚安装完毕没有密码进入mysql命令行

mysql -uroot -p

#查询mysql用户

select User, Host, Password FROM mysql.user;

#修改root密码

update mysql.user set password=password('root') where User="root";

#为root添加远程权限

grant all privileges on *.* to'root'@'%'identified by'root' with grant option;

#刷新权限

flush privileges;