centos下安装mysql5.5

来源：互联网发布：excel单元格数据的分列编辑：程序博客网时间：2024/06/04 23:31

一、查看是否安装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服务查看字符集编码’

0 0