一、查看是否安装mysql数据库
[root@localhost etc]# rpm -qa | grep mysql
二、卸载原有的版本
[root@localhost etc]# rpm -e mysql-libs-5.1.71-1.el6.x86_64 --nodeps//此处为强行卸载注意后边的--nodeps
三、进入安装目录,并创建mysql文件夹,用来存放解压的tar包
[root@localhost etc]# cd /opt/software/
[root@localhost software]# mkdir mysql
四、解tar
[root@localhost software]# tar -xvf MySQL-5.5.53-1.linux2.6.x86_64.rpm-bundle.tar -C /opt/software/mysql
MySQL-devel-5.5.53-1.linux2.6.x86_64.rpm
MySQL-test-5.5.53-1.linux2.6.x86_64.rpm
MySQL-server-5.5.53-1.linux2.6.x86_64.rpm
MySQL-client-5.5.53-1.linux2.6.x86_64.rpm
MySQL-embedded-5.5.53-1.linux2.6.x86_64.rpm
MySQL-shared-compat-5.5.53-1.linux2.6.x86_64.rpm
MySQL-shared-5.5.53-1.linux2.6.x86_64.rpm(解tar完成)
五、安装mysql
1、安装MySQL-server-5.5.53-1.linux2.6.x86_64.rpm
[root@localhost software]# rpm -ivh /opt/software/mysql/MySQL-server-5.5.53-1.linux2.6.x86_64.rpm
2、安装MySQL-client-5.5.53-1.linux2.6.x86_64.rpm
rpm -ivh /opt/software/mysql/MySQL-client-5.5.53-1.linux2.6.x86_64.rpm
3、查看mysql服务是否开启,没有的话开启服务
[root@localhost software]# ps -ef|grep mysql
六、修改root用户密码
[root@localhost ~]# mysqladmin -u root -p password
Enter password:
New password:
Confirm new password:
七、查看musql字符编码
mysql> show variables like 'chara%';
八、修改mysql字符编码级别
1进入配置文件位置
[root@localhost mysql]# cd /usr/share/mysql
2、修改配置文件
[root@localhost mysql]# cp my-small.cnf /etc/my.cnf
[root@localhost mysql]# vi /etc/my.cnf
[character_set_server = utf8
3、保存退出
4、重启mysql服务查看字符集编码’