虚拟机进入mysql_Linux中安装mysql,详细步骤。请参考

c8313d7c10f0b658730b8721f5522b03.png

在路径/usr/local/下新建mysql文件夹

mkdir mysql

然后通过ftp进行mysql压缩包的上传

3461834029281a79bd1323807d474169.png

ff493636c238f82f05364234842e736b.png

进行解压:

tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

df008fad1a3d2faf142348c01f7e5338.png

10734d9c13713db80bfe7b9fb48f375b.png

对mysql文件夹重新命名

 mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql-5.7.26

0aa7e814bbb74f6fcf687285e12043f3.png

 检查mysql组和用户是否存在,如果没有则创建


cat /etc/group|grep mysqlgroupadd mysqluseradd -r -g mysql mysql  #useradd -r参数表示mysql用户是系统用户,不可用于登录系统

c97bfe0ee03cc6f9097c1f053c9d47e3.png

创建data目录

cd /mysql-5.7.26mkdir data

c9431a25544b96ccaf66d31d5799a94f.png

 将/usr/local/mysql/mysql-5.7.26的所有者及所属组改为mysql

chown -R mysql.mysql /usr/local/mysql/mysql-5.7.26

8c6a973f007e547778a3d99372975610.png

配置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 ~                                                                                                                                                ~                                                                                                                                                ~                                                                                                                                                ~                                                                                                                                                ~                                                                                                                                                ~                                                                                                                                                ~                                                                                                                                                ~        

d4738bc435ac40a3f19132bb5b8a40fe.png

初始化MySQL

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-5.7.26/ --datadir=/usr/local/mysql/mysql-5.7.26/data/

986068d76130a9ae75e063a00cd74369.png

 如果报错:./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

8ee9418233b4f4fba2d003a55c918636.png

把启动脚本放到开机初始化目录

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

f33242ebd4af350fc08e977addbb9b75.png

 启动mysql

service mysql start

ef956434e4738fd9a1e2c9fa62d3b0ce.png

facdd7bb2c67ac2a5203b5444fc44c48.png

更改密码

进入

cd /usr/local/mysql/mysql-5.7.26

输入命令:

./bin/mysql -u root -p

输入刚才的密码

ad89a9db73dda8befdc6f437994a8243.png

5f861b9ad3b66eed478f7d5ccd62a9e4.png

输入SQL:

mysql> SET PASSWORD = PASSWORD('admin');ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;FLUSH PRIVILEGES;

e52d0ed98e194980738ef5c2a3c4c55d.png

添加远程访问权限:

use mysqlupdate user set host = '%' where user = 'root';FLUSH PRIVILEGES;

5e64833125daa0c8659bf7c4e7ca0b48.png

输入quit或者exit即可退出mysql

2ad8586e7596fee742c809fe305fdcfd.png

重启使之生效

service mysql restart

12cd5e70c65483d51aed7f1c88632341.png

查看mysql运行:

ps -ef|grep mysql

5a7c93f755d77719126971ad6b4986b0.png

添加需要监听的端口:

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

8933ddd4673ab1c46a5e9cb71c6dedbf.png

链接测试:

91bc83b1d0a92e46ba9126c1d9662590.png.

进行虚拟机重新启动:

d58dc05fdc9b20c578300930e321a7fc.png

841efe4e46789cfe4df74630e591037f.png

以下进行加入服务

052431767b089c807be3208e72b43aa4.png

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

02289b8c7aab672586412f713cb87781.png

如果看到mysql的服务,并且3,4,5都是开的话则成功,如果是关,则键入

chkconfig --level 345 mysqld on

5、重启电脑

reboot

c4514ffcb5e85b473a148ecbbc3a5861.png

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值