StartServer() function throws exception if there is already MySqlServer Instance running about mysql.server

[stumpdk]

Hi,
When you are using a test running on a system with an existing MySQL server, you have to use another port than the default (3306).
You can start the server using another port like this: MySqlServer.StartServer(int serverPort):

Let me know if it helps you.

[NazmiAltun]

Hello,
I've tried it as ;

dbServer.StartServer(3316);

and with some another different ports , but still throws exception. It works when i manually stop MySql service from Service Management.

Edit : I am using MySQL Server 5.7

[NazmiAltun]

Sorry, my comment is misleading. When I've changed the port, it doesn't throw exception on StartServer function anymore. I throws error at following line ;

MySqlHelper.ExecuteNonQuery(dbServer.GetConnectionString(), "CREATE DATABASE TestDataBase;");

And this is the exception message :

{"Authentication to host '127.0.0.1' for user '' using method 'mysql_native_password' failed with message: Access denied for user ''@'localhost' (using password: NO)"}

[NazmiAltun]

Ok , i've found a solution ;
Problem is connection string that returns from function ;

dbServer.GetConnectionString()

This function returns connection string as ;

Server=127.0.0.1;Port=3316;Protocol=pipe;

I assume when you add "Protocol=pipe" to connection string, it tries to connect to MySql Instance that is already installed rather than the one we create for testing.

When I set connection string manually as ;

...
dbServer = MySqlServer.Instance;
dbServer.StartServer(3316);
MySqlHelper.ExecuteNonQuery("Server=127.0.0.1;Port=3316;", "CREATE DATABASE TestDataBase;");
.....

It worked