一、检查系统是否安装其他版本的MYSQL数据
yum list installed | grep mysql
yum -y remove mysql-libs.x86_64 (上条命令列出的项)
二、下载rpm并安装
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
rpm -ivh mysql-community-release-el6-5.noarch.rpm
yum install mysql-server -y
三、查看是否安装成功
rpm -qa grep | mysql
四、常用的命令
systemctl start mysqld.service #启动 mysql
systemctl restart mysqld.service #重启 mysql
systemctl stop mysqld.service #停止 mysql
systemctl enable mysqld.service #设置 mysql 开机启动
systemctl status mysqld.service #查看mysql状态
五、设置root密码以及其他设置
mysql_secure_installation (进入root密码设置以及其他相关设置操作,按照步骤一步步来。)
六、设置utf-8编码
mysql -uroot -p
mysql> show variables like 'character%';
结果出现如下:
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
如果不是utf8格式则按如下方式修改。
修改my.cnf文件
vim /etc/my.cnf
添加如下配置信息:
[mysqld]
character-set-server=utf8
[mysql.server]
default-character-set = utf8