无效的用户名/密码 [英] invalid username/password

问题描述

我正在用 C# 连接到 MySQL 数据库.我使用 100% 正确的用户名和密码，但我得到无效的用户名/密码或错误号 1045.我尝试删除数据库和用户并重新创建所有这些并在 cpanel 中分配所有权限，但失败了.它适用于我的计算机本地主机(虚拟服务器).试了这么多次.请帮忙.我的代码是

I am connecting to MySQL database in C#. I am using 100 percent correct user name and password but I get invalid username/password or error no 1045. I have tried deleting the database and users and recreated all these and assigned all permissions in cpanel but failed. It works on my computer localhost(virtual server). Tried so many times. please help. My code is

        string myConnectionString = @"server=mydomain.co.uk;userid=MyUserID;
        password=PasswordOfUser;database=databasename";
        MySqlConnection conn = null; 
        try
        {
            //MySqlConnection 
            conn = new MySqlConnection(myConnectionString);
            conn.Open();
            MessageBox.Show("OK");
            conn.Close();
        }
        catch (MySqlException ex)
        {
            switch (ex.Number)
            {
                case 0:
                    MessageBox.Show("Cannot connect to server.  Contact administrator");
                    break;
                case 1042:
                    MessageBox.Show("Can't get hostname address. Check your internet connection. If does not solve, contact Administrator");
                    break;
                case 1045:
                    MessageBox.Show("Invalid username/password");
                    break;
            }
        }

推荐答案

通过添加主机(IP OR DOMIAN etc)在 cpanel 中启用远程访问

这篇关于无效的用户名/密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！