Search found 6462 matches: mysql can't start

Searched query: +mysql +can't +start

Return to advanced search

Re: After activating CURL, can't restart XAMPP

Thanks for the response.. I ended up re-installing XAMPP from scratch only to find out that I was STILL unable to get Apache, FileZillaFTP, or mySQL to start.. So I wiped everything out one more time and decided to start over with a clean XAMPP install.. the result of this install is as follows:

I deleted EVERYTHING manually.. I then ran the Windows uninstall.. I re-installed XAMPP again.

Started the control panel, and got no joy starting any of the services:
7:27:36 PM [main] Running with Administrator rights - good!
7:27:36 PM [main] XAMPP Installation Directory: "w:\xampp\"
7:27:36 PM [main] Initializing Modules
7:27:36 PM [main] Starting Check-Timer
7:27:36 PM [main] Control Panel Ready
7:28:16 PM [apache] Starting apache service...
7:29:37 PM [mysql] Starting mysql service...
7:29:41 PM [filezilla] Starting FileZilla service...

No error logs, no Windows application event logs, NOTHING...

I saw that Apache, FileZillaFTP, and mySQL were still installed as services (I think this was a carry over from my second install attempt).. So I uninstalled the Apache, FileZillaFTP, and mySQL services and then tried again to start Apache, FileZillaFTP, and mySQL again..

Dammed if it didn't all work.. I've enabled CURL, setup my sub-domains, and all is right with the world..

For the sake of FULL disclosure, I am installing XAMPP to a shared network drive (shared drive is on my WHS machine)
Windows Version: Windows 7 Home Premium SP1 64-bit (correction from my earlier post)
XAMPP Version: 1.8.0
Control Panel Version: 3.0.12
by DivaVocals
21. July 2012 04:48
 
Forum: XAMPP for Windows
Topic: [resolved]After activating CURL, can't restart XAMPP
Replies: 2
Views: 2533

Please help: Apache will not start and it seems like...

Hello, here is my situation. I have been using apache on xampp so I can use jquery, etc on my sites. xampp has worked perfectly every since i downloaded it a couple weeks ago, until today. I get an error when I run saying

WARNING terminating worker thread 0
Apache started [port 80]


The only major thing I have done in the past day is download adobe cs6 master collection. I am really confused and I have no clue what is going on (check the image). There seems to be to xampps on my computer and both are different from each other... I am used to the one on the bottom right. I have absolutely no clue what is going on and I have spent ALL day trying to fix this, xampp is extremely frustrating. Anyways, no, skype is not running on port 80. Mysql is not running either. This is a nightmare, I do not know what to do. Thanks a lot for the help guys, I appreciate it. Here is a photo so you can catch a glimpse of what is going on.

http://postimage.org/image/nln4ghkzr/
by popster
21. July 2012 03:35
 
Forum: XAMPP for Windows
Topic: Please help: Apache will not start and it seems like...
Replies: 1
Views: 1571

Re: Apache won't start after upgrade to 1.8

For now, I can say you can't expect configuration files from prior version of Apache or PHP on XAMPP to work in two areas -

The mod_auth group of modules for Apache and Error Reporting for PHP.

Reason - both Apache and PHP had 'major' version changes. i.e 2.4.2 for Apache and PHP 5.4.4

MySQL does not seem to be a problem area.

I have posted a sticky about Apache and PHP changes on the XAMMP Windows English forum - it is slightly specific to Windows, but the migration issues for configurations are basically the same. The How to Upgrade is/will be quite different

Good Luck
8)
by JonB
21. July 2012 01:06
 
Forum: XAMPP for Linux
Topic: Apache won't start after upgrade to 1.8
Replies: 5
Views: 7825

lampp paths

I need to install lampp under a different directory than /opt, so I extracted it to my needed directory and ran a sed to change all /opt/lampp to /adsi/lampp, which seems to work fine. However, when I attempt to start lampp, I get the following:

Code: Select all
adsirms:/adsi/lampp # whoami
root
adsirms:/adsi/lampp # ./lampp start
./lampp: line 126:  2869 Segmentation fault      /adsi/lampp/share/lampp/selinux
Starting XAMPP for Linux 1.8.0...
./lampp: line 128:  2870 Segmentation fault      /adsi/lampp/share/lampp/nogroupcheck
./lampp: line 128:  2871 Segmentation fault      $0 startapache %
./lampp: line 128:  2872 Segmentation fault      $0 startmysql %
./lampp: line 128:  2873 Segmentation fault      $0 startftp %
./lampp: line 128:  2874 Segmentation fault      /adsi/lampp/share/lampp/alladdons start
XAMPP for Linux started.
adsirms:/adsi/lampp # ./lampp status
./lampp: line 126:  2880 Segmentation fault      /adsi/lampp/share/lampp/selinux
Version: XAMPP for Linux 1.8.0
Apache is not running.
MySQL is not running.
ProFTPD is not running.
adsirms:/adsi/lampp #


Nothing starts and I get these segmentation fault messages. I am stumped. Any help would be appreciated.

Thanks.
by TheoR
20. July 2012 22:15
 
Forum: XAMPP for Linux
Topic: lampp paths
Replies: 1
Views: 1607

Re: Apache won't start after upgrade to 1.8

Any luck on this? I am facing the exact same issue. If i just copy over to the old http.conf the load modules section on top would i be on the safe side?
I am also facing problems with upgrading mysql. Are all the tables gone? Can i use an old backup of mine from 1.7.7?
by mad-proffessor
20. July 2012 18:24
 
Forum: XAMPP for Linux
Topic: Apache won't start after upgrade to 1.8
Replies: 5
Views: 7825

[resolved]After activating CURL, can't restart XAMPP

:D First some required information:
XAMPP Version 1.8.0
XAMPP Control Panel Version 3
Windows 7 Home Edition (32)

Steps I took leading to my present state:
I installed XAMPP
Was able to view http:/localhost no problem
Went to http://localhost/security and created .htaccess password, and updated my mySQL root user password
Stopped Apache service
Configured XAMPP so that I could create subdomains following these instructions: http://www.codingcereal.com/2011/05/setting-up-multiple-subdomains-in-your-localhost-using-xampp/
Re-Started Apache service
Was able to view my new subdomain just fine: http:/newsubdomain.localhost.com
Stopped Apache service
Edited my php.ini file to activate curl
Re-Started Apache service

At this point is where the fun begins.. Apache will either start, then stop on it's own or it simply will not start. Of course because of this, I am not longer able to view my localhost or any of my new subdomains.

I am stumped.. :? Hope the kind folks here can help.. :D
by DivaVocals
20. July 2012 17:59
 
Forum: XAMPP for Windows
Topic: [resolved]After activating CURL, can't restart XAMPP
Replies: 2
Views: 2533

Unable to login to phpMyAdmin with new user

Hello, all. I am a new XAMPP user and a noob in the world of building web servers, and I could use some help.

My stats:
XAMPP Version 1.8.0 (c:\xampp)
Control Panel Version 3.0.12
Server - Windows 2008r2

I have everything up and running, and I am working on installing phpBB for one of my websites. However, I am unable to create a new user in phpMyAdmin and be able to log in using that new user. Every time I try to log in I get "Cannot log in to the MySQL server." I am positive that the username and password are correct (board, 1). Also, the password for "root" is currently blank. I have tried my scenario both with a password for root and without. It doesn't seem to affect the situation.

I have been through the forums and these are the steps I have currently taken:

  1. Edited c:\windows\system32\drivers\etc\hosts - 127.0.0.1 localhost is enabled, :: localhost is commented out
  2. Checked config.ini.php. Line $cfg['Servers'][$i]['auth_type'] = 'cookie'; has 'cookie' in it.
  3. Root password is currently blank.
  4. \xampp\mysql\bin\my.ini file - bind-address is set to "127.0.0.1"

According to my MySQL error log, I am getting no errors:

Code: Select all
120718 11:55:05 [Note] Plugin 'FEDERATED' is disabled.
120718 11:55:05 InnoDB: The InnoDB memory heap is disabled
120718 11:55:05 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120718 11:55:05 InnoDB: Compressed tables use zlib 1.2.3
120718 11:55:05 InnoDB: Initializing buffer pool, size = 16.0M
120718 11:55:05 InnoDB: Completed initialization of buffer pool
120718 11:55:05 InnoDB: highest supported file format is Barracuda.
120718 11:55:05  InnoDB: Waiting for the background threads to start
120718 11:55:06 InnoDB: 1.1.8 started; log sequence number 1595685
120718 11:55:06 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
120718 11:55:06 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
120718 11:55:06 [Note] Server socket created on IP: '127.0.0.1'.
120718 11:55:07 [Note] Event Scheduler: Loaded 0 events
120718 11:55:07 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)


However, in phpMyAdmin, I do show, at last count, 5 failed attempts for today. If you want to see my config.ini.php and my.ini files, I will happily post those, too.

Any assistance available will be much appreciated. Thank you.
by LKClark
18. July 2012 18:11
 
Forum: XAMPP for Windows
Topic: Unable to login to phpMyAdmin with new user
Replies: 5
Views: 5586

[REV] How to "upgrade" to XAMPP 1.8.0 or 1.8.1

Note there is NO Upgrade for 1.8.0 or 1.8.1 - reason - things (features, settings, configurations) are too different when you hit a major release on Apache and/or PHP. XAMPP 1.8.0/1 has Apache 2.4.x, prior XAMPP releases were 2.2 - big changes. The same for PHP, 1.8.0/1` has PHP 5.4.x -- XAMPP 1.7.7 was PHP 5.3.8 -- big changes, particularly in Error Reporting -

PHP Error Reporting changes - hot off the press - not findable on Google or PHP.org yet
http://community.apachefriends.org/f/vi ... 17&t=50989

CHECK with any third party scripts to make sure they are compatible with Apache 2.4.x. and PHP 5.4.x Ditto check any changes you made to any of the Apache .conf files, some common features are deprecated - most notably this would be the 'NameVirtualHost' directive and 'most' versions of simple authentication methods (mod_auth... Apache Module versions), including the .htaccess syntax

Apache's Guide to upgrading to 2.4
http://httpd.apache.org/docs/2.4/upgrading.html

Going from XAMPP 1.7.7 (or other versions) to 1.8.0/1 for Windows

A. Backup
Backup your 'custom' / user added MySQL databases. You can use the phpMyAdmin export tool, MySQL Workbench (free tool from Oracle), or the mysqldump.exe Command Line tool. Take screenshots of your database names, users and settings. Make SURE you know all the passwords and they are working (you can test by logging into phpMyAdmin as those users). You will probably have to 'add-back' any users 'you' created originally (like for the WordPress 'database user') and re-create the empty databases and the user privileges, don't forget the PMA control user! This is the safest route unless you know 'a lot' about MySQL Import/Export parameters. Copy out your HTDOCS, any user added Folders that are Aliased, and any Virtual Host folders.

B. Stop XAMPP
Stop all XAMPP processes/services.

C. Complete Backup
Backup your complete XAMPP install to another location. This could be by way of a true backup program like Acronis or Fbackup or simply shutting down XAMPP and copying the entire folder to a new location.

D. Save Configurations
If you have modified the Configuration files for Apache, MySQL, PHP, and PHPmyAdmin (config.inc.php) they will likely need adjustments. (You will have to figure that out) I save them AND the log files to a XAMMP-Move folder for myself. If you are going from an earlier version, this is 'doubly true'.

E. Un-install Services
If you made Apache, MySQL, FileZilla, Mercury or Tomcat into services, un-install/remove them from the Windows service manager via the Control Panel, or by way of the Command Window using the Windows 'sc delete' command.

F. Clean UP
OK, you should be ready for this - DELETE the current XAMPP folder.

G. Install
Now either:
Use the XAMPP Installer
or
Expand the .7z or .zip downloads. Copy the new 'xampp' folder to the location of your old installation.

H. Start the New XAMPP Install
Start up the Control Panel and debug the new installation before you bring anything back.

I. If tis working - BACK UP!
If you are able to get to the XAMPP Welcome Page, use the test scripts and access phpMyAdmin - before you do anything else, shut everything down and make a reliable backup.

J. Check Up
CHECK (again) with any third party scripts to make sure they are compatible with Apache 2.4.x. and PHP 5.4.x - Ditto check any changes you made to any of the Apache .conf files, some common features are deprecated - most notably this would be the 'NameVirtualHost' directive and 'most' versions simple authentication methods, including the .htaccess syntax. Make needed changes to the Apache .conf files php.ini and my.ini to get your install 'like the old one' or as close as you can come. Hackattack suggests doing a side-by-side review using a diff utility (good idea) - WinMerge is a very friendly one, or you can use a programmer's editor like the excellent (and free) Notepadd++

J. Never ever try to recreate or copy application metadata
Such as the database and tables for MySQL database engine itself or phpMyadmin - which is an application/shell for MySQL. This data is specific to each installation, and is often structured differently in different version of the applications.

K. NEVER EVER copy the entire MySQL toplevel 'data' folder.
It contains metadata on the state of the MySQL installation and other data that may be specific to 'other application states'. You can, under some conditions, copy the data folders for individual databases/tables - you need to refer to the MySQL documentation before you attempt this, and understand the consequences, and the remediation that may be required. Only real MySQL experts attempt this (and usually because the database is corrupt or in an inconsistent state). I personally always user MySQL Workbench Export/Import (or Navicat). If you use the export/import methodology you will rarely go wrong.

http://dev.mysql.com/doc/refman/5.5/en/ ... eries.html

L. Recreate User defined/added metadata & Re-install scripts/applications
Recreate your 'self-added' database users as described in A, and their privileges. Always check the third party scripts you are using for compatibility/version issues (as stated twice before). Once everything is stable, REINSTALL any third party scripts and follow their instructions to 'restore' as if it were a 'server' move, because that is what you have just done.

M. Restore MySQL Data
Now Restore your MySQL user-created databases using phpMyAdmin, the MySql command line, or other MySQL management tools - like MySQL workbench.

N. Finally -
Make another backup and test your applications.

Also be sure to take potty breaks and that you have adequate liquids on hand :mrgreen:

Many thanks to Altrea for his assistance and review.

Good Luck
8)
{edited Oct 11, 2012 to include 1.8.1}
by JonB
17. July 2012 14:37
 
Forum: XAMPP for Windows
Topic: [REV] How to "upgrade" to XAMPP 1.8.0 or 1.8.1
Replies: 6
Views: 21720

Re: another Apache not starting topic

OK - I will make this into a sticky in a bit

Note there is NO Upgrade for 1.8.0 - reason - things (features, settings, configurations) are too different when you hit a major release on Apache or PHP. XAMPP 1.8.0 has Apache 2.4.2, prior XAMPP releases were 2.2 - big changes.

CHECK with any third party scripts to make sure they are compatible with Apache 2.4.2. Ditto check any changes you made to any of the Apache .conf files, some common features are deprecated - most notably this would be the 'NameVirtualHost' directive and 'most' versions of simple authentication methods (mod_auth... Apache Module versions), including the .htaccess syntax

Going from XAMPP 1.7.7 (or other versions) to 1.8.0 for Windows

A. Backup
Backup your 'custom' / user added MySQL databases. You can use the phpMyAdmin export tool, MySQL Workbench (free tool from Oracle), or the mysqldump.exe Command Line tool. Take screenshots of your database names, users and settings. Make SURE you know all the passwords and they are working (you can test by logging into phpMyAdmin as those users). You will probably have to 'add-back' any users 'you' created originally (like for the WordPress 'database user') and re-create the empty databases and the user privileges, don't forget the PMA control user This is the safest route unless you know 'a lot' about MySQL Imprt/Export parameters. Copy out your HTDOCS, any user added Folders that are Aliased, and any Virtual Host folders.

B. Stop XAMPP
Stop all XAMPP processes/services.

C. Complete Backup
Backup your complete XAMPP install to another location. This could be by way of a true backup program like Acronis or Fbackup or simply shutting down XAMPP and copying the entire folder to a new location.

D. Save Configurations
If you have modified the Configuration files for Apache, MySQL, PHP, and PHPmyAdmin (config.inc.php) they will likely need adjustments. (You will have to figure that out) I save them AND the log files to a XAMMP-Move folder for myself. If you are going from an earlier version, this is 'doubly true'.

E. Un-install Services
If you made Apache, MySQL, FileZilla, Mercury or Tomcat into services, un-install/remove them from the Windows service manager via the Control Panel, or by way of the Command Window using the Windows 'sc delete' command.

F. Clean UP
OK, you should be ready for this - DELETE the current XAMPP folder.

G. Install
Now either:
Use the XAMPP Installer
or
Expand the .7z or .zip downloads. Copy the new 'xampp' folder to the location of your old installation.

H. Start the New XAMPP Install
Start up the Control Panel and debug the new installation before you bring anything back.

I. Check Up
CHECK (again) with any third party scripts to make sure they are compatible with Apache 2.4.2. Ditto check any changes you made to any of the Apache .conf files, some common features are deprecated - most notably this would be the 'NameVirtualHost' directive and 'most' versions simple authentication methods, including the .htaccess syntax. Make needed changes to the Apache .conf files php.ini and my.ini to get your install 'like the old one' or as close as you can come.

J. RE-install
Once everything is stable, REINSTALL any third party scripts and follow their instructions to 'restore' as if it were a 'server' move, because that is what you have just done.

Good Luck
8)
by JonB
17. July 2012 14:25
 
Forum: XAMPP for Windows
Topic: another Apache not starting topic [Solved]
Replies: 7
Views: 10776

Re: #1045 Error

RedCP wrote:Hey there,

So I recently downgraded to XAMPP 1.7.4 so I could finally get Apache starting (even following steps by other people, Apache would not start for me). Yeah, that doesn't matter.

So I'm working on a game, and I'm testing out the register and users and all of that. I want to add a database, but it seems I cannot get into my https://localhost/phpmyadmin/ for some reason. Here's what it says:


Welcome to phpMyAdmin

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Open new phpMyAdmin window


I tried changing my password, but nothing happened. I changed it in config.inc.php. Can someone please help me?

Thanks a lot.

I had a similar problem with those errors, try this
open your windows hosts file
C:\Windows\System32\drivers\etc\hosts
find
Code: Select all
::1   localhost

comment it out.
Code: Select all
#::1   localhost

windows 7 should be fine after saving that, XP and below maybe need a restart.

Open xampp/mysql/my.ini, find the line below and uncomment it (remove the #)

Code: Select all
bind-address="127.0.0.1"

Clear your cookies and cache, restart mysql and cross your fingers it works. Don't change anything in config.inc.php either.
by Takster
15. July 2012 14:08
 
Forum: XAMPP for Windows
Topic: #1045 Error
Replies: 7
Views: 8741

#1045 Error

Hey there,

So I recently downgraded to XAMPP 1.7.4 so I could finally get Apache starting (even following steps by other people, Apache would not start for me). Yeah, that doesn't matter.

So I'm working on a game, and I'm testing out the register and users and all of that. I want to add a database, but it seems I cannot get into my https://localhost/phpmyadmin/ for some reason. Here's what it says:


Welcome to phpMyAdmin

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Open new phpMyAdmin window


I tried changing my password, but nothing happened. I changed it in config.inc.php. Can someone please help me?

Thanks a lot.
by RedCP
14. July 2012 21:39
 
Forum: XAMPP for Windows
Topic: #1045 Error
Replies: 7
Views: 8741

Re: Neues Control Panel - v3

Hallo ich habe glaube eine fehler gefunden zu haben???, da mehrere User im Netz von einem Fehler schreiben und ich das selbe habe.

Ich kann bei beiden Controll Panel mysql nicht starten.
im Controll Panel steht nur Starte Dienst mysql... - passiert aber nichts

gehe ich aber auf die mysql.start - startet mysql - schließe ich die console wird mysql beendet.
Port 3306 ist frei

woran kann das liegen.

Gruß Bowhunter
by Wolf76
13. July 2012 10:03
 
Forum: XAMPP für Windows
Topic: Neues Control Panel - v3
Replies: 21
Views: 15059

Re: how to activate MYSQL?

Is this a 'brand-new' unaltered XAMPP installation AND you have never had MySQL previously installed?

IF so - My guess is you have a corrupt install.

Stop any parts of XAMPP that are running

If you made Apache, MySQL or Filezilla services - remove them as services with the Control Panel. (uncheck the green checkbox) you will have to do it one at a time.

Did you use the installer version?

IF so - use the Windows Control Panel - to un-install the installer, then delete the xampp folder.

If you used a 7z or ZIP DL, just delete the XAMPP folder

Next, DL a fresh XAMPP distribution picking either the 7z or ZIP versions, and check the MDD5 checksums when done.

Expand the Archive and copy it to the install location (preferably the root of a drive)

Start XAMPP with either the Control Panel or xampp_start.exe.

Good Luck
8)
by JonB
11. July 2012 21:09
 
Forum: XAMPP for Windows
Topic: how to activate MYSQL?
Replies: 1
Views: 1633

Re: phpMyAdmin cannot start when offline

OK

try binding MySQL to 127.0.0.1

Also check your hosts file to make sure there is an entry:

127.0.0.1 localhost


Good Luck
8)
by JonB
11. July 2012 13:38
 
Forum: XAMPP for Windows
Topic: phpMyAdmin cannot start when offline
Replies: 3
Views: 2219

how to activate MYSQL?

[EDIT by Altrea: moved from this post in the german only forum]

I have the same problem. Just installed the latest XAMPP version. from the control panel I can start Apache and Filezilla, but not MySql. I followed your suggestion to start xampp-control-3-beta.exe and to see in the error log what is going wrong. These are the last lines in the error report:

120711 14:17:48 [Note] Plugin 'FEDERATED' is disabled.
120711 14:17:48 InnoDB: The InnoDB memory heap is disabled
120711 14:17:48 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120711 14:17:48 InnoDB: Compressed tables use zlib 1.2.3
120711 14:17:48 InnoDB: Initializing buffer pool, size = 16.0M
120711 14:17:48 InnoDB: Completed initialization of buffer pool
120711 14:17:48 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120711 14:17:48 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120711 14:17:48 InnoDB: Waiting for the background threads to start
120711 14:17:49 InnoDB: 1.1.8 started; log sequence number 1591515
120711 14:17:49 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it

Apparently it has something to do with the privilages. But I have no idea how to repair that. I am the only user on this recently bought laptop which runs under Windows 7 Home

Can you help me?
by Nico Boots
11. July 2012 13:29
 
Forum: XAMPP for Windows
Topic: how to activate MYSQL?
Replies: 1
Views: 1633
PreviousNext

Return to advanced search