解决Jira安装提示：MySQL 8实例未适当配置的问题

文章目录

1、下载mysql软件包
2、解压缩包
3、移动MySQL文件
4、添加用户和用户组
5、创建/data/mysql目录
6、创建/etc/my.cnf文件
7、安装libaio
8、初始化mysql
9、查看数据库密码
10、重命名mysql.server并移动到/etc/init.d/目录
11、启动mysql
12、登录数据库
13、关闭mysql
14、忘记密码怎么办
15、一台linux服务器上安装多个MySQL实例
16、慢查询日志
18、字符集设置
18、用户管理
19、mysql的rpm包安装
20、mysql的yum安装
21、 mysql的deb包安装

1、下载mysql软件包

mysql下载下载mysql压缩包,上传到/usrlocal/src/目录下

jira 安装提示此 MySQL 实例没有适当配置 jira mysql8_linux

2、解压缩包

使用命令tar -xvf mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz解压缩包

3、移动MySQL文件

将解压后的文件重命名为mysql,并且移动到/usr/local目录下

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

mv mysql …/

[root@localhost src]# mv mysql-8.0.16-linux-glibc2.12-x86_64 mysql
[root@localhost src]# ls
mysql  mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz
[root@localhost src]# mv mysql ../
[root@localhost src]# cd ../
[root@localhost local]# ls
bin  etc  games  include  lib  lib64  libexec  mysql  sbin  share  src
[root@localhost local]#

4、添加用户和用户组

添加mysql用户和用户组:useradd mysql

[root@localhost local]# useradd mysql
[root@localhost local]# id mysql
uid=1001(mysql) gid=1001(mysql) groups=1001(mysql)
[root@localhost local]#

5、创建/data/mysql目录

使用mkdir -p /data/mysql命令创建mysql目录,并且将修改权限：chown mysql:mysql -R /data/mysql

[root@localhost local]# useradd mysql
[root@localhost local]# id mysql
uid=1001(mysql) gid=1001(mysql) groups=1001(mysql)
[root@localhost local]# mkdir -p /data/mysql
[root@localhost local]# cd /
[root@localhost /]# ls
bin  boot  data  dev  etc  home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  tmp  usr  var
[root@localhost /]# chown mysql:mysql -R /data/mysql
[root@localhost /]# ls -la
total 28
dr-xr-xr-x.  18 root root  236 Sep 21 11:23 .
dr-xr-xr-x.  18 root root  236 Sep 21 11:23 ..
lrwxrwxrwx.   1 root root    7 Nov  3  2020 bin -> usr/bin
dr-xr-xr-x.   5 root root 4096 Feb  8  2021 boot
drwxr-xr-x.   3 root root   19 Sep 21 11:23 data
drwxr-xr-x.  20 root root 3200 Sep 21 11:09 dev
drwxr-xr-x. 141 root root 8192 Sep 21 11:22 etc
drwxr-xr-x.   4 root root   31 Sep 21 11:22 home
lrwxrwxrwx.   1 root root    7 Nov  3  2020 lib -> usr/lib
lrwxrwxrwx.   1 root root    9 Nov  3  2020 lib64 -> usr/lib64
drwxr-xr-x.   2 root root    6 Nov  3  2020 media
drwxr-xr-x.   3 root root   18 Nov  3  2020 mnt
drwxr-xr-x.   2 root root    6 Nov  3  2020 opt
dr-xr-xr-x. 362 root root    0 Sep 21 11:09 proc
dr-xr-x---.  16 root root 4096 Sep 21 11:10 root
drwxr-xr-x.  43 root root 1240 Sep 21 11:12 run
lrwxrwxrwx.   1 root root    8 Nov  3  2020 sbin -> usr/sbin
drwxr-xr-x.   2 root root    6 Nov  3  2020 srv
dr-xr-xr-x.  13 root root    0 Sep 21 11:09 sys
drwxrwxrwt.  14 root root 4096 Sep 21 11:19 tmp
drwxr-xr-x.  12 root root  144 Feb  8  2021 usr
drwxr-xr-x.  21 root root 4096 Feb  8  2021 var
[root@localhost /]# cd data
[root@localhost data]# ls -la
total 0
drwxr-xr-x.  3 root  root   19 Sep 21 11:23 .
dr-xr-xr-x. 18 root  root  236 Sep 21 11:23 ..
drwxr-xr-x.  2 mysql mysql   6 Sep 21 11:23 mysql
[root@localhost data]#

6、创建/etc/my.cnf文件

创建/etc/my.cnf文件，并添加下面内容
[mysqld]
bind-address=0.0.0.0      //绑定到指定的ip上
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8
#symbolic-links=0
#explicit_defaults_for_timestamp=true

7、安装libaio

执行yum install -y libaio命令安装libaio包

8、初始化mysql

进入/usr/local/mysql/bin目录，初始化mysql

初始化命令如下：
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize

9、查看数据库密码

查看数据库首次登录密码：cat /data/mysql/mysql.err
[root@localhost bin]# cat /data/mysql/mysql.err
2021-09-21T15:32:28.547395Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.16) initializing of server in progress as process 43232
2021-09-21T15:32:35.938131Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: RYIwftw4FL?a
2021-09-21T15:32:37.923324Z 0 [System] [MY-013170] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.16) initializing of server has completed