mysql
Spider.Li
满目山河空念远,不如怜取眼前人
展开
-
django远程链接服务器的mysql,报(1130, “Host ‘*.*.*.*‘ is not allowed to connect to this MySQL server“)
1、使用命令行,登录mysqlmysql -u root -p2、使用mysql数据库,获取当前hostuse mysql;select host from user where user=‘root’;3、将Host设置为通配符%。update user set host = ‘%’ where user =‘root’;4、权限刷新。flush privileges;5、重新执行python manage.py runserver 0.0.0.0:8000...原创 2022-07-07 10:17:21 · 597 阅读 · 1 评论 -
SpringBoot 报错:ERROR 10224 --- [ restartedMain] o.a.tomcat.jdbc.pool.ConnectionPool 已解决
1、将mysql依赖改成本地版本 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.19</version> </dependency>2、properties文件datase配置spring.datasource.driver-class-nam原创 2022-02-25 16:22:11 · 961 阅读 · 0 评论 -
给数据库增加连接权限
grant all on . to “root”@“192.168.8.%” IDENTIFIED by ‘123456’;flush PRIVILEGES;原创 2020-06-16 20:01:21 · 855 阅读 · 0 评论