【MySQL】创建数据库、用户和密码

创建数据库、用户和密码参考sql语句

drop database if exists demoshop;
drop user if exists 'demoshop'@'%';
-- 支持emoji：需要mysql数据库参数： character_set_server=utf8mb4
create database demoshop default character set utf8mb4 collate utf8mb4_unicode_ci;
use demoshop;
create user 'demoshop'@'%' identified by 'demoshop123456';
grant all privileges on demoshop.* to 'demoshop'@'%';
flush privileges;

springboot框架MySQL连接application.yml配置

spring:
  profiles:
    #  配置的环境
    #    active: #spring.profiles.active#
    active:
  servlet:
    multipart:
      max-file-size: 50MB #设置单个文件大小
      max-request-size: 50MB #设置单次请求文件的总大小
  jackson:
    locale: zh_CN
    time-zone: GMT+8
    date-format: yyyy-MM-dd HH:mm:ss
  #  数据库配置
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimeZone=GMT+8
    username: root
    password: root