文章目录
- 01 | 常用命令
- 02 | 常见错误
- 1. The server time zone value '?????????±?????????±???¤' is
- 2. java.sql.SQLException: Unknown system variable ‘tx_isolation’
- 3. Mysql报错1293 Incorrect table definition. there can be only one timestamp column with current_timestam
- 4. [Warning] Can‘t create test file F:\nochnos\mysql-5.5.16-win32\data\LAPTOP-4I8ANT0J.
- 5. The server time zone value is unrecognized or represents more than one time
01 | 常用命令
1. MySQL登录
mysql -h localhost -P 3307 -uroot -p
2. 查看MySQL端口号
show global variables like 'port';
3. 查看mysql安装路径
show variables like "%char%";
4. 开启、关闭mysql服务
net start mysql
net stop mysql
02 | 常见错误
1. The server time zone value ‘???±???±???¤’ is
- 添加
serverTimezone=UTC
将 jdbc.url=jdbc:mysql://localhost:3307/tmall_ssm?useUnicode=true&characterEncoding=utf8 改为 jdbc.url=jdbc:mysql://localhost:3307/tmall_ssm?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
2. java.sql.SQLException: Unknown system variable ‘tx_isolation’
- 我遇到的问题是
mysql
版本不对的问题,只需找到pom.xml
中mysql
依赖的语句,将版本改为自己所需的版本即可。<mysql.version>8.0.20</mysql.version>
3. Mysql报错1293 Incorrect table definition. there can be only one timestamp column with current_timestam
- 资源指路:解决方法
4. [Warning] Can‘t create test file F:\nochnos\mysql-5.5.16-win32\data\LAPTOP-4I8ANT0J.
- 资源指路: 解决方法
5. The server time zone value is unrecognized or represents more than one time
- 资源指路: 解决方法