[maj3091]

Sorry I can't be more helpful at the moment, i'm at work and no access to MySQL to try anything out.

[Kenta]

That's fine,.. Thanks anyway for the help... I will try to find some solutions regarding with this problem...

[maj3091]

Does that mean you still have the connection issues?

Have you tried connecting to the MySQL database using a standard management tool on your dev PC across the same network?

If you can connect with the management tool, then it would point at your program and vice-versa.

Something like this portable tool, should do the trick for testing purposes.

[Kenta]

Yes, unfortunately I still have the connection issue...

I already downloaded the "databaseBrowserPortable" from the link you gave to me but I don't know how to use it. forgive my ignorance... This is my first time encountering this kind of tool...

[Kenta]

I already tried it and the result was, if my connection was only at the localhost, it is connected... but if I will change it from localhost to the IP address of my server it gives me an error...

Can't connect to MySQL server on 'xxx.254.236.245' (10061) Socket error on connect. WSAGEtLastError return 10061($274D)

[maj3091]

OK, so in that case we can rule out your software for now.

How have you got your network setup as your IP Address that you've shown, looks strange?

Can you access things on the server from your dev PC, just files in general?

[Kenta]

After trying for several times, even I am connecting at the localhost using "DatabaseBrowserPortable" will give me now an error

Unable to create key 'SOFTWARE\DB SOFWARE Laboratory\Connection properties'

another problem to be solved, I think.

Do you have some idea where I can configure my MySQL database to give permission to be accessed by a user??? Even a PHP program can't connect with my server database because the server is "actively refusing"...

I thought if I can access the phpmyAdmin (forbidden by default) of my WAMPSERVER at the server side, I already have the permission to connect from its database.

[maj3091]

See if this helps at all...seems remote access is disabled by default.

[Kenta]

I used a cross-over cable (RJ45) to connect the PC and Laptop. I Installed the wampserver for the PC to act as the server. I can ping both of the end devices and I can also share some files by putting it at the shared documents. I can access also the phpmyAdmin of the server which by default, it was "Forbidden"... From the phpmyadmin, I can edit and change the values of the server's database. But my problem is, the VB app in my laptop, can't connect to the server PC even if I already created a new user account and grant all privileges.

I really don't know what is wrong with it.

[Kenta]

I already tried that linked and if I changed the bind-address to the server IP address, The WAMPSERVER won't start its services (especially MySQL services)... I visited also some sites that encountered problems like mine. Their solutions were simple and it works fine for them. I don't know why it's not for me...

[maj3091]

Yep, that's kind of where I'm at. It "should" be relatively straight forward.

Sorry mate, it's getting a little out of my area of expertise. I've done a little bit of connecting to MySQL, but it's normally just worked.

[Kenta]

Thank you for your time...

I just hope I can resolve this problem and fix this as soon as possible...

I have to go now,.. I really appreciate your help.. again... thanks a lot...

[maj3091]

OK, Lets take a step backwards and cover some of the things we've gone through....

You say you can access it through phpMyAdmin? I'm not a php developer, so have little knowledge of it and it's tools, but isn't phpMyAdmin, not for administrating PHP as opposed to MySQL?

If you run the DB Browser tool on your "server" machine, can you connect to the MySQL DB, using the Machine IP address or Name, not the local 127.0.0.1 type address?

I think we should start at the beginning, ensure things are working on the "server" and then look at expanding it out over the network, as there are too many variables at the moment.

[Kenta]

You're right,.. When I change my connection string, I can't access my database using machine IP address or its name... I really don't have the idea how to fix it...

[maj3091]

Found this statement on this site

Quote

Q16 : Why can't i connect to mysql from remote computers or from the local machine if i use my ip or domain instead of localhost ?

By default mysql is configured to only listen on the loopback interface (127.0.0.1/localhost) so connecting from it from outside or another interfaces is not posible by default as it is not something recomended or generally wanted/needed

If you change the value of bind-address in my.ini to your public ip or whatever ip/hostname you want to run mysql on , that can be accesible from the outside , and mysql will be accesible from the outside too , you can alos remove that line alltoghether and make mysql bind on all interfaces