Wsrtjtyk

I have a database to manage a school (students and classes).
I have a class with the code to connect to the DataBase and then I call the functions in the main program.
When I try to interact with the DataBase, it warns me that it could not connect to the DataBase or it exceeded the connection time.
I tried to add an ssslmode but it didn't work. I also tried to add a port but it didn't work.

Code for the class:

public class ligacao

    {

        public MySqlConnection connection;

        string server;

        public string data_base;

        string user_id;

        string password;



        public void inicializa()

        {

            server = "localhost";

            data_base = "escola";

            user_id = "root";

            password = "usbw";

            string connection_string;

            string sslmode = "none";

            connection_string = "SERVER=" + server + ";" + "DATABASE=" + data_base + ";" + "UID=" + user_id + "PASSWORD=" + password + ";" + "SslMode=" + sslmode + ";";

            connection = new MySqlConnection(connection_string);

        }



        public bool open_connection()

        {

            try

            {

                connection.Open();

                return true;

            }

            catch (MySqlException ex)

            {

                switch (ex.Number)

                {

                    case 0: MessageBox.Show("Couldn't connect t DataBase."); break; // couldn't connect to database

                    case 1042: MessageBox.Show("Exceded the connection time"); break; // exceeded the connection time

                    case 1045: MessageBox.Show("Username/password are incorrect"); break;

                }

                return false;

            }

        }

        public bool close_connection()

        {

            try

            {

                connection.Close();

                return true;

            }

            catch (MySqlException ex)

            {

                MessageBox.Show(ex.Message);

                return false;

            }

        }

    }

Code for the Main Program:

public partial class consultas : Form

    {

        ligacao x = new ligacao();



        public consultas()

        {

            InitializeComponent();

            x.inicializa();

        }



        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

        {



        }



        private void consultas_Load(object sender, EventArgs e)

        {

            //define query

            string query = "SELECT designacao FROM disciplinas";

            //open connection

            if (x.open_connection())

            {

                //create the comand and associates the query with the connection through the connector

                MySqlCommand cmd = new MySqlCommand(query, x.connection);

                //create datareader and execute the command

                MySqlDataReader dataReader = cmd.ExecuteReader();

                //show data in combobox1

                if (dataReader.Read())

                {

                    comboBox1.Items.Add(dataReader["designacao"]);

                }

                //close dataReader

                dataReader.Close();



                //close connection

                x.close_connection();

            }



            //define query

            string queryBI = "SELECT bi FROM alunos";

            //open connection

            if (x.open_connection())

            {

                //create the commando and associate the query with the connection through the constructor

                MySqlCommand cmd = new MySqlCommand(queryBI, x.connection);

                //create datareader and execute the command

                MySqlDataReader dataReader = cmd.ExecuteReader();

                //show data in combobox1

                if (dataReader.Read())

                {

                    comboBox1.Items.Add(dataReader["bi"]);

                }

                //close dataReader

                dataReader.Close();



                //close connection

                x.close_connection();

            }

        }

    }

I think there is something wrong with your connection string. Try using the MySqlConnectionStringBuilder:

MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();

builder.Host = "localhost";

builder.UserId = "root";

builder.Database = "escola";

builder.Password = "usbw";

connection = new MySqlConnection(builder.ConnectionString);

Try This :

   connection_string  = @"Data Source = " + server  + "; Initial Catalog = " + data_base  + "; Integrated Security=True;uid=myUser;password=myPass;";