这是C#服务器端定义的连接服务器相关的代码,出错位置是conn.Open();
MySqlConnection conn = new MySqlConnection
("server=188.131.xx.xx;User Id=root;password=123456;Database=da_main;Charset=utf8");
conn.Open();
运行后错误提示为:
MySql.Data.MySqlClient.MySqlException:“Authentication to host '188.131.xx.xx' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'182.40.249.195' (using password: YES)”
内部异常:
MySqlException: Access denied for user 'root'@'182.40.249.195' (using password: YES)
PS:188.131.xx.xx 是我个人把服务器的后两位给屏蔽了,我本机的代码里写的是对的,怕有人会恶意攻击我的云服务器.
下图是mySql数据的用户表的截图
下面是我云服务器里面的安全组相关的配置:
如果老师或同学需要我的ip我再给您发.
关联的课程是plane老师的暗黑战神