实际问题是什么? MySQL的? [英] What is the actual issue? MySql?
问题描述
您好，我已经尝试了很多天，没有解决任何问题.我是 BEGINNER ，所以请替我做些模糊的事情.我的问题是问题所在，从我的角度来看，有很多事情需要解决.只需显示在正确的方向.
Hello, I have been trying to solve this problem for many days with no resolve. I am a BEGINNER, so dim things done for me, please. My question is what is the problem, there are many stones to turn over from my perspective. Just need to be shown in the right direction.
我已经完全重新启动计算机，并至少将mysql卸载了4倍.我花了很多时间试图解决这个问题. 时间太多.因此，我们将不胜感激任何帮助. 答案可能是我可能不知道我必须要做的事情，但答案很明显.喜欢安装一些东西.
I have completely restarted my computer and uninstall the mysql at least 4x. I have invested a lot of time in trying to figure this out. Too much time has been put in this. So any help is truly appreciated. The answer might be something I might not know I had to do but is obviouse. Like to install something.
计算机状态:
Mac El Captain，MySQL 5.7，Netbeans 8.1，Tomcat 8.0(未安装最新版本)，Connect/J(可能未正确设置)
Mac El Captain, MySQL 5.7, Netbeans 8.1, Tomcat 8.0 (told not install the latest version), Connect/J (might have not set this up correctly)
我遵循了以下说明 https://netbeans.org/kb/docs/ide /mysql.html . 当我在Netbeans上建立新连接时，我已经测试了连接，并且连接成功.我在Netbeans上创建了一个数据库，并在命令行上看到了我显示的数据库；
I followed these instruction https://netbeans.org/kb/docs/ide/mysql.html. When I establishing a new connection on Netbeans, I have tested the connection and it was successful. I created a database on my Netbeans and I see it on my command line what I do show databases;
我不认为我做错了什么，我想我只是缺少了一些东西.
I don't think I have done anything wrong, I think I have something simply missing.
错误消息，当在NetBeans上清理并构建一个使用mysql进行测试的项目时.
Error Messages When Clean and Building a project on NetBeans that has tests using mysql.
1.
在没有服务器身份验证的情况下建立SSL连接是 不建议.根据MySQL 5.5.45 +，5.6.26 +和5.7.6+ 要求如果显式，则默认情况下必须建立SSL连接 选项未设置.为了符合不使用的现有应用程序 SSL将verifyServerCertificate属性设置为'false'.你需要 通过设置useSSL = false显式禁用SSL，或设置 useSSL = true并提供服务器证书的信任库 确认. 2016年1月4日11:46:29 AM org.springframework.context.support.ClassPathXmlApplicationContext prepareRefresh
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. Jan 04, 2016 11:46:29 AM org.springframework.context.support.ClassPathXmlApplicationContext prepareRefresh
2.
无法获得JDBC连接；嵌套的异常是 org.apache.commons.dbcp.SQLNestedException:无法创建 PoolableConnectionFactory(拒绝访问用户'root'@'localhost' (使用密码:是))
Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
我想要可能的问题，我需要研究的方向.
I want the possible problems, the direction I need to look at.
错误消息1.我在网上还没有找到任何解决方案，因此任何链接都将有所帮助.
Error Message 1. I have not found any solution on the net yet for this, any links would be helpful.
错误消息2.我已经遍历网络的各个角落，发现了这个问题，没有运气.
Error Message 2. I have gone to every corner of the web figuring this problem out and no luck.
我已将root @ localhost的密码重置为root 我已经冲淡了特权 我以各种可以想象的方式并且在相当多的时间里做到了这一点. 还有很多其他事情. 我可以使用mysql -u root -p正常登录，然后输入我的root密码.
I have reset my password of root@localhost to root I have flushed my privileges I have done this every conceivable way and in a remarkable amount of times. And whole lot of other things. I can log in normal using mysql -u root -p and then entering my root password.
我只需要知道有哪些门，最有可能是问题所在.
I just need need to know what doors there are and which are most likely the problem.
以下图片可能会有所帮助:图片
Here is a pic that might help: pic
侧面问题: MySql的my.cnf文件仍然是新版本的MySQL中的文件吗?我已经读过，我的电脑没有.我假设它在较早的版本中就存在.
Side Question: my.cnf file of MySql is it still a file in the new version of MySQL? I have read about it, my computer does not have it. I am assuming it was there in the older versions.
推荐答案
第一个错误是抱怨从Netbeans到MySQL的SSL连接.看来NetBeans的默认设置是使用SSL.这意味着您有两种选择:
The first error is complaining about an SSL connection from your Netbeans to your MySQL. It seems NetBeans's default is to use SSL. That means you have two choices:
- 关闭SSL.如果您的'beans机器和MySQL服务器位于同一数据中心，则这是更好的选择.
- 使用适当的私有证书配置MySQL，并使用必要的证书配置'beans.
要尝试做#1，您的JDBC连接字符串(告诉'beans MySQL服务器所在的位置以及如何连接到它的文本字符串)需要带有特定的属性值.也就是说，useSSL属性的值必须为false.如果使用glassfish GUI设置连接字符串，则会找到一个屏幕，您可以在其中添加..此属性作为连接字符串的几个属性之一.
To try to do #1, your JDBC connection string (the text string telling 'beans where your MySQL server is located and how to connect to it) needs to carry a particular property value. That is, the useSSL property needs to have a value of false. If you're setting up the connection string using the glassfish GUI, you'll find a screen where you can Add.. this property as one of several to the connection string.
请参见此过程的步骤6: https://netbeans.org /kb/docs/web/mysql-webapp.html#prepareCommunication
See Step 6 of this procedure: https://netbeans.org/kb/docs/web/mysql-webapp.html#prepareCommunication
易于将属性附加到连接字符串.只需将&useSSL=false附加到字符串即可.
Properties are easy to append to connection strings. Simply append &useSSL=false to the string.
首先解决您的第一个错误，然后尝试解决第二个错误.
Get your first error solved first, then attempt to solve the second one.
这篇关于实际问题是什么? MySQL的?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
