mysql5.6的安装(多个rpm包yum安装)
[root@localhost ~]# vim /etc/sysconfig/i18n
LANG="zh_CN.UTF-8" #一般修改为这个
[root@localhost ~]# source /etc/sysconfig/i18n
安装mysql5.6(至少5.6以上)
1)删除低版本的mysql服务
[root@localhost ~]# rpm -e --nodeps mysql-server mysql
[root@localhost ~]# rm -rf /etc/my.cnf #有就删除,没有更好
[root@localhost ~]# rm -rf /var/lib/mysql/* #有就删除,没有更好
2)新版本的mysql的安装、初始密码设置、登录和退出数据库
[root@localhost ~]# rpm -q mysql-server mysql 确定是未安装状态,因为要安装新版本的
package mysql-server is not installed
package mysql is not installed
[root@localhost ~]# rz
上传mysql5.6打包的rpm包
[root@localhost ~]# ls
MySQL-5.6.15-1.el6.x86_64.rpm-bundle.tar
[root@localhost ~]# tar -xf MySQL-5.6.15-1.el6.x86_64.rpm-bundle.tar #解包
[root@localhost ~]# ls
MySQL-5.6.15-1.el6.x86_64.rpm-bundle.tar MySQL-embedded-5.6.15-1.el6.x86_64.rpm MySQL-shared-compat-5.6.15-1.el6.x86_64.rpm
MySQL-client-5.6.15-1.el6.x86_64.rpm MySQL-server-5.6.15-1.el6.x86_64.rpm MySQL-test-5.6.15-1.el6.x86_64.rpm
MySQL-devel-5.6.15-1.el6.x86_64.rpm MySQL-shared-5.6.15-1.el6.x86_64.rpm
[root@localhost ~]# rpm -Uvh MySQL-*.rpm #升级安装所有的rpm包
[root@localhost ~]# yum -y install *.rpm #可以解决依赖包关系,一般这种安装比上面靠谱
[root@localhost ~]# rpm -qa |grep -i mysql #查看是否安装成功
MySQL-client-5.6.15-1.el6.x86_64
MySQL-embedded-5.6.15-1.el6.x86_64
MySQL-shared-compat-5.6.15-1.el6.x86_64
MySQL-devel-5.6.15-1.el6.x86_64
MySQL-test-5.6.15-1.el6.x86_64
MySQL-server-5.6.15-1.el6.x86_64
MySQL-shared-5.6.15-1.el6.x86_64
[root@localhost ~]# /etc/init.d/mysql start #启动服务,新版本不加d
[root@localhost ~]# chkconfig mysql on
[root@localhost ~]# netstat -anput |grep 3306
tcp 0 0 :::3306 :::* LISTEN 9102/mysqld
[root@localhost ~]# cat /root/.mysql_secret #别忘.了,查看装服务时生成的默认密码
# The random password set for the root user at Mon Mar 19 03:59:35 2018 (local time): bpurdPhG
[root@localhost ~]# mysql -uroot -pbpurdPhG
mysql> set password for root@"localhost"=password("123");
mysql> flush privileges;
mysql> quit
[root@localhost ~]# mysql -uroot -p123
mysql> quit
[root@localhost ~]# ps -ef |grep mysql
root 1800 1 0 20:18 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/bogon.pid
mysql 1918 1800 1 20:18 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/bogon.err --pid-file=/var/lib/mysql/bogon.pid --port=3308
root 1947 1445 0 20:19 pts/1 00:00:00 grep mysql
这种安装的默认配置文件my.cnf位置:/usr/my.cnf
[root@localhost ~]# ls /usr/my.cnf
/usr/my.cnf
安装后的默认sock文件目录和binlog日志存放目录:/var/lib/mysql/
[root@bogon ~]# ls /var/lib/mysql/
auto.cnf bogon.pid ib_logfile0 mysql performance_schema RPM_UPGRADE_MARKER-LAST
bogon.err ibdata1 ib_logfile1 mysql.sock RPM_UPGRADE_HISTORY test
如果对运维课程感兴趣,可以在b站上、csdn或微信视频号 上搜索我的账号: 运维实战课程,可以关注我,学习更多免费的运维实战技术视频