google cloud下ubuntu18.04 mysql57 spring boot的配置踩坑

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部署成功