I cannot connect to MySQL through localhost or 127.0.0.1
error message": “Failed to launch service “test”: CDbConnection failed to open the DB connection.”,
I’ve a fresh install of MySQL 5.6.19, port 3306 using all defaults,
I can ping localhost, 127.0.0.1 from command prompt.
Using MySQL workbench, it shows server to be running and can connect to my test database
I’ve set up a DreamFactory service: Remote SQL DB
connection string is mysql:host=localhost;dbname=t1
The user is ‘newuser’ who has all rights to the t1 database, set up through MySQL workbench.
MySQL is running as a windows service,
Windows firewall set for 3306 incoming port open for MySQL service , using TCP
I cannot connect to localhost or 127.0.0.1 through telnet
I suspect it is not a dreamfactory issue per se, but I don’t know what to do next and I have no technical resources at hand.
Regrets, but all this backend stuff is not my cup of tea. Just want to get access to local hosted data base the easiest way possible.