centos7安装mysql

一、下载mysql

使用linux命令下载:

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz

二、使用xshell连接到linux服务器

进入安装包的下载目录: cd /opt/，对下载mysql进行解压

tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz

将解压后的mysql移动到/usr/local/mysql下

mv mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/mysql

三、添加mysql组和mysql用户

检查mysql组和用户是否存在

cat /etc/group | grep mysql
#类似
mysql:x:490:
cat /etc/passwd | grep mysql
#类似
mysql:x:496:490::/home/mysql:/bin/bash

添加组和用户

groupadd mysql

useradd -r -g mysql mysql

四、安装数据库

1、创建data目录

cd /usr/local/mysql

mkdir data

2、将/usr/local/mysql的所有者及所属组改为mysql

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

3、在/usr/local/mysql/support-files目录下创建my_default.cnf

#for advice on how to change settings please see
#*****do not edit this file.it`s a template which will be copied to the default
#*****location during install,and will be replaced if you upgrade to a newer version
#*****of mysql
[mysqld]
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port=3306
socket=/tmp/mysql.sock
character-set-server=utf8
log-error=/usr/local/mysql/data/mysqld.log
pid-file=/usr/local/mysql/data/mysqld.pid
4、拷贝,提示是否覆盖，y

cp my_default.cnf /etc/my.cnf

5、初始化mysqld

cd /usr/local/mysql

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

初始化成功之后，查看日志

/usr/local/mysql/data/mysqld.log,临时密码

把启动脚本放到开机初始化目录中

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

启动mysql服务

service mysql start

6、登陆mysql，密码为初始密码

7、修改密码

8、添加远程访问权限

use mysql;

update user set host='%' where user='root';

flush privileges;

9、重启mysql生效

service mysql restart

或者: service mysql stop   

         service mysql start

修改/etc/profile文件，在文件末尾添加MySQL配置

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

并使用 source /etc/profile 使修改立即生效