2. PHPRunner General questions
  3. Changing database from Postgresql to Mysql
This topic is locked

Changing database from Postgresql to Mysql

 		9/6/2021 5:20:20 PM
PHPRunner General questions
J
 jaffleck author

I have an application that was initially written to run on PostgreSQL and I wanted to convert it to MySQL. I have replicated the database but I cannot change the connection in PHPRunner. After entering the mysql server hostname/user/password and changing the port to 3306 I get the following error when I click Connect: "Error connecting to the database received invalid response to SSL negotiations: j". I can connect to the database just fine if I start a new application, so I know it works. I'd rather not have to recreate the entire application.
J
 		jaffleck author 9/7/2021

I'm running PHPRunner Version 10.6 build #37751x64
Admin 9/7/2021

This is sounds really strange. Database connection always works the same way be that a new project or a new connection in the existing project. There must be something that you are doing differently.

J
 		jaffleck author 9/8/2021

Well, thinking about this, I guess I would't expect to be able to change the database just by modifying the connection parameters, as I expect those are Postgresql parameters, not MySQL parameters. So let me rephrase my question:

How do you go about changing the database driver from Postgresql to MySQL?