Unable to Connect to MySQL Server

Hi,

I made a website in a local server using Xampp. We’re able to access the wensite by http://computer_name.

I want to access the MySQL server thru Uipath. And I have installed MySQL Connector/ODBC. However, I am unable to connect to MySQL server. I get the error:

“Lost connection to MySQL server at 'reading initial communication packet”

I am able to create a Data Source using the Server computer where xampp is installed (using localhost as TCP/IP server; Port 3306) but I can do it from a different computer.

I can connect using ‘localhost’ but not the Server IP or name.

Any ideas on what I am doing wrong?

Thanks

Hi @jheynalzaro17

In My Sql manually are you able to configure with localhost and connect

Thanks
Ashwin S

Yes. I am able to connect localhost on the Server computer. But using my computer (Client) I can’t, tried to use ‘localhost’ or the server name.

Hi @jheynalzaro17
can you share the screenshot of the connection string

Thanks
Ashwin S

image

This is the config that worked on the Server Computer. But if I use the Server name and not localhost the error occurs.

Hi @jheynalzaro17

This is ok

Where as what issue you are facing while using connect activity

Thanks
Ashwin S

Well, actually I need to create the Data Source from my computer to the server which I cant.

I can create using the Server Computer. Should I use this in Uipath Connect Activity?

When I try to connect to the Data Source it doesnt show up under the Data Source name:
image

Hi @jheynalzaro17

Check this

Thanks
Ashwin S

Yes, I chose Microsoft ODBC Data Source… Which is why I get to the screenshot I pasted on the previous comment.

Hi @jheynalzaro17

Try to given the data source name and username and password and after that test connection

Thanks
Ashwin S

hi @jheynalzaro17
which odbc version you are using 32bit or 64bit

32bit

1 Like

Hi @AshwinS2, I cant enter Data Source name… it has to load…and nothing shows up on the dropdrown…

Hi @jheynalzaro17

Create a Data Source Name in ODBC within the control panel

Thanks
Ashwin S

Im trying to do that but I get an error:

image

1 Like

hi
please refer the following
https://web.synametrics.com/mysql.htm

@jheynalzaro17
also this problem can be occurs due to your firewall. if use "PCTools Firewall Plus and it wasn’t allowing full access to MySQL. Once I changed that it was fine.
further check with your network and admin

Hi All,

This is fixed… what I needed to create was another user under Privileges in phpmyAdmin…

I follow this guide:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.