I have an xampp installed in PC1. My project is in PC2. I changed my connection string's server from localhost into this:
<add name="VoteContext" providerName="MySql.Data.MySqlClient"
connectionString="server=192.168.0.124; database=voting; user id=root;password=;/>
But when I run with debug my project, it says:
PC2 is not allowed to connect to this MariaDB server
I also have an xampp installed in PC2 with the same db. When I use this connection string,
<add name="VoteContext" providerName="MySql.Data.MySqlClient"
connectionString="server=localhost; database=voting; user id=root;password=;"/>
it goes fine.
But when I change the "localhost" into PC2's ipaddress,
<add name="VoteContext" providerName="MySql.Data.MySqlClient"
connectionString="server=192.168.0.123; database=voting; user id=root;password=;"/>
the same error message appears.
I'd like to connect my PC2 project to PC1 db.
I already configured my xampp settings httpd-xampp.conf and I can access the xampp of PC1 using my browser in PC2 (192.168.0.124/phpmyadmin) and I successfully inserted a record but still, I couldnt connect to PC1 server with my visual studio project.
What I have tried:
<add name="VoteContext" providerName="MySql.Data.MySqlClient"
connectionString="server=192.168.0.124; database=voting; user id=root;password=;/>