MySql Replication - Error 1045

Fighting with a simple test-bed MySql replication between 2 Ubuntu 10.04 LTS servers.

It turned out you need to use the domain name, not the IP address when specifying the MASTER_HOST in the following MySql command on the Slave:

CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='[username]', MASTER_PASSWORD='[password]', MASTER_LOG_FILE='mysql-bin.NNNNNN', MASTER_LOG_POS=N;

VWD + ASP.NET + MySql + parameterized queries

As you'll know, MS-SQL-Server uses parameter names beginning with '@' in parameterized queries, whilst MySql uses a single '?' for each parameter.

Whilst struggling to get Visual Web Designer 2010 Express to recognise parameterized MySql queries, I hit on the following technique:

VWD 2010 Express + MySql Connector/Net

Anyone trying to link the MySql Connector/Net connector into an ASP.NET site using the (free) Visual Web Developer 2010 Express?

Well, I found out the hard way that it is not compatible. Installed the Connector/ODBC version, and I was able to connect successfully.

From dev.mysql.com: "Note that MySQL Connector/Net does not currently support Express versions of Microsoft products, including Microsoft Visual Web Developer."

Pirate Saablogos

Check out my Saab-themed hack of the addictive "PiratePigs" game written in Enyo js framework wrapped round NME.


Credits:
NME
developer.palm