wget https://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-5.6.36-1.el6.x86_64.rpm-bundle.tar
下载完成后 tar -xvf MySQL-5.6.36-1.el6.x86_64.rpm-bundle.tar 得到如下列表
MySQL-server-5.6.36-1.el6.x86_64.rpm
MySQL-client-5.6.36-1.el6.x86_64.rpm
MySQL-devel-5.6.36-1.el6.x86_64.rpm
MySQL-shared-5.6.36-1.el6.x86_64.rpm
MySQL-test-5.6.36-1.el6.x86_64.rpm
MySQL-embedded-5.6.36-1.el6.x86_64.rpm
MySQL-shared-compat-5.6.36-1.el6.x86_64.rpm
yum -y install libaio
yum -y install numactl
rpm -qa|grep mysql
rpm -e mysql-libs-5.1.73-5.el6_6.x86_64 --nodeps
rpm -ivh MySQL-server-5.6.36-1.el6.x86_64.rpm MySQL-client-5.6.36-1.el6.x86_64.rpm
- service mysql start 启动 mysql
- 查看初始密码
more /root/.mysql_secret
mysql -uroot -p密码,登陆数据库
修改初始密码 set password=password('123456')
- 修改配置,使mysql 支持远程连接
use mysql
update user set host = '%' where user = 'root';
- 提示报错,“ ERROR 1062 (23000): Duplicate entry ‘%-root’ for key ‘PRIMARY“,检查表发现已经存在了%
select host from user where user="root";
- 直接执行
flush privileges; 刷新一下
- 测试远程连接是否成功
数据库目录
/var/lib/mysql/
配置文件
/usr/share/mysql(mysql.server命令及配置文件)
相关命令
/usr/bin(mysqladmin mysqldump等命令)
启动脚本
/etc/rc.d/init.d/(启动脚本文件mysql的目录)