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


Trilo - Downtown - Gipsydrive


Project status:Applicable


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 MySQL

Here the steps you need to master, until you see and process data in a grid on the front end.


What alternatives do exist? There is e.g. MariaDB, PostgreSQL, SQLite, MS-SQL 20160712°1641, Oracle, 20160712°1642, Paradox, and others.


. . .

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. It is not meant to enjoy a reader, just to catch knowhow, to be digged out in possible later odd circumstances.

Make MySQL start

(Session 20100310.1711)

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

Three most relevant help screens in chronological order may be those three: (1) The MySQL start console mysqld.exe with no help messages at all, (2) the MySQL console called with the help parameter mysql.exe -? , (3) the MySQLAdmin console mysqladmin.exe .

First, I study this tutorial : http://dev.mysql.com/tech-resources/articles/mysql_intro.html (png) (This page is no more online 20160712°1631) .

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.



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 remaining question is as follows. Will it be possible to run two such MySQL instances side by side? The answer is yes, as you may find in GipsyCockpit batch files.



Datenschutz Imprint

http://downtown.trilo.de/appsmysql.html © 2008 - 2018 Trilo Software e.K.   (20100825°2143)