google cloud下ubuntu18.04 mysql57 spring boot的配置踩坑
使用mobaxterm ssh连接服务器省略
#apt安装mysql,google cloud下默认5.7
sudo apt-get install mysql-server
#设置初始化,密码,privilege
sudo mysql_secure_installation
#完成后,以root身份进入mysql shell
mysql -u root -p
以下为mysql shell内的操作
USE MYSQL;
CREATE USER 'name'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'name'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;
'%'表示可远程访问,'exit;'退出mysql
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
修改’bind-address = 127.0.0.1’为’#bind-address = 127.0.0.1’
service mysql restart
重启mysql,即可在本地使用更为便利的datagrip连接远程输入console
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'spring'@'localhost' IDENTIFIED BY '1122';
GRANT ALL PRIVILEGES ON db_name.* TO spring@"%" IDENTIFIED BY "1122";
创建一个utf8字符集的database,防止插入中文变为问号
创建一个名为spring密码为1122的本地账户,方便spring boot部署连接
spring:
datasource:
url: jdbc:mysql://localhost:3306/blog?serverTimezone=UTC
password: 1122
username: spring
driver-class-name: com.mysql.cj.jdbc.Driver
将jar包导入服务器
nohup java -jar xx.jar &
后台spring boot mysql部署成功