龚帅立135264646456
Centos7.2离线安装mysql8.0.19
安装包下载sql/downloads/mysql/
安装新版mysql前，需将系统自带的mariadb-lib卸载
1[root@hadoop ~]# rpm ‐qa|grep mariadb
2mariadb‐libs‐5.5.52‐1.el7.x86_64
3[root@localhost ~]# rpm ‐e ‐‐nodeps mariadb‐libs‐5.5.52‐1.el7.x86_64
4[root@localhost ~]# rpm ‐qa|grep mariadb
或者使用shell> rpm ­qa | grep mariadb | grep ­v grep |awk '{print $mariadb}'| xargs rpm ­e ­­nodeps
1.下载mysql
[root@localhost opt]# wget sql//Downloads/MySQL-8.0/mysql-8.0.19-el7-x86_
2. 将Mysql安装包解压到到系统目录的本地软件目录/usr/local/，命令如下：
[root@localhost opt]# tar -zxvf mysql-8.0.19-el7-x86_  -C /usr/local/
3.进入安装mysql软件的目录，命令如下：
[root@localhost local]# cd /usr/local/
4.为mysql安装目录创建软链接:
[root@localhost local]# ln -s mysql-8.0.19-el7-x86_64 mysql
[root@localhost mysql] # cd mysql
[root@localhost mysql] # mkdir data
mysql下载libs包的网址[root@localhost mysql]# mkdir log
[root@localhost mysql]# touch mysql.log
5.添加mysql用户组
[root@localhost local]# groupadd mysql
[root@localhost local]# useradd -r -g mysql mysql
6.更改所属的组和用户为新建的mysql用户：
[root@localhost local]# chown -R mysql:mysql mysql*
7.在etc下新建配置文件myf，并在该文件内添加以下配置
1 [mysql]
2 # 设置mysql客户端默认字符集
3 default‐character‐set=utf8
4
5 [mysqld]
6 user = mysql
7 port = 3306
8 basedir = /usr/local/mysql
9 datadir = /usr/local/mysql/data
10 pid‐file = /usr/local/mysql/mysql.pid
11socket = /tmp/mysql.sock
12log‐error=/usr/local/mysql/log/mysql.log
13character‐set‐server=utf8
14max_connections=1000
15default‐storage‐engine=INNODB
16lower_case_table_names=1
17max_allowed_packet=16M
18[mysqld_safe]
19log‐error=/usr/local/mysql/log/mysql.log
20pid‐file=/usr/local/mysql/mysql.pid
21
22[client]
23default‐character‐set=utf8
24socket = /tmp/mysql.sock
8.安装数据库，生成初始密码
[root@localhost mysql]# bin/mysqld  --initialize --user=mysql --
basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
[root@gong ~]# grep "password is generated" /usr/local/mysql/log/mysql.log | awk '{print $NF}'
[root@localhost mysql]# ./bin/mysqld_safe --user=mysql &
[root@localhost mysql]# cd support-files/
[root@localhost support-files]# ./mysql.server start
9.命令做软链到系统文件下
[root@localhost bin]# ln -fs /usr/local/mysql/bin/mysqldump /usr/bin [root@localhost bin]# ln -fs /usr/local/mysql/bin/mysql /usr/bin 10.更改默认账号密码
[root@localhost bin]# mysql -uroot -p
mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
将服务文件拷贝到init.d下，并重命名为mysql
10.启动停止命令
(1)创建启动文件 .service
vim /usr/lib/systemd/system/mysql.service
[Unit]
Description=MySQL Server
After=network.target
After=syslog.target
[Service]
User=mysql
Group=mysql
Type=forking
PermissionsStartOnly=true
ExecStart= /usr/local/mysql/support-files/mysql.server start ExecStop= /usr/local/mysql/support-files/mysql.server stop ExecReload= /usr/local/mysql/support-files/mysql.server restart LimitNOFILE = 5000
[Install]
WantedBy=multi-user.target
(2)重新加载一下服务的配置文件
systemctl daemon-reload
(3)开启mysql服务
systemctl  start  mysql.service
(4)关闭mysql服务
systemctl  stop  mysql.service
11.允许root用户在任何地方进行远程登录，并具有所有库任何操作权限：
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
mysql> use mysql;
mysql> update user set host='%' where user='root';
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。