.Net connection string to connect MySQL localhost Without Password

Question

What will be the connection string in appsettings.json file for MySQL localhost without password for root? I tried below but not working!

Server=localhost;Port=3306;Database=myDbName;Uid=root;SslMode=none

On the opposite direction, I also set password for root user using user accounts in phpMyAdmin as describe here https://stackoverflow.com/a/34562915/11276273 But no luck.

Please suggest the solution.

Thanks in advance :)

1) what is the error message you have encountered; 2) is the mysql running fine; 3) is your firewall allow the connections or not — Bagus Tesa
– Bagus Tesa, Commented Oct 1, 2019 at 10:39
@BagusTesa, 1) Unable to connect to any of the specified MySQL hosts. 2) Yes it's perfectly running without password. 3) Yes — Shivani
– Shivani, Commented Oct 1, 2019 at 11:01

fenil patel · Accepted Answer · 2019-10-02 11:35:05Z

2

Instead of localhost, try using your local IP address in the connection string and Modify the Host name to ANY HOST for root user from phpmyadmin

answered Oct 2, 2019 at 11:35

fenil patel

846 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

.Net connection string to connect MySQL localhost Without Password

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related