This time, it really took us ages to get our newest XAMPP version
out. Although we started up with BETA testing in November, new
releases of MySQL, PHP, Apache, and phpMyAdmin kept drawing the
phase out. But we did it and can now present you with a brand new
XAMPP release.
New in this version of XAMPP: Apache (2.2.0), MySQL (5.0.18), PHP
(5.1.1) and phpMyAdmin (2.7.0-pl1).
Last time, we didn't offer an update package, and there won't be
any this time, either. It isn't really possible to automate an
upgrade from Apache 2.0 to Apache 2.2, and we'd like to avoid
anyone messing up their server. So if you'd like to update to the
new Apache version, you'll need to install a new version of XAMPP
and migrate your data manually.
Download XAMPP for Windows
…
This time, it really took us ages to get our newest XAMPP version
out. Although we started up with BETA testing in November, new
releases of MySQL, PHP, Apache, and phpMyAdmin kept drawing the
phase out. But we did it and can now present you with a brand new
XAMPP release.
New in this version of XAMPP: Apache (2.2.0), MySQL (5.0.18), PHP
(5.1.1) and phpMyAdmin (2.7.0-pl1).
Last time, we didn't offer an update package, and there won't be
any this time, either. It isn't really possible to automate an
upgrade from Apache 2.0 to Apache 2.2, and we'd like to avoid
anyone messing up their server. So if you'd like to update to the
new Apache version, you'll need to install a new version of XAMPP
and migrate your data manually.
Download XAMPP for Windows
…
MySQL AB has been added to the GSA contract, providing government customers the ability to conveniently purchase and deploy MySQL database solutions. More than 8 million active installations around the world employ MySQL, including thousands of federal, state, and local government organizations such as Los Alamos National Labs, U.S. Census Bureau, U.S. Geological Survey, NASA and the Department of Defense. A new whitepaper about MySQL's use in government applications is available at http://www.mysql.com/gov
Do you have a policy of strong passwords?
Do you want to enforce it? If yes, then you may want a quick way
of checking if your users are abiding to the rules.
You can either force the users to change passwords through a
smart application, to prevent them from using weak passwords, or,
if you are assessing an existing environment, you can check the
existing passwords against a dictionary, to see if there are some
imeediately exploitable passwords among your server
accounts.
The mechanics of passwords checkingChecking passwords against a
dictionary is a costly business. It can be made more affordable
if we manage to put all the items to check in the database
itself, so that we can use the DBMS force to do our job.
What we have to do is to collect a large list of words that we
would not like our users to set as their password. Immediate
candidates are user names, both from the operating system and the
database, user full names, …
I used to make backup dumps from my webhosting MySQL databases
(I've got remote access) via the mysqldump command. All commands
that I need (including mysqlcheck to optimize and analyze all
tables) are grouped together in batch files, so it works very
conveniently. One more word to mysqlcheck - you should optimize
and analyze your tables from time to time to defragment the
tables and renew the index statistics. That makes sure that
performence doesn't suffer if many records are deleted and
inserted.
However, after making new backup files today, I realized that the
date/time data were one hour ahead of the original data. I was
wondering how this could happen, analyzed the dump file and soon
found the answer: the tz-utc option.
This option was by default set to true, so these lines were
included in the dump file:
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
…
This time, it really took us ages to get our newest XAMPP version out. Although we started up with BETA testing in November, new releases of MySQL, PHP, Apache, and phpMyAdmin kept drawing the phase out. But we did it and can now present you with a brand new XAMPP release.
New in this version of XAMPP: Apache (2.2.0), MySQL (5.0.18), PHP (5.1.1) and phpMyAdmin (2.7.0-pl1).
Last time, we didn't offer an update package, and there won't be any this time, either. It isn't really possible to automate an upgrade from Apache 2.0 to Apache 2.2, and we'd like to avoid anyone messing up their server. So if you'd like to update to the new Apache version, you'll need to install a new version of XAMPP and migrate your data manually.
Download XAMPP for Windows Download XAMPP for …
[Read more]
During the past two weeks, I've been quite busy getting to know
Ubuntu
5.10 "Breezy Badger".
(In the remainder of this entry, the phrases within parentheses
are probably a "duh!" to Ubuntu, Debian and other Linux users,
but they may be of interest to Microsoft Windows users).
Non-linuxers and Microsoft Windows users (I am a Windows XP
Professional User) particularly: Ubuntu is a Linux distribution
that comes with a "Desktop" environment. The operating system and
the applications can be controlled entirely using a Look and Feel
that is quite similar to the Microsoft Windows Environment.
Standard Ubuntu comes with the Gnome desktop environment. (I don't know how
it is for other Linux Desktop environments, and I don't even know
if there are differences between different Gnome deployments, but
I've got a desktop …
MySQL has announced a new user survey over the holidays. The survey will take about 15-20 minutes to complete and has questions about how you're using MySQL, what features are important to you and what areas you'd like MySQL to work on. This is a great way to influence our strategy and directions. It helps our product managers and engineers focus on the features that are important to you. And you may even win an iPod Nano in the process!
- MySQL: User Survey
MySQL has announced a new user survey over the holidays. The survey will take about 15-20 minutes to complete and has questions about how you're using MySQL, what features are important to you and what areas you'd like MySQL to work on. This is a great way to influence our strategy and directions. It helps our product managers and engineers focus on the features that are important to you. And you may even win an iPod Nano in the process!
- MySQL: User Survey
Some quickies that have been sitting in my blog poster for a while…
- Quick Polls are an interesting bit of the MySQL site. Look at all the interesting polls, and see where the community come from!
- I was doing a search on “migrate from Postgresql to MySQL” on Google, and all I seemed to have found in general were sites that showed how to do it the other way around!
- mytop is great. RPM distributions have
/var/run/mysqld/mysqld.sock, but it is located at/tmp/mysqld.sockif it comes out of the tarball. Run it asmytop -S /tmp/mysqld.sockif you’ve installed it from the tarball. - Seeing:
Starting MySQL * Couldn't find MySQL manager or serveras an error? Suggest you look at/etc/my.cnf, under[mysql.server], comment out (#) the …