[thelist] Security problem using ASP.NET and MySQL
James Hardy
evolt at weeb.biz
Thu Jun 2 12:36:04 CDT 2005
Casey Crookston wrote:
>I'm new to using MySQL This project is too big for Access and the "free"
>aspect of MySQL was very inticing. I'm still just trying to get the
>connection figured out. MyODBC is installed on the server and the DSN has
>been created. When I push the TEST button in the Connector/ODBC window on
>the server it comes back positive. While in development, the database has
>no password. For whatever reason, it keeps telling me my access is denied.
>
>I would assume the problem is the lack of a password? So my question is, 1)
>Does the password need to be set on the database, on the DSN, or both. 2)
>If the database or both, how do you set a password in a MySQL database?
>
>Thanks!
> <snip code>
>
It will initially need to be set on the server. MySQL Administrator[1]
is a good way of doing this. Once you have set a password for user
"myuser" you will need to add that into your connectionstring on the line
"PASSWORD=;" & _
you appear to be using a DSN-less connectionstring so you might as well
delete the DSN to avoid confusion.
[1] http://www.mysql.com/products/administrator/
More information about the thelist
mailing list