链接数据库报1146
解决办法: 进入mysql bin目录下执行 mysql_upgrade -u root -p --force
linux部署springboot项目 table “*. qrtz_locks” doesn’t exist
解决办法:
vi /etc/my.cnf
在 [mysqld] 节中添加:
lower_case_table_names=1
然后重启MySQL:
service mysqld restart
报错:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘paodekuai’@’%’ to database ‘spider-flow’
mysql -u root -p
GRANT ALL on test.* to ‘test’@’%’ identified by ‘123456’ with grant option;
FLUSH PRIVILEGES;
mysql出现 ava.sql.SQLException: Table ‘.\mysql\proc’ is marked as crashed and should be repaired
在Mysql命令行中输入 repair table mysql.proc; 修复该表,完美解决问题。
linux防火墙关闭了启动不了
先解锁 命令 systemctl unmask firewalld,然后在执行启动命令 systemctl start firewalld
2.防火墙开放端口: firewall-cmd --zone=public --add-port=8888/tcp --permanent
3.linux部署jar包
nohup java -jar xxx.jar >xxx.txt &
4.linux 查看进程号
ps -ef |grep java
5.杀死进程
kill -9 进程号
部署阿里云ssl
ssl:
key-store: classpath:niutj.com.pfx
key-store-password: wMb3fL5d
keyStoreType: PKCS12
加粗样式