@yoshikazu0110 (h y)

Are you sure you want to delete the question?

If your question is resolved, you may close it.

Leaving a resolved question undeleted may help others!

We hope you find it useful!

Unknown database 'DBname'の解決

Unknown database 'DBname'の解決

以下の発生しているエラーの解決がなかなかできず困っています。

発生している問題・エラー

Authentication to host 'localhost' for user 'admin' using method 'mysql_native_password' failed with message: Unknown database 'sakosys'

または、問題・エラーが起きている画像をここにドラッグアンドドロップ

環境

■OS
Windows 10 Pro

■Visual Studio 2019 Community
.Net Core3.1
MySql.Data(8.2.26)

■MySql Server
8.0.26

該当するソースコード(C#)

using MySql.Data.MySqlClient;
using System;

namespace PlayGround3
{
    class Program
    {
        static void Main(string[] args)
        {
            string server = "localhost";
            string database = "sakosys";
            string uid = "admin";
            string pwd = "admin";
            string port = "3306";
            string connString = string.Format("Server={0};Database={1};Uid={2};Pwd={3};Port={4};", server, database, uid, pwd,port);

            MySqlConnection conn = new MySqlConnection();
            conn.ConnectionString = connString;

            try
            {
                conn.Open();
                Console.Write("接続成功!!");
            }
            catch (MySql.Data.MySqlClient.MySqlException e)
            {
                Console.Write(e.Message);
                conn.Close();
            }

        }
    }
}
1 likes

1Answer

Your answer might help someone💌