Apache Friends Support Forum

To solve this problem is really easy. First, close all the error pop up window. An then you have to go to the traffic light picture-->show me-->stop extend server status. But you must do it quickly before the pop up message showing up again. And after that close the WinMySQLAdmin. Next time if you wanna use WinMySQLAdmin again, RUN IT AS ADMINISTRATOR. And the same problem will not happen again. Hope it's helpful.

install.bat gedrückt und dann den dienst unter bin winmysqladmin geöffnet, irgendwie hats gestern super geklappt heute schaltet wenn ich auf start service gehen zwar auf grün nen paar sekunden später aber wieder auf rot. wo kann ich mehr fehlermeldungen entlocekn, was könnte das problem sein?

[Moved by JonB to German Boards]

Hello.

First using XAMPP. My akeeba backup tool needs to use PHP 5.2. This has resulted to install previous version of XAMPP 1.6.4. There is no phpmyadmin In this version. Instead it has WinMySQLAdmin 1.4. At databeses tab of it i haven't found the mean to create db.
How can I create db in XAMPP 1.6.4?
The second question is localhost the name for host in XAMPP 1.6.4?
And the third - is root the name of superuser in XAMPP 1.6.4?

Found a solution to my problem elsewhere in this forum. To solve the problem the 3 WinMySQLAdmin files in the xampp\mysql\bin folder. Regards

Ok, I found the database root password. WinMySQLadmin is running at startup on this server, but it was throwing errors so I stopped it. I let it run long enough to see the root password in the .ini file that it lists in the application. Using that password I was able to successfully export my databases.

I uninstalled Xampp, and installed version 1.7.7. I was able to import the databases using MySQL Workbench. After resetting all root passwords, the website now comes up, but I have some errors on the mainpage. When I import the databases into the new installation of MySQL, should it modify the database to address these issues?

This issue has been done to death when 1.66 and other old versions used a deprecated WinMySQLAdmin and the advice then and now is not to use it but to use instead phpMyAdmin.

You can safely delete the 3 winmysqladmin files from \xampp\mysql\bin\ folder which will then make the Admin... button redundant in the XAMPP Control Panel - just in case you are tempted to click on it again by mistake.
Remove from the Windows Startup folder any reference to winmysqladmin.
You can also kill the process if you find it in Windows Task Manager.


Here are some posts found by using keyword winmysqladmin in an advanced forum search in the XAMPP for Windows English forum:
viewtopic.php?p=136472#p136472
viewtopic.php?p=140361#p140361
viewtopic.php?p=151856#p151856
There were many more to read if you have the time.

To set the root user password for MySQL and for accessing phpMyAdmin (both use the same root user and password) click on the Security menu item found when you type http://localhost/xampp in your browser.

Why not install a newer version of XAMPP, for instance 1.7.3, which seems to be stable and does not include winmysqladmin but links to phpmyadmin from the MySQL Admin... button in the XAMPP Control Panel.

The Admin... button for MySQL doesn't work in 1.7.4 you have to type http://localhost/phpmyadmin/ manually in your browser.

It is noted in this topic:
viewtopic.php?f=16&t=44327

Reason is the XAMPP Control Panel in 1.7.4 is very old and the Admin... button in this control panel points to winmysqladmin.exe that was very buggy and is no longer used or included in recent XAMPP versions.
Until this is corrected by the developers then you will have to connect to phpMyAdmin manually as above.

Status error and a possible solution here:
viewtopic.php?f=16&t=44320

uhhh - did you look in xampp\mysql\bin???

what tool did you use to search your drive???

Winmysqladmin is actaully a tool that is designed to work with a standalone installation Windows installation of MySQL, so it may or may not work in all cases with a XAMPP installation. (as XAMPP is registry neutral) I suspect it will be OK, but that is no reall guarantee

Do you by any chance have TWO MySQL installations on the same machine???

i am having a problem...If I try to use WinMySQLAdmin to change the ini file I get the messages again and can't perform the change, similar to Raggapants' problem. With a search I can't find anywhere a file called "my.ini" to update it.

Moin moin

Ich bin wie ihr sehen könnt neu in diesem Forum, sollte ich Standardangaben vergessen oder so, seht es mir bitte nach und weist mich drauf hin

Mein Problem ist folgendes:
Im Browser zeigt mir XAMPP auf der Startseite bereits an:

Achtung! Probleme mit dem MySQL Connector (mysqlnd) ?
Problembeschreibung: Der MySQL Server ist gestartet, aber PHP kann keine Connection zu dem MySQL Server aufbauen. [...]

Versuche ich dann phpMyAdmin zu starten kommt folgender Fehlercode:

#2054 - Connecting to 3.22, 3.23 & 4.0 servers is not supported

Klicke ich wiederum auf das Beispiel CD-Verwaltung, so wird mir folgendes angezeigt:

Warning: mysql_connect() [function.mysql_connect]: Connecting to 3.22, 3.23 & 4.0 is not supported. Server is 3.23.52-nt in C:\xampp\htdocs\xampp\cds.php on line 64

Kann die Datenbank nicht erreichen!
Läuft MySQL oder wurde das Passwort geändert?

Ja, MySQL lief, läuft und scheint auch weiterhin zu laufen.
Nein, DA wurde das Passwort noch nicht geändert. Bei der Suche nach des Fehlers Lösung legte ich LEDIGLICH den User "test_user" an und DEM gab ein Passwort. Ich weiß jetzt grad nicht mehr wo ich die Eingabe gemacht habe, sehe jedoch in WinMySQLadmin das sowohl user als auch password in der my.ini stehen. Allerdings habe ich auch noch das Programm SAM2 Broadcaster, das wiederum sich fortwährend mit "root" und OHNE Passwort auf die Datenbank zugreift, daher habe ich die Änderungen bzgl User auch NICHT im XAMPP-Bereich übernommen. Lustiger Weise habe ich jetzt gerade eben auf "localhost/security" gesehen, das MySQL Admin User "root" wohl doch bereits ein Passwort hat, welches aber definitiv nicht von mir kommt.

Als Versuch der Problemlösung fand ich bei euch den FAQ-Eintrag in dem ihr darauf hingewiesen habt, das in manchen wenigen Fällen die "ntwdblib.dll" erneuert werden müsse. Die Datei war vorher gar nicht vorhanden, aber auch ein hinzufügen brachte nichts.


Ich glaube im Verlauf des Problemes habe ich noch zwei - drei Dinge gesehen oder getan welche ich hier nicht aufgeführt habe. Sobald ich mich wieder dran erinnere (zB weil mir der Weg vorgeschlagen wird) werde ich es anklingen lassen.

Liebe Grüße vom völlig verzweifelten und durch einander gebrachten
schwubbe

Anime wrote:Mein Problem ist, als ich heute eine neuere Version installieren wollte, stellte ich fest das „winmysqladmin.exe“ nirgends wo zu finden war und daher frage ich mich ob das so beabsichtigt ist.

Ja, ist es.

Moin moin, es ist schon lange her wo ich hier angemeldet war, ebenso lang habe ich eine alte Version von Xampp genutzt und war bis heute zufrieden damit.

Ein Lob an euch ....inzwischen empfehle ich es jedem der einen Einstieg braucht und aus seinem Rechen mehr machen möchte

Mein Problem ist, als ich heute eine neuere Version installieren wollte, stellte ich fest das „winmysqladmin.exe“ nirgends wo zu finden war und daher frage ich mich ob das so beabsichtigt ist.

Danke für jede Antwort,
Anime

I have a serious problem.
I can see mysql data at web page, but not at sql.

My database is "utf8" and "utf8_genral_ci", but web program's charset is "euc-kr".
The problem is backup and restore.

The command "mysqldump -uroot -p --default-character-set=euc-kr mydb > /my-backup.sql" can produce backup sql, but I could not read and restoring does not works. Also " --default-character-set=utf8" shows same result.

Code: Select all

mysqldump -uroot -p --default-character-set=euc-kr my-db > my-backup.sql
mysqldump -uroot -p --default-character-set=utf8 my-db > my-backup.sql

my.cnf is here;

[client]
# password = your_password
port = 3306
socket = mysql
default-character-set=utf8

[mysqld]
basedir="I:/apm_packages/xampp/mysql"
tmpdir="I:/apm_packages/xampp/tmp"
datadir="I:/apm_packages/xampp/mysql/data"
language=I:/apm_packages/xampp/mysql/share/korean/
#default-character-set=euckr

port = 3306
socket = mysql

#old-passwords
character-set-server = utf8
collation-server = utf8_general_ci

skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K

server-id = 1

innodb_data_home_dir = I:/apm_packages/xampp/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = I:/apm_packages/xampp/mysql/data/

set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
max_allowed_packet=16M
default-character-set=utf8

[mysql]
no-auto-rehash
safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[WinMySQLadmin]
Server="I:/apm_packages/xampp/mysql/bin/mysqld.exe"
#user=root
#password=

And the result of "show variables like 'c%'"

+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /opt/lampp/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 10 |
+--------------------------+----------------------------------+

Further infor - looking in windows file, there is a my.ini.old already there. There is also a my.ini file, which says:

Code: Select all

# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/Program Files (x86)/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/Program Files (x86)/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password       = your_password
port            = 3306
socket          = mysql

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
basedir="C:/Program Files (x86)/xampp/mysql"
tmpdir="C:/Program Files (x86)/xampp/tmp"
datadir="C:/Program Files (x86)/xampp/mysql/data"

port            = 3306
socket          = mysql

old-passwords
character-set-server = latin1
collation-server = latin1_general_ci

skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id   = 1

# Uncomment the following if you want to log updates
#log-bin=C:/Program Files (x86)/xampp/mysql/data/mysql-bin

# Uncomment the following if you are NOT using BDB tables
skip-bdb

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:/Program Files (x86)/xampp/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/Program Files (x86)/xampp/mysql/data/
#innodb_log_arch_dir = C:/Program Files (x86)/xampp/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[WinMySQLadmin]
Server="C:/Program Files (x86)/xampp/mysql/bin/mysqld.exe"
#user=root
#password=


Wondering if this could be the problem?

Hi, I am new to programming, but I have installed Xampp several times before. On a new machine (using Win XP) I cannot run MySQL, but Apache is. I have searched the forum and tried to follow steps as shown below the error message from the mysql.err.

1. At first, in the control panel of XAMPP I ticked the SVC for both Apache and MySQL.
2. Apache is running, MySQL says it is started, but the "green running" is not appearing.
3. No access to phpmyadmin, but http:/localhost/ displays "It works!".
4. I'm confused
5. I'm getting annoyed.
6. I tried the steps found in another thread shown below under heading #2.
7. By trying out step 6, the MySQL turned green "running", but disappeared again soon after about 4 seconds, and will not run.

#1. From mysql.err file:

100407 13:53:13 [Note] Plugin 'FEDERATED' is disabled.
100407 13:53:13 [Note] PrimeBase XT (PBXT) Engine 1.0.08 RC loaded...
100407 13:53:13 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org
100407 13:53:14 InnoDB: Started; log sequence number 0 46409
100407 13:53:14 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100407 13:53:14 [ERROR] Aborting

100407 13:53:14 InnoDB: Starting shutdown...
100407 13:53:15 InnoDB: Shutdown completed; log sequence number 0 46409
100407 13:53:15 [Note] PrimeBase XT Engine shutdown...
100407 13:53:15 [Warning] Forcing shutdown of 1 plugins
100407 13:53:15 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

100407 13:53:58 [Note] Plugin 'FEDERATED' is disabled.
100407 13:53:58 [Note] PrimeBase XT (PBXT) Engine 1.0.08 RC loaded...
100407 13:53:58 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org
100407 13:53:58 InnoDB: Started; log sequence number 0 46409
100407 13:53:58 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100407 13:53:58 [ERROR] Aborting


#2. Find your startup folder and delete the shortcut for WinMySQLAdmin and don't ever click on the MySQL Admin... button or you will have more troubles.
xXDonXx wrote:
Mysql doesn`t work , what can i do to fix this?
Remove the tick in the Svc box then try and start Mysql.

If it won't start go to xampp\mysql\ folder and run the mysql_uninstallservice.bat file.

If it uninstalls the service go back and check in the XCP that the tick in the Svc box has gone.

If it has gone then try and Start MySQL.

Don't put a tick in the Svc box until your know that MySQL is Running.

See if that helps.
////

Hope to receive some help by anyone with knowledge! Thank you, very much appreciated!