【在下菜鸟一枚,根据自己的安装操作,整理了一份安装步骤。还请各位在线的高手大神们不吝指教~~~】
一、安装包获取方式
1.1、在线版安装
下载tar包,这里使用wget从官网下载
#wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.27 -linux-glibc2.12-x86_64.tar.gz
1.2、离线版安装
通过Xftp 工具,将安装包直接上传到服务器某个目录下
二、安装步骤
2.1、将mysql安装到/usr/local/mysql下
#解压 tar -xvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
看到如下图就是正常的。
#移动 mv mysql-5.7.27-linux-glibc2.12-x86_64 /usr/local/
#重命名mv /usr/local/mysql-5.7.27-linux-glibc2.12-x86_64 /usr/local/mysql
2.2、新建data目录
例如当前目录是usr
在usr目录下创建目录
[root~usr]#mkdir data
2.3、新建mysql用户、mysql用户组
新建mysql用户如下:
#groupadd mysql
新建mysql用户组如下:
#useradd mysql -g mysql
2.4、将/usr/local/mysql的所有者及所属组改成mysql
chown -R mysql.mysql /usr/local/mysql
[注意:R一定要大写]
2.5、配置
/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
执行完成之后,结果如下图:
表示正常安装!
①如果出现以下错误:
则使用以下命令:
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize
②如果出现以下错误:
/usr/local/mysql/bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory
则执行以下命令:
yum -y install numactl
③如果出现以下错误:
/usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
则执行以下命令:
yum install libaio-devel.x86_64
完成后继续安装:
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize
2.6、编辑配置文件
vim /etc/my.cnf
把下面配置覆盖
[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
lower_case_table_names=1
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
#取消密码验证
skip-grant-tables
#Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#skip-grant-tables
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
2.7、开启服务
将mysql加入服务
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
开机自启chkconfig mysql on
开启service mysql start
2.8、设置密码
#登录(由于/etc/my.cnf中设置了取消密码验证,所以此处密码任意)
/usr/local/mysql/bin/mysql -u root -p
#操作mysql数据库
#use mysql;
#修改密码
#update user set authentication_string=password(‘你的密码’) where user=‘root’;
update user set authentication_string=password(‘123qwe!@#’) where user=‘root’;
#lush privileges;
#exit;
将/etc/my.cnf中的skip-grant-tables删除
2.9、再次设置密码(不知道为什么如果不再次设置密码就操作不了数据库了)
/usr/local/mysql/bin/mysql -u root -p
#ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘修改后的密码’;
#exit;
2.10、允许远程连接
/usr/local/mysql/bin/mysql -u root -p
#use mysql;
#update user set host=’%’ where user = ‘root’;
#flush privileges;
#ext;