Lost your admin account? Use the following SQL statement to change it:
UPDATE user SET user_password = MD5( CONCAT( user_id, '-', MD5( 'NEWPASSWORDHERE' ) ) ) WHERE user_id =1
It took me a few minutes to figure this one out, a simple MessageBox won’t do as that’s a blocking call. Then I stumbled upon this old msdn blog article:
http://blogs.msdn.com/oldnewthing/archive/2006/09/25/770536.aspx.
Basically I had a requirement for a certain project to display some sort of progress message to the end user while performing complicated logic that could take 10seconds to a couple minutes and this had to be done from within a replacement GINA for WinXP. The above article was of extreme help in understanding the way message passing works in Win32.
DialogBox (with reference to the callback function)
It’s been a while since I’ve messed around with asp.net web.config files. Here’s a tip for anyone trying to use the mysql connector with asp.net. You need to add the following to your web.config or it will bitch to you about trust levels.
<system.data>
<DbProviderFactories>
<clear />
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,
Version=6.0.2.0, Culture=neutral,
PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories>
</system.data>
GoDaddy has modified their medium trust environment to use the connector. All new connectors are compiled to accept partially trusted callers. It is important to note that the version in your web.config must match the version of the connector DLL.