mysql5.7如何关闭ssl?

使用官方yum源安装,由于mysql5.7默认开启了ssl,安装在centos系统中,远程可以通过windows的navicat连接,但是通过另一台centos系统的mysql -u root -p -h ip地址连接时,则提示:ERROR 2003 (HY000): Can't connect to MySQL server on 'IP地址' (113)(113)。所以想请教,5.7这个版本如何将ssl关闭。

1个回答

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
mysql5.7版本中如何禁止掉SSL功能,默认是开启的
哪位大神知道怎么关闭mysql的SSL功能,现在在5.7版本里面默认是开启的
在Win10系统下怎样才能正确配置MySQL5.7.20的SSL连接?
各位大佬,小弟现在遇到的问题是: 在win10系统中,为了数据库的安全,我需要配置MySQL的SSL连接,但是一直配置不成功, 所以想请教各位大佬,我该怎么样才能配置成功,谢谢!![图片说明](https://img-ask.csdn.net/upload/201711/20/1511143913_279675.png)
php7 mysql5.7 打架啦
问题是这样的,全新Ubuntu14.04 (aliyun)里安装了mysql 5.7.13 ![Mysql版本信息](https://img-ask.csdn.net/upload/201607/20/1468974692_51088.png) 然后下载编译的PHP7 ./configure 的参数为 --enable-ftp --enable-fpm --with-pdo-mysql=/usr/bin/mysql 提示成功生成Makefile。 继续make时则出现以下错误 ``` ext/pdo_mysql/.libs/pdo_mysql.o: In function `zm_info_pdo_mysql': /root/a/php-7.0.8/ext/pdo_mysql/pdo_mysql.c:162: undefined reference to `mysql_get_client_info' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_check_liveness': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:493: undefined reference to `mysql_ping' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_last_insert_id': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:292: undefined reference to `mysql_insert_id' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_rollback': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:343: undefined reference to `mysql_rollback' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_commit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:330: undefined reference to `mysql_commit' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_quoter': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:307: undefined reference to `mysql_real_escape_string' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_closer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:149: undefined reference to `mysql_close' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_autocommit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:357: undefined reference to `mysql_autocommit' ext/pdo_mysql/.libs/mysql_driver.o: In function `_pdo_mysql_error': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:65: undefined reference to `mysql_stmt_errno' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:93: undefined reference to `mysql_error' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:101: undefined reference to `mysql_stmt_sqlstate' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:67: undefined reference to `mysql_errno' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:103: undefined reference to `mysql_sqlstate' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:93: undefined reference to `mysql_error' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_handle_factory': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:585: undefined reference to `mysql_init' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:627: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:660: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:690: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:703: undefined reference to `mysql_ssl_set' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:730: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:742: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:775: undefined reference to `mysql_real_connect' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:670: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:680: undefined reference to `mysql_options' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_autocommit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:357: undefined reference to `mysql_autocommit' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_handle_factory': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:703: undefined reference to `mysql_ssl_set' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_get_attribute': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:444: undefined reference to `mysql_stat' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:426: undefined reference to `mysql_get_client_info' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:430: undefined reference to `mysql_get_server_info' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:434: undefined reference to `mysql_get_host_info' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_doer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:261: undefined reference to `mysql_real_query' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:265: undefined reference to `mysql_affected_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:274: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:277: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:273: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:279: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_preparer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:183: undefined reference to `mysql_get_server_version' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:200: undefined reference to `mysql_stmt_init' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:208: undefined reference to `mysql_stmt_prepare' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:227: undefined reference to `mysql_stmt_param_count' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:211: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_cursor_closer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:902: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:907: undefined reference to `mysql_stmt_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:913: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:916: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:911: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:918: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_fill_stmt_from_result': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:135: undefined reference to `mysql_affected_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:142: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:149: undefined reference to `mysql_num_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:150: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:151: undefined reference to `mysql_fetch_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:140: undefined reference to `mysql_use_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_next_rowset': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:408: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:410: undefined reference to `mysql_stmt_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:414: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:418: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:430: undefined reference to `mysql_next_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_fetch': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:632: undefined reference to `mysql_stmt_fetch' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:661: undefined reference to `mysql_fetch_row' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:672: undefined reference to `mysql_fetch_lengths' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:665: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_dtor': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:55: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:63: undefined reference to `mysql_stmt_close' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:95: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:99: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:93: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:101: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:170: undefined reference to `mysql_stmt_bind_param' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:175: undefined reference to `mysql_stmt_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:328: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:332: undefined reference to `mysql_real_query' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:170: undefined reference to `mysql_stmt_execute' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_set_row_count': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:121: undefined reference to `mysql_stmt_affected_rows' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:186: undefined reference to `mysql_stmt_result_metadata' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:189: undefined reference to `mysql_fetch_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:200: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:254: undefined reference to `mysql_stmt_bind_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:261: undefined reference to `mysql_stmt_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:209: undefined reference to `mysql_stmt_attr_set' collect2: error: ld returned 1 exit status make: *** [sapi/cli/php] Error 1 ```
关于Ubuntu16.04用tar.gz通用压缩包安装mysql5.7.17失败
系统Ubuntu16.04 64位 准备安装MySQL 57.7.17 概要 apt-cache search libaio #安装mysql依赖库 tar -zxvf -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz #解压压缩包 mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql #修改名字 groupadd mysql #添加用户组 useradd -r -g mysql -s /bin/false mysql #添加用户 cd mysql #进入mysql目录 mkdir mysql-files #新建目录 chmod 750 mysql-files #给目录授权为mysql 用户 chown -R mysql . chgrp -R mysql . bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data #初始化mysql数据库 bin/mysql_ssl_rsa_setup #创建SSL证书,密钥文件和RSA密钥对文件 chown -R root . #给当前目录授权为用户root chown -R mysql data mysql-files bin/mysqld_safe --user=mysql & #启动mysql 问题卡在这了 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491243943_360085.jpg) 详细步骤 1.安装准备 1.1查看自己的Linux系统版本 命令: cat /etc/issue 再具体点:uname -a 86_64就代表64位的系统 OK,咱们确定了自己的系统,现在去MySQL官网下载二进制压缩包源文件 1.2官网下载安装包 https://dev.mysql.com/downloads/mysql/ ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244259_939400.jpg) 选择对应的安装包 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244281_48676.jpg) ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244297_258139.jpg) 下载的话,有两种方式: 1.从官网下载,然后用FTP软件上传到服务器上。 2.使用在线下载的方式,使用命令: wget -P /usr/local/support https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz 注:-P /usr/local/support 是指定下载目录 不要问我为啥网速这么快。。。。我也震惊了 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244091_52801.jpg) 2.开始安装: 参考官方文档 ①为了预防以前安装过mysql,导致旧版本遗留文件冲突,所以需要把以前安装的文件都删除掉 /etc/my.cnf /etc/msyql目录 查找命令: find / -name 文件名or目录名 删除命令: rm -rf 文件名or目录名 ②安装mysql的依赖库libaio 搜索命令 apt-cache search libaio apt-cache search libaio 如果搜索没有显示结果,就安装 安装命令:apt-get install libaio1 注:如果报错,则需要使用更新命令 apt-get update 更新后就可以安装依赖库了 ③解压压缩包 命令: tar -zxvf -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz ④改名字,便于操作 命令:mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql ④添加用户组, 添加用户 groupadd mysql useradd -r -g mysql -s /bin/false mysql ⑤进入msyql目录,创建目录mysql-files cd mysql mkdir mysql-files ⑥给文件夹授权为用户mysql chmod 750 mysql-files chown -R mysql . chgrp -R mysql . ⑦初始化数据库 bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data ⑧创建SSL证书,密钥文件和RSA密钥对文件 bin/mysql_ssl_rsa_setup ⑨给当前目录授权为用户root chown -R root . chown -R mysql data mysql-files ⑩问题来了 每当我执行到这个命令时,就卡那不懂了。。。。请教大神,这是为什么 bin/mysqld_safe --user=mysql & # Next command is optional ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244374_944582.jpg) 然后: 执行 mysql -u root -p 再输入密码,显示: ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244197_897753.png) 尝试解决 网上搜的方法: 在my.cnf 中添加sockt ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244246_429225.png) 使用该方法启动 mysql -p --socket=/tmp/mysql.sock ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244255_351582.png) 另外,参考这篇博客 http://ng2.site/mysql/2016/11/16/install-mysql-offline.html 也是安装失败,请大神指点! ------------------------------------------------------------------------------------------------------------------------------------------------------ PS: 我用apt-get install mysql-server 可以成功安装,但是用通用二进制压缩包离线安装一直安装不成功,这个问题纠结我很久了,成了心结,所以一定要解决掉!
mysql5.7.17zip安装过程中遇到的问题
C:\Users\Administrator>mysqld --console 2017-04-06T07:42:13.052983Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details). 2017-04-06T07:42:13.052983Z 0 [Note] --secure-file-priv is set to NULL. Operatio ns related to importing and exporting data are disabled 2017-04-06T07:42:13.053984Z 0 [Note] mysqld (mysqld 5.7.17) starting as process 5388 ... 2017-04-06T07:42:13.062984Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows in terlocked functions 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: Uses event mutexes 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u sed for memory barrier 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-04-06T07:42:13.064984Z 0 [Note] InnoDB: Number of pools: 1 2017-04-06T07:42:13.064984Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2017-04-06T07:42:13.069984Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 128M, instances = 1, chunk size = 128M 2017-04-06T07:42:13.081985Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-04-06T07:42:13.199992Z 0 [Note] InnoDB: Highest supported file format is Ba rracuda. 2017-04-06T07:42:13.400003Z 0 [Note] InnoDB: Creating shared tablespace for temp orary tables 2017-04-06T07:42:13.402003Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-04-06T07:42:13.577013Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2017-04-06T07:42:13.582014Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-04-06T07:42:13.583014Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-04-06T07:42:13.586014Z 0 [Note] InnoDB: Waiting for purge to start 2017-04-06T07:42:13.637017Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 2534758 2017-04-06T07:42:13.639017Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-04-06T07:42:13.639017Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\mysq l-5.7.17-winx64\mysql-5.7.17-winx64\data\ib_buffer_pool 2017-04-06T07:42:13.749023Z 0 [Warning] Failed to set up SSL because of the foll owing SSL library error: SSL context is not usable without certificate and priva te key 2017-04-06T07:42:13.755024Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2017-04-06T07:42:13.757024Z 0 [Note] IPv6 is available. 2017-04-06T07:42:13.758024Z 0 [Note] - '::' resolves to '::'; 2017-04-06T07:42:13.760024Z 0 [Note] Server socket created on IP: '::'. 2017-04-06T07:42:13.884031Z 0 [Note] InnoDB: Buffer pool(s) load completed at 17 0406 15:42:13 2017-04-06T07:42:14.388060Z 0 [Note] Event Scheduler: Loaded 0 events 2017-04-06T07:42:14.389060Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA .TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2017-04-06T07:42:14.391060Z 0 [Note] Beginning of list of non-natively partition ed tables 2017-04-06T07:42:14.427062Z 0 [Note] End of list of non-natively partitioned tab les 2017-04-06T07:42:14.428062Z 0 [Note] mysqld: ready for connections. Version: '5.7.17' socket: '' port: 3306 MySQL Community Server (GPL)
再往数据库中添加数据时,起初可以添加进去,之后不知道是把电脑关了还是怎么老报错,而且添加不进去了
Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing app
数据库与eclipse连接时候出错
Wed Apr 13 22:46:22 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Wed Apr 13 22:46:22 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Spring Boot yml配置mysql连接禁用SSL不起作用
项目启动警告: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 根据提示更改: ![图片说明](https://img-ask.csdn.net/upload/201906/10/1560132685_591690.jpg) 重启项目不生效
hive输入show databases,连接MySQL出现这个,求大佬详细步骤解决,感谢,拜托了。
WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Eclipse连接MySQL后运行正常,但出现了下述红色的字体,请问怎么解决这一问题?
Fri May 19 22:56:23 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
MyBatis逆向工程提示javax.net.ssl.SSLException是什么问题?
请问MyBatis逆向工程提示javax.net.ssl.SSLException是什么问题?怎么解决? 错误提示: ``` Wed Jan 22 15:08:37 CST 2020 WARN: Caught while disconnecting... EXCEPTION STACK TRACE: ** BEGIN NESTED EXCEPTION ** javax.net.ssl.SSLException MESSAGE: closing inbound before receiving peer's close_notify STACKTRACE: javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:133) at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:117) at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:308) at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:264) at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:255) at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:645) at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:624) at com.mysql.cj.protocol.a.NativeProtocol.quit(NativeProtocol.java:1284) at com.mysql.cj.NativeSession.quit(NativeSession.java:182) at com.mysql.cj.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:1911) at com.mysql.cj.jdbc.ConnectionImpl.close(ConnectionImpl.java:730) at org.mybatis.generator.config.Context.closeConnection(Context.java:535) at org.mybatis.generator.config.Context.introspectTables(Context.java:468) at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:222) at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:133) at GeneratorSqlmap.generator(GeneratorSqlmap.java:27) at GeneratorSqlmap.main(GeneratorSqlmap.java:33) ** END NESTED EXCEPTION ** WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.mybatis.generator.internal.DomWriter (file:/F:/SSM%e9%a1%b9%e7%9b%ae%e5%ae%9e%e6%88%98/%e7%ac%ac%e4%b8%80%e4%bb%b6%20maven%e7%ae%a1%e7%90%86%e7%9a%84ssm%e6%a1%86%e6%9e%b6(%e8%af%a6%e8%a7%a3)/e3%e5%95%86%e5%9f%8e_day01/%e9%bb%91%e9%a9%ac32%e6%9c%9f/01.%e6%95%99%e6%a1%88-3.0/01.%e5%8f%82%e8%80%83%e8%b5%84%e6%96%99/mybatis/%e9%80%86%e5%90%91%e5%b7%a5%e7%a8%8b/generatorSqlmapCustom/lib/mybatis-generator-core-1.3.2.jar) to method com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.getXmlVersion() WARNING: Please consider reporting this to the maintainers of org.mybatis.generator.internal.DomWriter WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release ``` 工程结构: ![图片说明](https://img-ask.csdn.net/upload/202001/22/1579677296_992794.png) GeneratorSqlmap类 ``` public class GeneratorSqlmap { public void generator() throws Exception{ List<String> warnings = new ArrayList<String>(); boolean overwrite = true; File configFile = new File("generatorConfig.xml"); ConfigurationParser cp = new ConfigurationParser(warnings); Configuration config = cp.parseConfiguration(configFile); DefaultShellCallback callback = new DefaultShellCallback(overwrite); MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings); myBatisGenerator.generate(null); } public static void main(String[] args) throws Exception { try { GeneratorSqlmap generatorSqlmap = new GeneratorSqlmap(); generatorSqlmap.generator(); } catch (Exception e) { e.printStackTrace(); } } } ``` generatorConfig.xml ``` <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration> <context id="testTables" targetRuntime="MyBatis3"> <commentGenerator> <!-- 是否去除自动生成的注释 true:是 : false:否 --> <property name="suppressAllComments" value="true" /> </commentGenerator> <!--数据库连接的信息:驱动类、连接地址、用户名、密码 --> <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/e3mall?serverTimezone=UTC" userId="root" password="root"> </jdbcConnection> <!-- 默认false,把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer,为 true时把JDBC DECIMAL 和 NUMERIC 类型解析为java.math.BigDecimal --> <javaTypeResolver> <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <!-- targetProject:生成PO类的位置 --> <javaModelGenerator targetPackage="cn.e3mall.pojo" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> <!-- 从数据库返回的值被清理前后的空格 --> <property name="trimStrings" value="true" /> </javaModelGenerator> <!-- targetProject:mapper映射文件生成的位置 --> <sqlMapGenerator targetPackage="cn.e3mall.mapper" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> </sqlMapGenerator> <!-- targetPackage:mapper接口生成的位置 --> <javaClientGenerator type="XMLMAPPER" targetPackage="cn.e3mall.mapper" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> </javaClientGenerator> <!-- 指定数据库表 --> <table schema="" tableName="tb_content"></table> <table schema="" tableName="tb_content_category"></table> <table schema="" tableName="tb_item"></table> <table schema="" tableName="tb_item_cat"></table> <table schema="" tableName="tb_item_desc"></table> <table schema="" tableName="tb_item_param"></table> <table schema="" tableName="tb_item_param_item"></table> <table schema="" tableName="tb_order"></table> <table schema="" tableName="tb_order_item"></table> <table schema="" tableName="tb_order_shipping"></table> <table schema="" tableName="tb_user"></table> </context> </generatorConfiguration> ```
运行程序报以下错误,求大佬帮忙
Fri Dec 08 08:05:55 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 已经修改了mysql:localhost:3306/数据库名?useSSL=false,但是还是报以上错误
java与mysql连接出现的问题
Fri Sep 09 00:56:14 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:875) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1712) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1228) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jakey.util.DbUtil.getCon(DbUtil.java:19) at com.jakey.util.DbUtil.main(DbUtil.java:31 代码 package com.jakey.util; import java.sql.Connection; import java.sql.DriverManager; public class DbUtil { // 定义数据库驱动程序 private static final String driver = "com.mysql.jdbc.Driver"; // 数据库连接地址 private static final String url = "jdbc:mysql://localhost:3306/db_courseselect?useUnicode=true&characterEncoding=utf-8";// library表示数据库 private static final String user = "root"; private static final String password = "LWZ222MESSI"; private static Connection connection = null; // 连接数据库 public DbUtil(){ // 数据库操作可能出现异常 try { Class.forName(driver); System.out.println("加载驱动文件成功!"); connection = DriverManager.getConnection(url, user, password); System.out.println("获得连接对象成功!"); } catch (Exception exception) { exception.printStackTrace(); System.out.println("数据库连接失败"); } finally { } } public static Connection getConnection() { return connection; } public static void close(Connection connection ) throws Exception { if (connection != null) { try { connection.close(); } catch (Exception e) { // TODO: handle exception throw e; } } } }
ecplise连接mysql本地数据库登录失败!求大神知道怎么回事!
Mon Nov 06 03:47:19 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at my01.Login_main01.loginButton_actionPerformed(Login_main01.java:78) at my01.Login_main01.actionPerformed(Login_main01.java:105) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:6297) at javax.swing.JComponent.processMouseEvent(JComponent.java:3275) at java.awt.Component.processEvent(Component.java:6062) at java.awt.Container.processEvent(Container.java:2039) at java.awt.Component.dispatchEventImpl(Component.java:4660) at java.awt.Container.dispatchEventImpl(Container.java:2097) at java.awt.Component.dispatchEvent(Component.java:4488) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166) at java.awt.Container.dispatchEventImpl(Container.java:2083) at java.awt.Window.dispatchEventImpl(Window.java:2489) at java.awt.Component.dispatchEvent(Component.java:4488) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:674) at java.awt.EventQueue.access$400(EventQueue.java:81) at java.awt.EventQueue$2.run(EventQueue.java:633) at java.awt.EventQueue$2.run(EventQueue.java:631) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$3.run(EventQueue.java:647) at java.awt.EventQueue$3.run(EventQueue.java:645) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:644) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)![图片](https://img-ask.csdn.net/upload/201711/06/1509965515_190525.jpg)
文件名我检查过没错,请问这是由什么引起的
Wed Jul 20 09:51:52 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Wed Jul 20 09:51:52 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Wed Jul 20 09:51:52 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Exception in thread "main" org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com/hsp/service/imp/EmployeeService] for bean with name 'employeeService' defined in class path resource [applicationContext.xml]: problem with class file or dependent class; nested exception is java.lang.NoClassDefFoundError: IllegalName: com/hsp/service/imp/EmployeeService at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1144) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.predictBeanType(AbstractAutowireCapableBeanFactory.java:524) at org.springframework.beans.factory.support.AbstractBeanFactory.isFactoryBean(AbstractBeanFactory.java:1177) at org.springframework.beans.factory.support.AbstractBeanFactory.isFactoryBean(AbstractBeanFactory.java:758) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:422) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) at com.hsp.test.Test.main(Test.java:13) Caused by: java.lang.NoClassDefFoundError: IllegalName: com/hsp/service/imp/EmployeeService at java.lang.ClassLoader.preDefineClass(ClassLoader.java:477) at java.lang.ClassLoader.defineClass(ClassLoader.java:615) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124) at java.net.URLClassLoader.defineClass(URLClassLoader.java:260) at java.net.URLClassLoader.access$000(URLClassLoader.java:56) at java.net.URLClassLoader$1.run(URLClassLoader.java:195) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:252) at org.springframework.util.ClassUtils.forName(ClassUtils.java:211) at org.springframework.beans.factory.support.AbstractBeanDefinition.resolveBeanClass(AbstractBeanDefinition.java:385) at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1138) ... 9 more
openssl和mysql冲突 ERR_remove_thread_state
openssl版本:openssl-1.1.0k mysql版本:mysql-5.7.27 静态库,编译报如下错误: /thirdparty/mysql/lib/libmysqlclient.a(ssl.cpp.o): In function `ERR_remove_thread_state': /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/extra/yassl/src/ssl.cpp:1619: multiple definition of `ERR_remove_thread_state' /home/lics/code/transfer/thirdparty/openssl/lib/libcrypto.a(err.o):err.c:(.text+0xb60): first defined here collect2: error: ld returned 1 exit status make[1]: [build] Error 1 (ignored) 请问有谁遇到过吗?
MAC下,openFire连不上服务器,Error 报log4j:ERROR setFile(null,true) call failed.
cat: 1294: No such file or directory cat: 1294: No such file or directory log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /logs/all.log (No such file or directory) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /logs/debug.log (No such file or directory) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /logs/info.log (No such file or directory) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /logs/warn.log (No such file or directory) Sun Sep 23 10:38:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 求怎么解决?这个目录也找不到
mysql.sock的所有者所属组以及权限全部都是问号?求助神回复如何删除,亦或是如何重建,必有重谢!!!
mysql.sock的所有者所属组以及权限全部都是问号?求助神回复如何删除,亦或是如何重建,必有重谢!!! 代码如下: [root@DBServer-BAK lib]# cd /tmp [root@DBServer-BAK tmp]# ll ls: 无法访问mysql.sock: 输入/输出错误 总用量 40 drwxr-xr-x 2 root root 4096 6月 25 11:16 hsperfdata_root s????????? ? ? ? ? ? mysql.sock -rw------- 1 mysql mysql 6 6月 25 11:34 mysql.sock.lock -rwxrwxrwx 1 root root 45 6月 25 11:46 mysql.sock.tar.gz drwx------ 3 root root 4096 6月 25 11:16 systemd-private-0a3b207663d847a183bbad804fca0ebd-colord.service-sic0B1 drwx------ 3 root root 4096 6月 25 11:16 systemd-private-0a3b207663d847a183bbad804fca0ebd-cups.service-4zk1XQ drwx------ 3 root root 4096 6月 25 11:16 systemd-private-0a3b207663d847a183bbad804fca0ebd-rtkit-daemon.service-aM0JqV drwx------ 3 root root 4096 6月 20 07:42 systemd-private-6d51751ab45a4174b26d3719b9ce8eee-colord.service-1RN8yw drwx------ 3 root root 4096 6月 20 07:42 systemd-private-6d51751ab45a4174b26d3719b9ce8eee-cups.service-vXDiW2 drwx------ 3 root root 4096 6月 20 07:42 systemd-private-6d51751ab45a4174b26d3719b9ce8eee-rtkit-daemon.service-zCu1j4 drwx------ 2 ytomsbag ytomsbag 4096 6月 21 11:23 tracker-extract-files.1000 错误日志如下: 2019-06-25T05:00:27.641394Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-06-25T05:00:27.642251Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-06-25T05:00:27.642263Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-06-25T05:00:27.643015Z 0 [Note] InnoDB: Waiting for purge to start 2019-06-25T05:00:27.693118Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2539728 2019-06-25T05:00:27.693642Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool 2019-06-25T05:00:27.693845Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-06-25T05:00:27.694464Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190625 13:00:27 2019-06-25T05:00:27.698589Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2019-06-25T05:00:27.698608Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2019-06-25T05:00:27.698645Z 0 [Note] IPv6 is available. 2019-06-25T05:00:27.698657Z 0 [Note] - '::' resolves to '::'; 2019-06-25T05:00:27.698702Z 0 [Note] Server socket created on IP: '::'. 2019-06-25T05:00:27.698752Z 0 [ERROR] Could not create unix socket lock file tmp/mysql.sock.lock. 2019-06-25T05:00:27.698766Z 0 [ERROR] Unable to setup unix socket lock file. 2019-06-25T05:00:27.698773Z 0 [ERROR] Aborting 2019-06-25T05:00:27.698781Z 0 [Note] Binlog end
sonar 配置mysql 连接报错
sonar 版本 6.7 mysql 版本 8.0 配置:sonar.jdbc.url=jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false sonar.jdbc.username=easy sonar.jdbc.password=nolove 错误信息:11:30:57.509 [WrapperSimpleAppMain] WARN org.sonar.application.config.JdbcSettings - JDBC URL is recommended to have the property 'useConfigs=maxPerformance' 2018.09.04 11:30:57 INFO app[][o.s.a.AppFileSystem] Cleaning or creating temp directory F:\service\sonarqube-6.7.4\temp 2018.09.04 11:30:57 INFO app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001 2018.09.04 11:30:57 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [F:\service\sonarqube-6.7.4\elasticsearch]: F:\service\jdk1.8\jre\bin\java -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -XX:+AlwaysPreTouch -server -Xss1m -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djna.nosys=true -Djdk.io.permissionsUseCanonicalPath=true -Dio.netty.noUnsafe=true -Dio.netty.noKeySetOptimization=true -Dio.netty.recycler.maxCapacityPerThread=0 -Dlog4j.shutdownHookEnabled=false -Dlog4j2.disable.jmx=true -Dlog4j.skipJansi=true -Xms512m -Xmx512m -XX:+HeapDumpOnOutOfMemoryError -Delasticsearch -Des.path.home=F:\service\sonarqube-6.7.4\elasticsearch -cp lib/* org.elasticsearch.bootstrap.Elasticsearch -Epath.conf=F:\service\sonarqube-6.7.4\temp\conf\es 2018.09.04 11:30:57 INFO app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running 2018.09.04 11:30:57 INFO app[][o.e.p.PluginsService] no modules loaded 2018.09.04 11:30:57 INFO app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin] 2018.09.04 11:31:05 INFO app[][o.s.a.SchedulerImpl] Process[es] is up 2018.09.04 11:31:05 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [F:\service\sonarqube-6.7.4]: F:\service\jdk1.8\jre\bin\java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=F:\service\sonarqube-6.7.4\temp -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -cp ./lib/common/*;./lib/server/*;F:\service\sonarqube-6.7.4\lib\jdbc\mysql\mysql-connector-java-5.1.42.jar org.sonar.server.app.WebServer F:\service\sonarqube-6.7.4\temp\sq-process1179029085093446759properties Tue Sep 04 11:31:08 AWST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] Process [web] is stopped 2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] Process [es] is stopped 2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped 2018.09.04 11:31:09 WARN app[][o.e.t.n.Netty4Transport] exception caught on transport layer [[id: 0xadc1a015, L:/127.0.0.1:53287 - R:/127.0.0.1:9001]], closing connection java.io.IOException: 远程主机强迫关闭了一个现有的连接。
在中国程序员是青春饭吗?
今年,我也32了 ,为了不给大家误导,咨询了猎头、圈内好友,以及年过35岁的几位老程序员……舍了老脸去揭人家伤疤……希望能给大家以帮助,记得帮我点赞哦。 目录: 你以为的人生 一次又一次的伤害 猎头界的真相 如何应对互联网行业的「中年危机」 一、你以为的人生 刚入行时,拿着傲人的工资,想着好好干,以为我们的人生是这样的: 等真到了那一天,你会发现,你的人生很可能是这样的: ...
深析Synchronized关键字(小白慎入,深入jvm源码,两万字长文)
目录一、synchronized基础1.1synchronized的使用1.1示例1.2验证1.2.1 普通方法和代码块中使用this是同一个监视器(锁),即某个具体调用该代码的对象1.2.2 静态方法和代码块中使用该类的class对象是同一个监视器,任何该类的对象调用该段代码时都是在争夺同一个监视器的锁定1.2、synchronized的特点二、synchronized进阶2.1对象头2.2sy
GitHub 总星 4w+!删库?女装?表情包?这些沙雕中文项目真是我每天快乐的源泉!
大家好,我是 Rocky0429,一个喜欢在 GitHub 上瞎逛的蒟蒻… 好看的皮囊千篇一律,有趣的灵魂没有底线。作为全球最大的同性交友网站,GayHub GitHub 上不止有鲜活的代码,秃头的算法,还有很多拥有有(sha)趣(diao)灵魂的宝藏。 还记得我之前给大家介绍的 Sorry 项目嘛,一个可以自己做表情包的项目,这个的沙雕程度在下面这些项目面前只能算弟弟。虽然说沙雕不分国...
程序员请照顾好自己,周末病魔差点一套带走我。
程序员在一个周末的时间,得了重病,差点当场去世,还好及时挽救回来了。
卸载 x 雷某度!GitHub 标星 1.5w+,从此我只用这款全能高速下载工具!
作者 | Rocky0429 来源 | Python空间 大家好,我是 Rocky0429,一个喜欢在网上收集各种资源的蒟蒻… 网上资源眼花缭乱,下载的方式也同样千奇百怪,比如 BT 下载,磁力链接,网盘资源等等等等,下个资源可真不容易,不一样的方式要用不同的下载软件,因此某比较有名的 x 雷和某度网盘成了我经常使用的工具。 作为一个没有钱的穷鬼,某度网盘几十 kb 的下载速度让我...
20道你必须要背会的微服务面试题,面试一定会被问到
这篇博客总结了面试中最常见的微服务面试题,相信对你有所帮助。
讲真,这两个IDE插件,可以让你写出质量杠杠的代码
周末躺在床上看《拯救大兵瑞恩》 周末在闲逛的时候,发现了两个优秀的 IDE 插件,据说可以提高代码的质量,我就安装了一下,试了试以后发现,确实很不错,就推荐给大家。 01、Alibaba Java 代码规范插件 《阿里巴巴 Java 开发手册》,相信大家都不会感到陌生,其 IDEA 插件的下载次数据说达到了 80 万次,我今天又贡献了一次。嘿嘿。 该项目的插件地址: https://github....
为什么猝死的都是程序员,基本上不见产品经理猝死呢?
相信大家时不时听到程序员猝死的消息,但是基本上听不到产品经理猝死的消息,这是为什么呢? 我们先百度搜一下:程序员猝死,出现将近700多万条搜索结果: 搜索一下:产品经理猝死,只有400万条的搜索结果,从搜索结果数量上来看,程序员猝死的搜索结果就比产品经理猝死的搜索结果高了一倍,而且从下图可以看到,首页里面的五条搜索结果,其实只有两条才是符合条件。 所以程序员猝死的概率真的比产品经理大,并不是错...
毕业5年,我问遍了身边的大佬,总结了他们的学习方法
我问了身边10个大佬,总结了他们的学习方法,原来成功都是有迹可循的。
推荐10个堪称神器的学习网站
每天都会收到很多读者的私信,问我:“二哥,有什么推荐的学习网站吗?最近很浮躁,手头的一些网站都看烦了,想看看二哥这里有什么新鲜货。” 今天一早做了个恶梦,梦到被老板辞退了。虽然说在我们公司,只有我辞退老板的份,没有老板辞退我这一说,但是还是被吓得 4 点多都起来了。(主要是因为我掌握着公司所有的核心源码,哈哈哈) 既然 4 点多起来,就得好好利用起来。于是我就挑选了 10 个堪称神器的学习网站,推...
良心推荐,我珍藏的一些Chrome插件
上次搬家的时候,发了一个朋友圈,附带的照片中不小心暴露了自己的 Chrome 浏览器插件之多,于是就有小伙伴评论说分享一下我觉得还不错的浏览器插件。 我下面就把我日常工作和学习中经常用到的一些 Chrome 浏览器插件分享给大家,随便一个都能提高你的“生活品质”和工作效率。 Markdown Here Markdown Here 可以让你更愉快的写邮件,由于支持 Markdown 直接转电子邮...
看完这篇HTTP,跟面试官扯皮就没问题了
我是一名程序员,我的主要编程语言是 Java,我更是一名 Web 开发人员,所以我必须要了解 HTTP,所以本篇文章就来带你从 HTTP 入门到进阶,看完让你有一种恍然大悟、醍醐灌顶的感觉。 最初在有网络之前,我们的电脑都是单机的,单机系统是孤立的,我还记得 05 年前那会儿家里有个电脑,想打电脑游戏还得两个人在一个电脑上玩儿,及其不方便。我就想为什么家里人不让上网,我的同学 xxx 家里有网,每...
2020 年,大火的 Python 和 JavaScript 是否会被取而代之?
Python 和 JavaScript 是目前最火的两大编程语言,但是2020 年,什么编程语言将会取而代之呢? 作者 |Richard Kenneth Eng 译者 |明明如月,责编 | 郭芮 出品 | CSDN(ID:CSDNnews) 以下为译文: Python 和 JavaScript 是目前最火的两大编程语言。然而,他们不可能永远屹立不倒。最终,必将像其他编程语言一...
C语言数字图像处理---1.4直方图拉伸和直方图均衡化
本篇将延续上一篇的内容,对直方图进行扩展,讲述直方图拉伸和直方图均衡化两个内容,并通过简单的C语言来实现这两个基础功能,让初学者通俗易懂。
史上最全的IDEA快捷键总结
现在Idea成了主流开发工具,这篇博客对其使用的快捷键做了总结,希望对大家的开发工作有所帮助。
阿里程序员写了一个新手都写不出的低级bug,被骂惨了。
这种新手都不会范的错,居然被一个工作好几年的小伙子写出来,差点被当场开除了。
谁是华为扫地僧?
是的,华为也有扫地僧!2020年2月11-12日,“养在深闺人不知”的华为2012实验室扫地僧们,将在华为开发者大会2020(Cloud)上,和大家见面。到时,你可以和扫地僧们,吃一个洋...
没用过这些 IDEA 插件?怪不得写代码头疼
使用插件,可以提高开发效率。对于开发人员很有帮助。这篇博客介绍了IDEA中最常用的一些插件。
AI 没让人类失业,搞 AI 的人先失业了
最近和几个 AI 领域的大佬闲聊 根据他们讲的消息和段子 改编出下面这个故事 如有雷同 都是巧合 1. 老王创业失败,被限制高消费 “这里写我跑路的消息实在太夸张了。” 王葱葱哼笑一下,把消息分享给群里。 阿杰也看了消息,笑了笑。在座几位也都笑了。 王葱葱是个有名的人物,21岁那年以全额奖学金进入 KMU 攻读人工智能博士,累计发表论文 40 余篇,个人技术博客更是成为深度学习领域内风向标。 ...
2020年,冯唐49岁:我给20、30岁IT职场年轻人的建议
点击“技术领导力”关注∆每天早上8:30推送 作者|Mr.K 编辑| Emma 来源|技术领导力(ID:jishulingdaoli) 前天的推文《冯唐:职场人35岁以后,方法论比经验重要》,收到了不少读者的反馈,觉得挺受启发。其实,冯唐写了不少关于职场方面的文章,都挺不错的。可惜大家只记住了“春风十里不如你”、“如何避免成为油腻腻的中年人”等不那么正经的文章。 本文整理了冯...
推荐一些有趣的在线编程游戏
1.Robocode 让坦克们互相博弈的游戏,你可以看到它们飞奔,碾碎一切挡道的东西。机器人配有雷达与火炮,选手在躲避对手进攻的同时攻击对手,以此来较量得分的多少。这个游戏很有意思,曾经令我沉迷… 你可以用Java、Scala、C#等编程语言,编写人工智能程序,驱动机器人。 2.Code Combat Code Combat是一款学习编程的角色扮演游戏。每一关都用任务的形式设立目标,用实时的反馈...
工作十年的数据分析师被炒,没有方向,你根本躲不过中年危机
2020年刚刚开始,就意味着离职潮高峰的到来,我身边就有不少人拿着年终奖离职了,而最让我感到意外的,是一位工作十年的数据分析师也离职了,不同于别人的主动辞职,他是被公司炒掉的。 很多人都说数据分析是个好饭碗,工作不累薪资高、入门简单又好学。然而今年34的他,却真正尝到了中年危机的滋味,平时也有不少人都会私信问我: 数据分析师也有中年危机吗?跟程序员一样是吃青春饭的吗?该怎么保证自己不被公司淘汰...
作为一名大学生,如何在B站上快乐的学习?
B站是个宝,谁用谁知道???? 作为一名大学生,你必须掌握的一项能力就是自学能力,很多看起来很牛X的人,你可以了解下,人家私底下一定是花大量的时间自学的,你可能会说,我也想学习啊,可是嘞,该学习啥嘞,不怕告诉你,互联网时代,最不缺的就是学习资源,最宝贵的是啥? 你可能会说是时间,不,不是时间,而是你的注意力,懂了吧! 那么,你说学习资源多,我咋不知道,那今天我就告诉你一个你必须知道的学习的地方,人称...
那些年,我们信了课本里的那些鬼话
教材永远都是有错误的,从小学到大学,我们不断的学习了很多错误知识。 斑羚飞渡 在我们学习的很多小学课文里,有很多是错误文章,或者说是假课文。像《斑羚飞渡》: 随着镰刀头羊的那声吼叫,整个斑羚群迅速分成两拨,老年斑羚为一拨,年轻斑羚为一拨。 就在这时,我看见,从那拨老斑羚里走出一只公斑羚来。公斑羚朝那拨年轻斑羚示意性地咩了一声,一只半大的斑羚应声走了出来。一老一少走到伤心崖,后退了几步,突...
张朝阳回应迟到 1 分钟罚 500:资本家就得剥削员工
loonggg读完需要2分钟速读仅需 1 分钟大家我,我是你们的校长。前几天,搜狐的董事局主席兼 CEO 张朝阳和搜狐都上热搜了。原因很简单,就是搜狐出了“考勤新规”。一封搜狐对员工发布...
一个程序在计算机中是如何运行的?超级干货!!!
强烈声明:本文很干,请自备茶水!???? 开门见山,咱不说废话! 你有没有想过,你写的程序,是如何在计算机中运行的吗?比如我们搞Java的,肯定写过这段代码 public class HelloWorld { public static void main(String[] args) { System.out.println("Hello World!"); } ...
【蘑菇街技术部年会】程序员与女神共舞,鼻血再次没止住。(文末内推)
蘑菇街技术部的年会,别开生面,一样全是美女。
那个在阿里养猪的工程师,5年了……
简介: 在阿里,走过1825天,没有趴下,依旧斗志满满,被称为“五年陈”。他们会被授予一枚戒指,过程就叫做“授戒仪式”。今天,咱们听听阿里的那些“五年陈”们的故事。 下一个五年,猪圈见! 我就是那个在养猪场里敲代码的工程师,一年多前我和20位工程师去了四川的猪场,出发前总架构师慷慨激昂的说:同学们,中国的养猪产业将因为我们而改变。但到了猪场,发现根本不是那么回事:要个WIFI,没有;...
为什么程序猿都不愿意去外包?
分享外包的组织架构,盈利模式,亲身经历,以及根据一些外包朋友的反馈,写了这篇文章 ,希望对正在找工作的老铁有所帮助
Java校招入职华为,半年后我跑路了
何来 我,一个双非本科弟弟,有幸在 19 届的秋招中得到前东家华为(以下简称 hw)的赏识,当时秋招签订就业协议,说是入了某 java bg,之后一系列组织架构调整原因等等让人无法理解的神操作,最终毕业前夕,被通知调往其他 bg 做嵌入式开发(纯 C 语言)。 由于已至于校招末尾,之前拿到的其他 offer 又无法再收回,一时感到无力回天,只得默默接受。 毕业后,直接入职开始了嵌入式苦旅,由于从未...
立即提问