centos6.7--mysql 5.6.26卸载与安装

1、停掉服务 service mysqld stop

2、删除rpm包 rpm -qa | grep -i mysql | xargs rpm -e --nodeps

3、删除遗留文件 find / -name mysql | xargs rm -rf 

4、find / -name my.cnf | xargs rm -rf 

装新的

服务端：rpm -ivh ***rmp
客户端：rpm -ivh ***rmp

service mysql start
cat /root/.mysql_secret (默认密码)

 

修改密码

远程登陆授权

编码保存

修改表的字符编码

 

过程中出现的异常

[root@dream3 apps]# rpm -ivh MySQL-server-5.6.26-1.linux_glibc2.5.x86_64.rpm 
warning: MySQL-server-5.6.26-1.linux_glibc2.5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
        /usr/bin/perl is needed by MySQL-server-5.6.26-1.linux_glibc2.5.x86_64
        libaio.so.1()(64bit) is needed by MySQL-server-5.6.26-1.linux_glibc2.5.x86_64
        libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.26-1.linux_glibc2.5.x86_64
        libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.26-1.linux_glibc2.5.x86_64

 

少两个依赖 /usr/bin/perl   libaio

yum -y install perl.x86_64
yum install -y libaio.x86_64

修改字符集

默认的字符集是拉丁

修改utf-8

[root@dream3 apps]# find / -name my.cnf
/usr/my.cnf
[root@dream3 apps]# vi /usr/my.cnf

 

最后输入 character_set_server = utf8
修改完数据库字符集，需要重启mysql数据库。
查看数据库编码
show VARIABLES like 'character%';