centOS7卸载安装mysql56.docxVIP

centOS 7 卸载安装mysql5.6.272016-02-028:37?1、卸载mysql（1）查看安装的mysql#rpm -qa|grep -i mysql(2)卸载安装的mysql# yum remove mysql??(3)查看剩余的安装包# rpm -qa|grep -i mysql(4)删除安装包(对应上面查出来的包名)# yum remove mysql-community-release-el7-5.noarch# yum remove mysql-community-libs-5.6.27-2.el7.x86_64# yum remove mysql-community-common-5.6.27-2.el7.x86_64??（5）删除数据库文件以及配置文件 #rm –rf /etc/f #rm –rf /usr/share/mysql2、安装mysql5.6(1)下载mysql5.6安装文件在ie下登录地址http://ftp.kaist.ac.kr/mysql/Downloads/选择合适的版本进入目录选择合适的版本获取下载地址，本次下载5.6.27登录linux机器，进入到相应目录使用wget下载解压缩下载的tar文件，获取rpm文件(2)安装mysql服务端执行命令# rpm -ivh MySQL-server-5.6.27-1.el7.x86_64.rpm??(3)安装mysql库和头文件执行命令# rpm -ivh MySQL-devel-5.6.27-1.el7.x86_64.rpm?(4)安装mysql客户端执行命令rpm -ivh MySQL-client-5.6.27-1.el7.x86_64.rpm(5)修改root用户密码执行命令#service mysql start?执行命令#mysqld_safe --skip-grant-tables?新打开一个窗口执行命令#mysql执行命令#use mysql执行命令#update user set password=password(pension) where user=root;执行命令#flush privileges;执行命令#exit;新开窗口执行命令#ps -ef|grep mysql执行命令#kill -9 （mysqld_safe进程号）执行命令使用root用户登录#mysql -u root -p?登录成功后，使用一下命令进行修改root用户密码?#SET PASSWORD FOR root@localhost = PASSWORD(密码);?(6)设置数据库编码使用root用户执行以下命令#cd /etc#vi f?粘贴以下内容# For advice on how to change settings please see# /doc/refman/5.6/en/server-configuration-defaults.html?[mysqld]## Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M## Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin## Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2Mdatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockcharacter-set-server=utf8?# Disabling symbolic-links is recommended to prevent assorted secur