Hi everyone!
I encounter this error when I try to connect to the mysql database, here is the data of my connection. can someone help me to see more clearly?
here is the error message:
- MySql.Data.MySqlClient.MySqlException
- HResult = 0x80004005
- Message = Unable to connect to any of the specified MySQL hosts.
- Source = MySql.Data
- Procedure tree:
- at MySql.Data.MySqlClient.NativeDriver.Open ()
- at MySql.Data.MySqlClient.Driver.Open ()
- at MySql.Data.MySqlClient.Driver.Create (MySqlConnectionStringBuilder settings)
- at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection ()
- at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection ()
- at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver ()
- at MySql.Data.MySqlClient.MySqlPool.GetConnection ()
- at MySql.Data.MySqlClient.MySqlConnection.Open ()
- at DeviseExchange.login.button1_Click (Object sender, EventArgs) in C: \ Users \ HP \ source \ repos \ CurrencyExchange \ CurrencyExchange \ login.cs: line 91
- at System.Windows.Forms.Control.OnClick (EventArgs e)
- at System.Windows.Forms.Button.OnClick (EventArgs e)
- at System.Windows.Forms.Button.OnMouseUp (MouseEventArgs mevent)
- at System.Windows.Forms.Control.WmMouseUp (Message & m, MouseButtons button, Int32 clicks)
- at System.Windows.Forms.Control.WndProc (Message & m)
- at System.Windows.Forms.ButtonBase.WndProc (Message & m)
- at System.Windows.Forms.Button.WndProc (Message & m)
- at System.Windows.Forms.NativeWindow.DebuggableCallback (IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
- at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW (MSG & msg)
- at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop (IntPtr dwComponentID, Int32 Reason, Int32 pvLoopData)
- at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner (Int32 reason, ApplicationContext context)
- at System.Windows.Forms.Application.ThreadContext.RunMessageLoop (Int32 reason, ApplicationContext context)
- at DeviseExchange.Program.Main () in C: \ Users \ HP \ source \ repos \ CurrencyExchange \ CurrencyExchange \ Program.cs: line 19
-
- Internal exception 1:
- MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
and my connection class:
- namespace DeviseExchange
- {
- class connexion
- {
- public static string getconnexion() {
- return "Server= 91.216.107.162;Database=afasi717346;uid =afasi717346;Password=zv63XCDH";
- }
- }