MYsql的安装
1. 下载bundles 包
https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar
2. 上传服务器,解压缩该包
tar -xvf mysql-8.0.-.el7.x86_64.rpm-bundle.tar
3.cd 到当前目录, 安装所有的 rpm包
rpm -ivh *.rpm -f --nodeps
4. 启动mysqld
systemctl enable mysqld
systemctl start mysqld
5.查看mysqld的初始密码
vim /var/log/mysqld.log
6. 登录mysql
mysql -u root -p
输入密码
7. 修改localhost下的 root的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test6530!'
8. 修改所有人可以root访问该数据库
mysql -u root -p use mysql
update user set host = '%' where user = 'root';
flush privileges;
9. 修改 navicat能够远程访问该数据库
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Test6530!'; flush privileges;
必须得有这个才可以,如图
sonarqube的安装 下面暂时未验证完
1. 下载sonarqube
https://www.sonarqube.org/downloads/
https://download.csdn.net/download/u010218242/9272667 #汉化
2. 创建数据库
CREATE DATABASE sonar CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE USER sonar IDENTIFIED BY "Test6530!"; GRANT ALL ON sonar.* TO 'sonar'@'%' ;
ALTER USER 'sonar'@'%' IDENTIFIED WITH mysql_native_password BY 'Test6530!';
FLUSH PRIVILEGES;
https://blog.csdn.net/sinat_34017357/article/details/51719907 但是后续操作失败了.