centOS7.6下安装mysql8

# centOS7.6下安装mysql
# 在/usr/local 下建立mysql文件夹


rpm -qa | grep mariadb               # 查看是否安装mariadb包

rpm -e XXXXXX --nodeps               # 通过该命令卸载mariadb包

cd /usr/local/mysql                  # 进入mysql安装目录

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar        # 下载mysql8.0.16


tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar        # 解压到当前目录

rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm --nodeps --force      # 安装common

rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm --nodeps --force       # 安装libs

rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm --nodeps --force      # 安装client

rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm --nodeps --force      #安装server

rpm -qa | grep mysql             # 查看已经安装的mysql安装包


# 初始化mysql
mysqld --initialize;
chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl enable mysqld;

cat /var/log/mysqld.log | grep password        # 查看初始密码

mysql -u root -p         # 使用初始密码登录mysql

ALTER USER 'NAME'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PSW';        # 登录后执行该命令，修改密码，重新登录


# 创建远程访问帐号
create user 'NAME'@'%' identified with mysql_native_password by 'PWD';
grant all privileges on *.* to 'NAME'@'%' with grant option;
flush privileges;

create user 'saas'@'%' identified with mysql_native_password by 'saas@175';
grant all privileges on *.* to 'saas'@'%' with grant option;
grant create user on *.* to saas;
grant GRANT OPTION on *.* to saas; 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

create user 'crawler'@'%' identified with mysql_native_password by 'crawler@mysql';
CREATE DATABASE IF NOT EXISTS db_crawler DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
grant all privileges on db_crawler.* to 'crawler'@'%' with grant option;

修改vim /etc/mysql/mysql.conf.d/mysql 的bind_address=0.0.0.0，否则不能在外部访问到mysql。

ubuntu20.04使用apt-get install mysql-server安装mysql8.0，其他版本不能安装成功。

service mysql restart

ubuntu20.04     apt-get install openjdk-8-jdk安装jdk8

参照：163邮箱获取授权码过程参照：

https://jingyan.baidu.com/article/c275f6ba33a95de33d7567d9.html

如何解决dolphin安装过程中的ubuntu系统下source: not found错误？

出现source: not found错误，原因可能是shell的解释器不是bash，需把shell的解释器更改为bash。
解决：
执行ls -l /bin/sh命令，若得到结果/bin/sh -> dash，则说明shell的解释器为dash。执行dpkg-reconfigure dash命令，然后选择no。
注意此步骤需要root权限。
再次执行ls -l /bin/sh命令，若得到结果/bin/sh -> bash，则说明成功更改shell的解释器为bash。

需要设置数据库类型，初始化数据库，

sh script/create-dolphinscheduler.sh

参加：

pseudo-cluster