Tennant datasource connection strings

[chihabhajji]

Can someone please provide me a valid example connection string for MMSQL and MYSQL, every time I try to add a new tenant i get the following exception ;
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the inst ance name is correct and that SQL Server is configured to allow remote connections.

[fretje]

Here you go:

https://www.connectionstrings.com/sql-server/
https://www.connectionstrings.com/mysql/

[chihabhajji]

those are the ones i'm using, i'm using XAMPP and i have enabled pipes,
Server=127.0.0.1;Database=gate;User Id=root;Password=myPassword;
gives me the same exception, MSSQL and Oracle work fine

[fretje]

Sorry can't help you there... no experience with mysql... but can you connect with another tool (the SSMS equivalent for mysql) using the same connectionstring?

[chihabhajji]

the equivalent is phpmyadmin, and it doesnt provide management for the server itself, its just a ui for managing the databases, thank you anyway, ill try postgres
thank you 😁
side question, i tried assigning an account to a new tenant using his email but i couldnt login even tho i provided the right password and tenant id and checked the db and found the user info there (new tenant db)

[iammukeshm]

MySQL

"DatabaseSettings": {
    "ConnectionString": "server=localhost;uid=root;pwd=root;database=defaultRootDb;Allow User Variables=True",
    "DBProvider": "mysql"
  }

MSSQL

"DatabaseSettings": {
    "DBProvider": "mssql",
    "ConnectionString": "Data Source=(localdb)\\mssqllocaldb;Initial Catalog=rootTenantDb;Integrated Security=True;MultipleActiveResultSets=True"
  }

[chihabhajji]

i was asking for connection string to use in the front end to add tenants not config connection strings