选择安装包
卸载自带MySQL
rpm -qa | grep mysql
rpm -e --nodeps mysql*
添加mysql用户和用户组
groupadd mysql
useradd -r -g mysql mysql
安装依赖
yum install libaio -y
yum install numactl -y
安装mysql文件到/user/local/mysql目录下
cd /root/
wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz
#MD5校验
tar zxf mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz # 解压
mv mysql-5.6.41-linux-glibc2.12-x86_64 /usr/local/mysql
修改权限
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
初始化数据库
cd /usr/local/mysql
scripts/mysql_install_db --user=mysql
chown -R root .
主配置文件服务器参数设置
cd /usr/local/mysql
cp support-files/my-default.cnf /etc/my.cnf
vi /etc/my.cnf
数据库目录默认值为/usr/local/mysql/data 生产环境有一块专门的
重做日志大小默认48M 该默认值在生产环境中太小远远不够
undo
redo
为MySQL提供服务脚本
cd /usr/local/mysql
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
mysqld_safe
开机自启动
chkconfig
chkconfig mysqld on
开启MySQL实例
service mysqld start
修改密码
update mysql.user set password = PASSWORD('qiuyue') where user = 'root';
FLUSH PRIVILEGES;
添加到系统环境变量
PATH=$PATH:/usr/local/mysql/bin
mysqld -V
mysql -V
mysqldump -V