not able to connect mysql server while installing the solidcp
i have installed mysql sever 2008 in my windows server. but i am unable to install solidcp due to database not connected. while connecting the database i am getting error( Sql server does not exist or access denied)
SolidCP does require MsSQL for its database.
I'm also getting the same error.
I have MsSQL2016 express installed
I follow your video, and remove the SQLexpress part.
I have setup the MsSQL in default, and opened port "TCP port 1433"
Can you maybe post us a video on the setup of the MsSQL server, for refrence.
Pls add SQLEXPRESS after localhost so the issue will be resolved.
SQL Server: localhostSQLEXPRESS
In some of the ways, spacing and the order of parameters in the MySql connection string does matters. So, stick to the standard format:
MysqlConn.ConnectionString = "Server=localhost;Port=1234;Database=My_Mysql_Database;Uid=root;Pwd=root;"
If the above connection string fails, try update your c# mysql connection string as shown below (without port variable as well):
MysqlConn.ConnectionString = "Server=localhost;Database=My_Mysql_Database;Uid=root;Pwd=root;"
Or, sometime the problem could be on your windows firewall, make sure your server allow access to all port associated with your mysql database.