MySQL Connection in Example project

[Cody_O_Meara]

Hello! I opened the MySQL demo project to test a connection to my DB. The only things I changed are the connection credentials and added the Port line. However I keep getting the error in the below photo.

Is “cpe-24-194-113-141.nycap.res.rr.com” related to the Xojo in the error? I thought it would be my host (‘root’@‘45…’)

I copy and pasted the credentials directly from a working VB project so I know the password is typed correctly.

I am on the latest version on Windows 10.

Thanks!

[Christian_Schmitz]

Are you sure you could login with root?

Also root may be limited to localhost only, so no outside access.

[Cody_O_Meara]

Hi Christian,

That is probably the case. I just created a new user with access and works fine now.

Thank you!