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%';