Cannot connect to MYSQL database 5.7.23
Apologies if this double posts. I just wrote a whole post, hit submit and then it seemed like the whole post disappeared.
I have a client's site set up in PHPStorm including a connection to their database. This used to work fine but at some point in the last few months the connection stopped working. The database is MYSQL 5.7.23 hosted on Bluehost.
When I attempt to set up the DB connection and test the connection I get this error message:
DBMS: MySQL (ver. 5.7.23)
Case sensitivity: plain=mixed, delimited=exact
No appropriate protocol (protocol is disabled or cipher suites are inappropriate).
I'm not sure how to resolve this. I have another client with a site on a different host with a MYSQL 5.7.41 database and I have not problems connecting to that database with pretty much the same configuration (except server, username etc.)
Any suggestions to try?
请先登录再写评论。
It is hard to tell anything before checking log files but at the quick glance, it looks similar to this ticket (check workarounds section as well):
https://youtrack.jetbrains.com/issue/DBE-13313/Cant-connect-to-remote-MySQL-since-last-version-of-IntelliJ
Do you know what TLS version is being used on the affected server?
Same problem
I had the same problem, just make sure you are running the right database on your computer. For example in my linux computer i acces the mysql terminal and use the command USE the_name_of_your_db; .
This site explains it well https://www.twilio.com/en-us/blog/beginner-mysql-database-java-spring-boot.
fwiw I'm just leaving this here for the next person. Setting up a MySQL Server 8 on an AWS EC2 instance and got the same unexpected error when testing the connection from IntelliJ:
Case sensitivity: plain=mixed, delimited=exactRebooting the server cleared it :/