MySQL

Setup log

This is a developers log file, created on the fly, not meant to enjoy a reader, but to catch knowhow, to be digged out in eventual later odd circumstances.

Make it start

(Session 20100310.1711)

(This session is not documented fully, only by a few intermediate stops)

Three most relevant help screens may be in 'chronological' order mysqld.exe (no help), mysql.exe -? , mysqladmin.exe .

We study a tutorial: http://dev.mysql.com/tech-resources/articles/mysql_intro.html ( png pdf) .

phpMyAdmin does not want start for a user without password (screenshot # 20100322.1941). We have set one. But this works not exactly like told in the tutorial.

Setting a password works not as simple as we expect.

We try all combinations to access the database, but something seems wrong. More ideas might be found in Windows Post-Installation Procedures [ pdf png ]

We were lost. We abandon our workspace and checkout newly, to have the version before the unhappy password.

Now the password looks better.

When running our usb webstack first time on a station where it has not yet been run before, of course there were several issues. We had to tinker e.g. the PHP path environment variable (chapter PHP Setup Details).

A major issue was how to deal with a MySQL service already running on this station. The MySQL we encountered, came from a former XAMPP installation.

The symptom was unimpressive: When running our mysql-startup.bat batchfile, mysqld appeared shortly in the Taskmanager, and immediately disappeared whithout any error message.

The curious thing, which cost me some time to find the issue, was: The XAMPP mysqld shows up in the Windows Services, but not in the Taskmanager. The USB mysqld shows up in the Taskmanager, but not in the Windows Services.

In the Windows Services window, logged-in as Administrator, we were able to switch the XAMPP MySQL Service on and off, but that was not enough. We had to uninstall it!

For this job helped us greatly a batch file we found in the XAMPP program folder: mysql_uninstallservice.bat.

Succeeding to uninstall the XAMPP MySQL service.

The question remaining: Will it be possible to run two such MySQL instances side by side?

.

.

.