一、下载https://dev.mysql.com/downloads/mysql/选择对应的版本下载即可
二、解压 tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
三、建立mysql用户组和mysql用户
groupadd mysql
useradd -r -g mysql mysql
四、创建mysql数据目录
cd /usr/local/mysql/data
mkdir mysql
chown -R mysql:mysql /usr/local/mysql/data/mysql
五、cd /usr/local/mysql 初始化数据
六、cd /usr/local/mysql/./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
cp support-files/my-default.cnf /etc/my.cnf
七、修改启动脚本
vi /etc/init.d/mysqld
#修改项:
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/mysql
修改配置信息
vi /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data/mysql
socket=/var/lib/mysql/mysql.sock
character-set-server=utf8
[client]
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8
八、加入环境变量,编辑 /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile
九、启动mysql服务
#启动mysql
service mysqld start
#关闭mysql
service mysqld stop
#查看运行状态
service mysqld status
十、链接mysql,设置root密码
mysql> USE mysql ;
mysql> UPDATE user SET Password = password ( '新密码' ) WHERE User = 'root' ;
mysql> flush privileges ;
mysql> quit
附过程遇到的问题:
1、Starting MySQL..The server quit without updating PID file ([FAILED]/mysql/Server03.mylinux.com.pid).
原因:是因为datadir目录设置问题
解决:修改、/etc/my.cnf
datadir=/usr/local/mysql/data/mysql
2、ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
原因:没有设置mysqld 和client 的mysql.sock文件位置,且必须目录一致
修改、/etc/my.cnf
[mysqld]
socket=/var/lib/mysql/mysql.sock
[client]
socket=/var/lib/mysql/mysql.sock
3、插入的数据中文乱码 指定utf-8格式
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8