Home   -   Computerkurs   DemoMatrix   Editpointstatic   Folderwatcher   Gipsydrive   Licenses   Shrinkseries   V4   More...  

Apache   Chrome   Firefox   MySQL   NetBeans   Niwa   Opera   OXID   PHP   Ruby   SharpDevelop   Subversion   Tools  

Previous page Home chapter Next page

Dolphin

Trilo - Downtown - Gipsydrive

MySQL

Project status:Running
Platform:Windows
Dependencies:None

Introduction

This is a running set of independend and cooperating web and desktop applications or components, such as Apache or other webservers -- running from a Subversion workspace on an USB drive on any Windows station.

How to run it

. . .

Q & A

. . .

Links

. . .

Technical details

. . .

Accessing MySQL from the applications ...

Tutorial on Codeplanet (2006-April-08'11:01) Verbindung zum MySQL-Server mit C#. Tells the basics on how to access and use the MySQL.Data.dll connector. (20111007°1531) Tutorial

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 in mysqladmin
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.

Setting a better password with mysqladmin
Now the password looks better.

 

Link

Collission with other MySQL instance

(Session 20100327°0001)

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 .

Uninstalling the XAMPP MySQL service.
Succeeding to uninstall the XAMPP MySQL service.

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

 

.

.

.

Imprint : www.trilo.de