Login Register






C#, connect to MySQL database filter_list
Author
Message
C#, connect to MySQL database #1
Hello,

I've installed the MySql.ConnectorNET.Data package and even some others to test.

       
Code:
           MySql.Data.MySqlClient.MySqlConnection conn;            string myConnectionString;            myConnectionString = "server=sql212.ihostfull.com;uid=uoolo_lolno;" +                "pwd=lolno;database=uoolo_lolno_test;";            try            {                conn = new MySql.Data.MySqlClient.MySqlConnection();                conn.ConnectionString = myConnectionString;                conn.Open();                MessageBox.Show("This shit finally working.");            }            catch (MySql.Data.MySqlClient.MySqlException ex)            {                MessageBox.Show(ex.Message);            }

Problem is, it doesn't work.
It returns this error.
Code:
Unable to connect to any of the specified MySQL hosts.

Does anyone know how to fix it?

I literally copied it from here and it doesn't work.
https://dev.mysql.com/doc/connector-net/...-open.html
[Image: oAqtc2l.png]

Reply

RE: C#, connect to MySQL database #2
(11-18-2016, 04:32 PM)Skryptec Wrote: Hello,

I've installed the MySql.ConnectorNET.Data package and even some others to test.

       
Code:
           MySql.Data.MySqlClient.MySqlConnection conn;            string myConnectionString;            myConnectionString = "server=sql212.ihostfull.com;uid=uoolo_lolno;" +                "pwd=lolno;database=uoolo_lolno_test;";            try            {                conn = new MySql.Data.MySqlClient.MySqlConnection();                conn.ConnectionString = myConnectionString;                conn.Open();                MessageBox.Show("This shit finally working.");            }            catch (MySql.Data.MySqlClient.MySqlException ex)            {                MessageBox.Show(ex.Message);            }

Problem is, it doesn't work.
It returns this error.
Code:
Unable to connect to any of the specified MySQL hosts.

Does anyone know how to fix it?

I literally copied it from here and it doesn't work.
https://dev.mysql.com/doc/connector-net/...-open.html

Everything seems ok.
Does the mySQL server allow your user to access it from your ip address?

Reply

RE: C#, connect to MySQL database #3
(11-18-2016, 04:37 PM)Pikami Wrote:
(11-18-2016, 04:32 PM)Skryptec Wrote: Hello,

I've installed the MySql.ConnectorNET.Data package and even some others to test.

       
Code:
           MySql.Data.MySqlClient.MySqlConnection conn;            string myConnectionString;            myConnectionString = "server=sql212.ihostfull.com;uid=uoolo_lolno;" +                "pwd=lolno;database=uoolo_lolno_test;";            try            {                conn = new MySql.Data.MySqlClient.MySqlConnection();                conn.ConnectionString = myConnectionString;                conn.Open();                MessageBox.Show("This shit finally working.");            }            catch (MySql.Data.MySqlClient.MySqlException ex)            {                MessageBox.Show(ex.Message);            }

Problem is, it doesn't work.
It returns this error.
Code:
Unable to connect to any of the specified MySQL hosts.

Does anyone know how to fix it?

I literally copied it from here and it doesn't work.
https://dev.mysql.com/doc/connector-net/...-open.html

Everything seems ok.
Does the mySQL server allow your user to access it from your ip address?

Do you mean Remote MySQL Access?
[Image: oAqtc2l.png]

Reply

RE: C#, connect to MySQL database #4
(11-18-2016, 04:38 PM)Skryptec Wrote:
(11-18-2016, 04:37 PM)Pikami Wrote:
(11-18-2016, 04:32 PM)Skryptec Wrote: Hello,

I've installed the MySql.ConnectorNET.Data package and even some others to test.

       
Code:
           MySql.Data.MySqlClient.MySqlConnection conn;            string myConnectionString;            myConnectionString = "server=sql212.ihostfull.com;uid=uoolo_lolno;" +                "pwd=lolno;database=uoolo_lolno_test;";            try            {                conn = new MySql.Data.MySqlClient.MySqlConnection();                conn.ConnectionString = myConnectionString;                conn.Open();                MessageBox.Show("This shit finally working.");            }            catch (MySql.Data.MySqlClient.MySqlException ex)            {                MessageBox.Show(ex.Message);            }

Problem is, it doesn't work.
It returns this error.
Code:
Unable to connect to any of the specified MySQL hosts.

Does anyone know how to fix it?

I literally copied it from here and it doesn't work.
https://dev.mysql.com/doc/connector-net/...-open.html

Everything seems ok.
Does the mySQL server allow your user to access it from your ip address?

Do you mean Remote MySQL Access?

Yeah. Some hosting providers disallow remote access to MySQL, some of them require you to white-list your ip for remote connections

Reply

RE: C#, connect to MySQL database #5
(11-18-2016, 04:41 PM)Pikami Wrote:
(11-18-2016, 04:38 PM)Skryptec Wrote:
(11-18-2016, 04:37 PM)Pikami Wrote: Everything seems ok.
Does the mySQL server allow your user to access it from your ip address?

Do you mean Remote MySQL Access?

Yeah. Some hosting providers disallow remote access to MySQL, some of them require you to white-list your ip for remote connections

Fuck me, man. Do you know any free host that allows that
[Image: oAqtc2l.png]

Reply

RE: C#, connect to MySQL database #6
(11-18-2016, 04:43 PM)Skryptec Wrote:
(11-18-2016, 04:41 PM)Pikami Wrote:
(11-18-2016, 04:38 PM)Skryptec Wrote: Do you mean Remote MySQL Access?

Yeah. Some hosting providers disallow remote access to MySQL, some of them require you to white-list your ip for remote connections

Fuck me, man. Do you know any free host that allows that

Sadly - No I do not.
Most of the free hosting companies disallow remote access to MySQL, and that's not the only limitation.
The best thing to do is to rent some VPS or pay for webhosting, it does not cost that much.
But if you don't want to spend money you can always make a PHP API that handles the requests and manages the database.

Reply

RE: C#, connect to MySQL database #7
(11-18-2016, 04:51 PM)Pikami Wrote:
(11-18-2016, 04:43 PM)Skryptec Wrote:
(11-18-2016, 04:41 PM)Pikami Wrote: Yeah. Some hosting providers disallow remote access to MySQL, some of them require you to white-list your ip for remote connections

Fuck me, man. Do you know any free host that allows that

Sadly - No I do not.
Most of the free hosting companies disallow remote access to MySQL, and that's not the only limitation.
The best thing to do is to rent some VPS or pay for webhosting, it does not cost that much.
But if you don't want to spend money you can always make a PHP API that handles the requests and manages the database.

Problem is, I'm bad at PHP
[Image: oAqtc2l.png]

Reply

RE: C#, connect to MySQL database #8
(11-18-2016, 04:52 PM)Skryptec Wrote:
(11-18-2016, 04:51 PM)Pikami Wrote:
(11-18-2016, 04:43 PM)Skryptec Wrote: Fuck me, man. Do you know any free host that allows that

Sadly - No I do not.
Most of the free hosting companies disallow remote access to MySQL, and that's not the only limitation.
The best thing to do is to rent some VPS or pay for webhosting, it does not cost that much.
But if you don't want to spend money you can always make a PHP API that handles the requests and manages the database.

Problem is, I'm bad at PHP

I could help you out if you want...

Reply

RE: C#, connect to MySQL database #9
(11-18-2016, 04:54 PM)Pikami Wrote:
(11-18-2016, 04:52 PM)Skryptec Wrote:
(11-18-2016, 04:51 PM)Pikami Wrote: Sadly - No I do not.
Most of the free hosting companies disallow remote access to MySQL, and that's not the only limitation.
The best thing to do is to rent some VPS or pay for webhosting, it does not cost that much.
But if you don't want to spend money you can always make a PHP API that handles the requests and manages the database.

Problem is, I'm bad at PHP

I could help you out if you want...

Please DM me.
[Image: oAqtc2l.png]

Reply

RE: C#, connect to MySQL database #10
I could make an sql server for you, I somehow like you, so just ask me for a server and I will dedicate part of mine to you
Jabber: fuhrer@0day.ms
I2P-Bote:
Code:
lLX7Z6LDnFbHc67Kv9GR3YCDAfSot7vNy1g2jwUNFhKGgwksYk8Y6bGQnRRiMfQHQvSM0yheDlWEhFpmSoW7MH9oYSrNVHoMbwRxu2jib2DS-OzbmUKlVzmOuyfRARnK7vinu78aYhCqH9eeJhwvk4JNtBEhD2K1hzpGeXxkDu3Zct

Reply