connect to mysql server using realbasic

Question

I tried connecting to a mysql server in realbasic using the following code:

dim db as MySQLCommunityServer 

db=New MySQLCommunityServer

  db.host="192.168.240.129"
  db.port=3306
  db.databaseName="test"
  db.userName="test"
  db.Password="test"

   If db.Connect() then
      txt1.Text = "Connected"
   else
     txt1.Text = "Connection failed!"+ chr(13)+db.ErrorMessage
   end if

and I get the following message connection failed!

Does anyone know how I can fix that?

Thanks

You'll need to get a more detailed error message, it really could be anything .... — Pekka, Jun 05 '10 at 11:48
tried db.ErrorMessage and it gave me: Lost connection to MySql server at 'reading — Gbolahan, Jun 05 '10 at 12:23

score 1 · Answer 1 · answered Apr 18 '13 at 20:25

1

I just ran into this. In my case it was due to MySql Server not running on the server.

answered Apr 18 '13 at 20:25

Hardy Macia

21
1

score 1 · Answer 2 · edited Jul 15 '11 at 19:48

1

Try adding this:

db.databaseName="root" 
db.userName="test" 
db.Password=""

edited Jul 15 '11 at 19:48

thegrinner

11,546
5
41
64

answered Jul 15 '11 at 06:30

Kyonzuken Megabyte

11
1

score 1 · Answer 3 · answered Jul 15 '11 at 20:29

Check the db.Error and if true, check the db.ErrorMessage as it will give you more information as to why it failed.

If I had to guess, I'd say that the user test doesn't have permission from your IP address. But the error message will give you the reason why it couldn't connect.

connect to mysql server using realbasic

3 Answers3