using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace UtentiBaseRedmineUpdater
{
    public partial class Form1 : Form
    {
        private MySqlConnection connection;
        private string server;
        private string database;
        private string user;
        private string password;
        private string port;
        private string connectionString;


        public Form1()
        {
            InitializeComponent();


            server = "89.46.111.65";
            database = "Sql1212242_1";
            user = "Sql1212242";
            password = "rrg7w60de9";
            port = "3306";

        }



        // cnn.ConnectionString = "Server=52.28.70.223,3306;Database=redmine_alteain_02;User Id=redmine_alteain_02;Password=T6MJzcUyqER7K6sS;";
        // connectionString = "SERVER=" + "52.28.70.223,3306" + ";" + "DATABASE=" + "redmine_alteain_02" + ";" + "UID=" + "redmine_alteain_02" + ";" + "PASSWORD=" + "T6MJzcUyqER7K6sS" + ";

        private void button1_Click(object sender, EventArgs e)
        {
            connectionString = String.Format("Server={0};Database={2};User Id={3};Password={4} ", server,port,database, user, password);
           connection = new MySqlConnection(connectionString);
            //  connection = new MySqlConnection("datasource=52.28.70.223;port=3306;username=redmine_alteain_02;password=T6MJzcUyqER7K6sS");


            try
            {
                connection.Open();

                MessageBox.Show("successful connection");

                connection.Close();
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}