Unable to Connect to MySQL Server

Help
#1

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

#2

Hi @jheynalzaro17

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

Thanks
Ashwin S

#3

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.

#4

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

Thanks
Ashwin S

#5

image

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

#6

Hi @jheynalzaro17

This is ok

Where as what issue you are facing while using connect activity

Thanks
Ashwin S

#7

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

#8

Hi @jheynalzaro17

Check this

image
image911×419 14.8 KB

Thanks
Ashwin S

#9

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

#10

Hi @jheynalzaro17

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

Thanks
Ashwin S

#11

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

#12

32bit

1 Like
#13

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

#14

Hi @jheynalzaro17

Create a Data Source Name in ODBC within the control panel

Thanks
Ashwin S

#15

Im trying to do that but I get an error:

image

1 Like
#16

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

#17

@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

#18

Hi All,

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

I follow this guide:

#19

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