How to connect to online MySQL database

Question

Hi guys,
I'm trying to connect from my C# windows application to MySQL database which is on my host of my website.How can i make connection? I downloaded a simple connection project from "Codeproject" but it's  not inserting anything.I also installed  MySQL connector 6.1 as required.

server = "" //local host in php

            database = "database";

            uid = "username";

            password = "pass";

            string connectionString;

            connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

            connection = new MySqlConnection(connectionString);

        }

        //open connection to database

        private bool OpenConnection()

        {

            try

            {

                connection.Open();

                return true;

            }

            catch (MySqlException ex)

            {

                //When handling errors, you can your application's response based on the error number.

                //The two most common error numbers when connecting are as follows:

                //0: Cannot connect to server.

                //1045: Invalid user name and/or password.

                switch (ex.Number)

                {

                    case 0:

                        MessageBox.Show("Cannot connect to server.  Contact administrator");

                        break;

                    case 1045:

                        MessageBox.Show("Invalid username/password, please try again");

                        break;

                }

                return false;

            }

        }

        //Close connection

        private bool CloseConnection()

        {

            try

            {

                connection.Close();

                return true;

            }

            catch (MySqlException ex)

            {

                MessageBox.Show(ex.Message);

                return false;

            }

        }

        //Insert statement

        public void Insert()

        {

            string query = "INSERT INTO Orders (name, age) VALUES('John Smith', '33')";

            //open connection

            if (this.OpenConnection() == true)

            {

                //create command and assign the query and connection from the constructor

                MySqlCommand cmd = new MySqlCommand(query, connection);

                

                //Execute command

                cmd.ExecuteNonQuery();

                //close connection

                this.CloseConnection();

            }

        }

can any one of you please tell me what to type in "server" string i tried server ip but don't work