![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
狐有影
人可以不努力但不能不学习
展开
-
2003-Can‘t connect to MySQL server on ‘192.168.232.128(10060 “Unknown error“)
MySQL远程连接报错2003-cant connection to mysql server on ‘IP’(10061 unknown error)的解决。原创 2023-02-21 12:07:59 · 2434 阅读 · 0 评论 -
mysql8.0数据库连接配置
mysql8.0数据库连接配置。原创 2022-07-27 12:49:12 · 2204 阅读 · 0 评论 -
java在使用jdbc导入数据库时出现中文乱码解决方法
数据库:Mysql解决方法在url后面加上原创 2022-06-28 15:51:59 · 276 阅读 · 0 评论 -
德鲁伊连接池
<!-- 数据库连接池 --><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close"> <property name="url" value="jdbc:mysql:///user_db" /> <property name="username" value="root" /> <property name="pass原创 2021-11-10 19:07:29 · 567 阅读 · 0 评论 -
Mysql插入中文时错误:ERROR 1366 (HY000): Incorrect string value: ‘\xE6\x9D\x8E\xE5\x8B\x87‘ for column
SHOW CREATE TABLE t_book;ALTER TABLE t_book DEFAULT CHARACTER SET utf8;ALTER TABLE t_book CHANGE name name VARCHAR(200) CHARACTER SET utf8;ALTER TABLE t_book CHANGE author author VARCHAR(200) CHARACTER SET utf8;注释:t_book是表,name ,author是属性...原创 2021-10-26 23:29:39 · 1147 阅读 · 0 评论 -
Mysql8.0后面使用函数出现下面异常
Mysql8.0后面使用函数出现下面异常ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)需要设置 SET GLOBAL log_原创 2021-09-11 11:37:50 · 130 阅读 · 0 评论