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;