在路径/usr/local/下新建mysql文件夹
mkdir mysql
然后通过ftp进行mysql压缩包的上传
进行解压:
tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
对mysql文件夹重新命名
mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql-5.7.26
检查mysql组和用户是否存在,如果没有则创建
cat /etc/group|grep mysqlgroupadd mysqluseradd -r -g mysql mysql #useradd -r参数表示mysql用户是系统用户,不可用于登录系统
创建data目录
cd /mysql-5.7.26mkdir data
将/usr/local/mysql/mysql-5.7.26的所有者及所属组改为mysql
chown -R mysql.mysql /usr/local/mysql/mysql-5.7.26
配置my.cnf
vi /etc/my.cnf
[mysqld]bind-address=0.0.0.0port=3306user=mysqlbasedir=/usr/local/mysql/mysql-5.7.26datadir=/usr/local/mysql/mysql-5.7.26/datasocket=/tmp/mysql.socklog-error=/usr/local/mysql/mysql-5.7.26/data/mysqld.logpid-file=/usr/local/mysql/mysql-5.7.26/data/mysqld.pidcharacter_set_server=utf8# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0explicit_defaults_for_timestamp=true# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd [mysqld_safe]## include all files from the config directory#!includedir /etc/my.cnf.d ~ ~ ~ ~ ~ ~ ~ ~
初始化MySQL
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-5.7.26/ --datadir=/usr/local/mysql/mysql-5.7.26/data/
如果报错:./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or 就安装libaio
yum install libaio
查看临时密码:
cat /usr/local/mysql/mysql-5.7.26/data/mysqld.log
把启动脚本放到开机初始化目录
cp support-files/mysql.server /etc/init.d/mysql
启动mysql
service mysql start
更改密码
进入
cd /usr/local/mysql/mysql-5.7.26
输入命令:
./bin/mysql -u root -p
输入刚才的密码
输入SQL:
mysql> SET PASSWORD = PASSWORD('admin');ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;FLUSH PRIVILEGES;
添加远程访问权限:
use mysqlupdate user set host = '%' where user = 'root';FLUSH PRIVILEGES;
输入quit或者exit即可退出mysql
重启使之生效
service mysql restart
查看mysql运行:
ps -ef|grep mysql
添加需要监听的端口:
/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
链接测试:
.
进行虚拟机重新启动:
以下进行加入服务
1、将服务文件拷贝到init.d下,并重命名为mysql
cp /usr/local/mysql/mysql-5.7.26/support-files/mysql.server /etc/init.d/mysqld
2、赋予可执行权限
chmod +x /etc/init.d/mysqld
3、添加服务
chkconfig --add mysqld
4、显示服务列表
chkconfig --list
如果看到mysql的服务,并且3,4,5都是开的话则成功,如果是关,则键入
chkconfig --level 345 mysqld on
5、重启电脑
reboot