在CentOS7环境下安装mysql

1. yum在线安装mysql依赖的组件

yum install perl gcc kernel-devel autoconf

2. 创建mysql用户

useradd mysql
passwd mysql

3.解压文件到/usr/local

tar -xvzf mysql.tar.gz /usr/local/mysql

4.修改mysql/权限为mysql用户

chown -R mysql:mysql /usr/local/mysql/

5.安装mysql

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

6.修改mysql/权限为root,data文件夹为mysql

chown -R root:root /usr/local/mysql/
chown -R mysql:mysql /usr/local/mysql/data

7.覆盖/etc/my.cnf

cp /usr/local/mysql/my.cnf /etc/my.cnf

8.修改my.cnf使mysql支持utf8编码集

修改/etc/my.cnf

[mysqld]
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci

9.修改profile使mysql命令可以直接调用

修改/etc/profile

PATH=/usr/local/mysql/bin:$PATH
export PATH

10.拷贝mysql.server到启动文件夹

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

11.设置mysql服务开机自启动

chkconfig --add mysql

12.进入mysql数据库,设置root用户密码为root

mysql
mysql>use mysql;
update user set password=PASSWORD('root') where USER='root';
mysql -u root -p
root

13.设置外部软件远程连接mysql的准备

1.关闭防火墙

systemctl stop firewalld.service
systemctl disable firewalld.service

2.进入mysql数据库修改权限

mysql> use mysql;
mysql> grant all privileges  on *.* to root@'%' identified by "root";

14.报错error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

解决方案:
yum install libaio-devel.x86_64

15.报错Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ mysql service

解决方案:
mysql服务未正确启动,尝试reboot,或者进入/usr/bin手动启动mysqld或mysqld_safe

16. 创建utf-8编码的数据库

CREATE DATABASE 数据库名 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;