MySQL ver 5.0 w/ PHPmyadmin
I finally couldn’t resist the urge to try out MySQL 5.0 so I took some time out and downloaded it from it’s makers. I have to say that I’m not disappointed… not to mention impressed with the way they made it easier to install in Windows…
I started out with ver 3.23.xx and that was not an easy thing to install… namely because the manual at that time was as intuitive as a chinese instruction manual and mostly linux centered when it came to giving out examples (you could just imagine how us Windows based sysads had a hard time figuring things out)…
I remembered having to draft an installation manual for the office to make it easier for everybody… I think it took me about a week to figure things out… then again, that was because I had a day job to contend with at that time… I was also field testing at that time to see if it could really out perform our current implementations of other databases, so that’s one reason why it took so long too…
Ver 5.0 makes it so much easier… looking at how the installation goes… they really tout the use of INNODB… by giving you an option to choose what the default table type will be when table type is not specified in the table create process. Before it would always equate to MyISAM.
It can be configured to run as a developers PC (low memory), pure database PC (this thing does nothing but crunch data) as well as something in between those two options during install. Hey did I mention that it’s configured automatically to run as a service in Windows? Before you had to manually execute “mysqld-nt –install”, inorder for it to be registered as a service… This time you can also choose what service name it should use… I used a different name for ver 5.0 so that I can still keep my original installation of mysql.
You also have the option to choose what type of database it should be configured as during the install process, OLTP or OLAP (Short Writes/Reads/HighUser volume or Long Reads/Writes/Low user volume)… that definitely makes tweaking easier…
One problem I encountered was getting it to work with PHPmyadmin. I’d get roadblocked by this message on my browser.
Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Googling the problem I found some solutions that didn’t work. I turns out that the problem is rooted with mysql changing the password hashing algorithm used during user/password authentication which made it incompatible with older client versions. The fix was to update the password in mysql.user table. Instead of using the password() function, to use old_password() instead:
update mysql.user set password = old_password(
) where user = ‘ ‘;
With that problem finally behind me, I look forward to trying out stored procedures, views and triggers… thank you mysql for this fine product… hope Oracle doesn’t decide to trip you up via INNODB 