https://blog.csdn.net/lpl_lpl_lpl/article/details/89183280
1、卸载之前安装的mysql
首先查看之前安装的MySQL
卸载之前安装的MySQL:通过 rpm -e 命令 或者 rpm -e --nodeps 命令来卸载掉
注:rpm -e mysql //普通删除模式,有时候会提示依赖于其他文件,无法删除。
rpm -e --nodeps mysql //强力删除模式,用该命令强力删除
2、下载所需rpm文件
2.1 下载libaio
http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm
2.2 下载并安装MySQL
https://dev.mysql.com/get/archives/mysql-5.6/MySQL-5.6.26-1.linux_glibc2.5.x86_64.rpm-bundle.tar
3、解压并安装
3.1安装libaio
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm
3.2解压并安装mysql
tar -xf MySQL-5.6.42-1.el6.x86_64.rpm-bundle.tar
rpm -ivh MySQL-server-5.6.42-1.el6.x86_64.rpm
rpm -ivh MySQL-devel-5.6.42-1.el6.x86_64.rpm
rpm -ivh MySQL-client-5.6.42-1.el6.x86_64.rpm
rpm -ivh MySQL-shared-5.6.42-1.el6.x86_64.rpm
rpm -ivh MySQL-shared-compat-5.6.42-1.el6.x86_64.rpm
3.3修改 my.cnf 配置文件的地址
cp/usr/share/mysql/my-default.cnf /etc/my.cnf
在 my.cnf 文件中的[mysqld]中加入如下内容
innodb_file_per_table
max_connections=4096
collation-server=utf8_general_ci
character-set-server=utf8
3.4 初始化 MySQL 及设置密码
/usr/bin/mysql_install_db
service mysql start
cat/root/.mysql_secret#查看初始密码
#登陆
mysql -u root -p
SETPASSWORD=PASSWORD('abcd1234');#重新设置密码
3.5 配置远程访问
# grant all privileges on *.* to root@'%' identified by 'root' WITH GRANT OPTION;
# flush privileges;
complete!
————————————————————————————————————————————————————————