Connecting To MySql Database Through C# For Login -

i have searched everywhere , cannot find solution.

basically. have created mysql database. have referenced mysql connector project. can connect, says "host: {ip address} not allowed connect mysql server". fixed allowing remote connections everywhere, heard dangerous do.

i trying make software users login before can use software (and maybe other stuff... point trying use mysql connect .net application). safe allow mysql connections ip address? if somehow reversed engineered code, have access database credentials.

is there other solution?

i sure many of agree on not write db connection string in application give end user.

also risky connection ip db.

the best way create web service , call authenticate user , save both;

1. no need provide connection string in application.
2. as web service run on same pc or other single pc no need allow remote connection ip.