I am looking to be able to directly access the MySQL databases on our webserver instead of going via PHP scripts as at present. On the server I have created a database called (names changed here) xyz001_test and added a user of xyz001_user, password ps . I have selected the Remote MySQL option and added % to enable remote access.
Locally I have built a stub application with a connect dialog. I fill it in as follows:
User name: xyz001_user
Password: ps
Server: myserver.co.uk
Port: 3306
Database: xyz001_test
Pressing connect gives an error box, the top lines of which are
[0A53299D]{mydac100.bpl} Myclasses.TMySQLConnection.MySQLError + $89
[0A5328DE]{mydac100.bpl} Myclasses.TMySQLConnection.Check + $6
[0A532F78]{mydac100.bpl} Myclasses.TMySQLConnection.Connect + $168
[0CC2B4E8]{dac100.bpl } Dbaccess.TCustomDAConnection.DoConnect + $98
[0CC2B502]{dac100.bpl } Dbaccess.TCustomDAConnection.DoConnect + $B2
[0A54B9B4]{mydac100.bpl} Myaccess.TCustomMyConnection.DoConnect + $10
[0CC2B803]{dac100.bpl } Dbaccess.TCustomDAConnection.PerformConnect + $37
[0CD19F7D]{dcldac100.bpl} Daconnectioneditor.TDAConnectionEditorForm.btConnectClick + $45
Where am I going wrong? If I can crack this the rest should be easy.
I have Windows Firewall turned off, Kaspersky turned on, and have added my app to the Kaspersky allow list port 3306
TYIA for your help
Stuck at the first hurdle.
Follow up info
Should have said that MySQL is 5.0.45 on a Linux server, and my app is Delphi 2007
Answered my own question
Pending any answers here, got a reply from my ISP: I can't make this work because they do not allow external access to hosted MySQL databases. End of a good idea and back to PHP.