[C#] mysql povezava

                MySqlConnection Conn2 = new MySqlConnection("Server=127.0.0.1;Database=test;Uid=root;Pwd=geslo;");
                MySqlDataReader myReader;

                Conn2.Open(); 
                MySqlCommand mycommand = new MySqlCommand("SELECT * FROM poskus;", Conn2);
                myReader = mycommand.ExecuteReader();
                    
                    while (myReader.Read())
                    {
                        MessageBox.Show("hugo");
                    }
                Conn2.Close();

Step # 5 Grant access to remote IP address

# mysql -u root -p mysql

Grant access to new database

If you want to add new database called foo for user bar and remote IP 162.54.10.20 then you need to type following commands at mysql> prompt:

mysql> CREATE DATABASE foo;

mysql> GRANT ALL ON foo.* TO bar@'162.54.10.20' IDENTIFIED BY 'PASSWORD';

Grant access to existing database

Let us assume that you are always making connection from remote IP called 162.54.10.20 for database called webdb for user webadmin then you need to grant access to this IP address. At mysql> prompt type following command for existing database:

mysql> update db set Host='162.54.10.20' where Db='webdb';

mysql> update user set Host='162.54.10.20' where user='webadmin';

Step # 5: Logout of MySQL

Type exit command to logout mysql

mysql> exit