centos6.6中安装mysql 5.7.23
1.Linux版本
cat /etc/issue
2.下载mysql包,本次安装的是5.7.23
https://dev.mysql.com/downloads/mysql/5.6.html#downloads
3.解压到/usr/local/目录下
tar -zxvf /home/omc/mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
4. 改名
mv mysql-5.7.23-linux-glibc2.12-x86_64/ mysql/
5. 创建data目录
mkdir mysql/data
6. 创建用户和用户组
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql
chown -R mysql.mysql /usr/local/mysql/
7.初始化mysql
7.1 初始化mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
7.2 初始化报错,依赖缺失
yum -y install libaio
yum -y install numactl
7.3 配置163镜像
无法连接镜像,下载163镜像CentOS6-Base-163.repo,将其copy到/etc/yum.repos.d/中
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.bak
回到7.2安装libaio和numactl
初始化成功后,最后为root密码
8. 配置文件
8.1 my.cnf修改
vi /etc/my.cnf
socket=/tmp/mysql.sock
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
character_set_server=utf8
user=mysql
port = 3306
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/usr/local/mysql/data/error.log
pid-file=/usr/local/mysql/data/mysql.pid
tmpdir = /tmp
8.2把mysql放到本地系统服务中
vi /etc/init.d/mysqld
9.启动mysql
service mysqld start
登录mysql,输入密码(操作7中最后一步)
bin/mysql -uroot -p
重置root密码
SET PASSWORD FOR 'root'@localhost=PASSWORD('123456');
更改为可远程连接访问
update user set host='%' where user='root' limit 1;
flush privileges;
10 .使用windows的SQLyog客户端来连接