数据库MySQL重装之MySQL-8.0.12-winx64
1、安装方式:压缩包安装
资源:
2、随笔:(待完善)
高版本MySQL:mysql-8.0.12-winx64
数据库启动:
net start mysql
mysql -h localhost -u root -p
密码:
111111
修改密码:
alter user user() identified by "123456";
退出:
quit;
连接navicat:
1、在bin目录下:cmd
G:\MySQL\mysql-8.0.12-winx64\bin>
mysqladmin -u root -p password 123456
2、密码:
Enter password:
123456
3、登录:
G:\MySQL\mysql-8.0.12-winx64\bin>
mysql -u root -p
密码:
Enter password:
123456
4、设置连接密码:
mysql>
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
5、刷新权限:
mysql> flush privileges;
数据库连接OK!啦
项目中数据库配置:
pom.xml中的坐标依赖:
<!-- mysql 驱动包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
jdbc.properties配置文件中:
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/p2p?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8
jdbc.user=root
jdbc.password=123456