Apache Friends Support Forum

Hi, please i need help on how to begin with XAMPP.am totally green, i have installed it on my windows7 laptop and when i start off a terminal window, it takes me upto c:\xampp\mysql\bin. but when i go ahead and when i type mysql -u root and press Enter, it gives me an error message:

ERROR 2003 <HY000>: can't connect to Mysql server on 'localhost' <10061>

pleas esomeone tell me what this means so that am able to go through my tutorials successfully.
and in the xampp control panel it brings me this error meassage when i start mysql:

13:16:57 [main] Initializing Control Panel
13:16:57 [main] Windows Version: Windows 7 Professional SP1 32-bit
13:16:57 [main] XAMPP Version: 1.8.3
13:16:57 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
13:16:57 [main] You are not running with administrator rights! This will work for
13:16:57 [main] most application stuff but whenever you do something with services
13:16:57 [main] there will be a security dialogue or things will break! So think
13:16:57 [main] about running this application with administrator rights!
13:16:57 [main] XAMPP Installation Directory: "c:\xampp\"
13:16:57 [main] Checking for prerequisites
13:16:57 [main] All prerequisites found
13:16:57 [main] Initializing Modules
13:16:57 [main] Starting Check-Timer
13:16:57 [main] Control Panel Ready
13:17:42 [main] Executing "c:\xampp\mysql"
13:17:56 [mysql] Attempting to start MySQL app...
13:17:56 [mysql] Status change detected: running
13:17:57 [mysql] Status change detected: stopped
13:17:57 [mysql] Error: MySQL shutdown unexpectedly.
13:17:57 [mysql] This may be due to a blocked port, missing dependencies,
13:17:57 [mysql] improper privileges, a crash, or a shutdown by another method.
13:17:57 [mysql] Press the Logs button to view error logs and check
13:17:57 [mysql] the Windows Event Viewer for more clues
13:17:57 [mysql] If you need more help, copy and post this
13:17:57 [mysql] entire log window on the forums

Hi,

We need the mysql_error.log contents.

best wishes,
Altrea

hi,
this is how it looks at the control panel.

:16:57 [main] Initializing Control Panel
13:16:57 [main] Windows Version: Windows 7 Professional SP1 32-bit
13:16:57 [main] XAMPP Version: 1.8.3
13:16:57 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
13:16:57 [main] You are not running with administrator rights! This will work for
13:16:57 [main] most application stuff but whenever you do something with services
13:16:57 [main] there will be a security dialogue or things will break! So think
13:16:57 [main] about running this application with administrator rights!
13:16:57 [main] XAMPP Installation Directory: "c:\xampp\"
13:16:57 [main] Checking for prerequisites
13:16:57 [main] All prerequisites found
13:16:57 [main] Initializing Modules
13:16:57 [main] Starting Check-Timer
13:16:57 [main] Control Panel Ready
13:17:42 [main] Executing "c:\xampp\mysql"
13:17:56 [mysql] Attempting to start MySQL app...
13:17:56 [mysql] Status change detected: running
13:17:57 [mysql] Status change detected: stopped
13:17:57 [mysql] Error: MySQL shutdown unexpectedly.
13:17:57 [mysql] This may be due to a blocked port, missing dependencies,
13:17:57 [mysql] improper privileges, a crash, or a shutdown by another method.
13:17:57 [mysql] Press the Logs button to view error logs and check
13:17:57 [mysql] the Windows Event Viewer for more clues
13:17:57 [mysql] If you need more help, copy and post this
13:17:57 [mysql] entire log window on the forums
shambula

shambula wrote:this is how it looks at the control panel.

This is not what he asked for. Re-read the post.

ok thank you.but maybe i don't understand what it means by msql_erro.log elements. How do i get them?please someone help

There is a logs button in the control panel. Or you can go find it in the folder.

thank you so much JJ_Tagy.finally i found it. so, this is what i got:

2014-05-11 11:21:04 8304 [Note] Plugin 'FEDERATED' is disabled.
2014-05-11 11:21:04 16f4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-05-11 11:21:04 8304 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-05-11 11:21:05 8304 [Note] InnoDB: The InnoDB memory heap is disabled
2014-05-11 11:21:05 8304 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-05-11 11:21:05 8304 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-05-11 11:21:05 8304 [Note] InnoDB: Not using CPU crc32 instructions
2014-05-11 11:21:05 8304 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-05-11 11:21:05 8304 [Note] InnoDB: Completed initialization of buffer pool
2014-05-11 11:21:05 8304 [Note] InnoDB: Highest supported file format is Barracuda.
2014-05-11 11:21:08 8304 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1625987
2014-05-11 11:21:08 8304 [Warning] InnoDB: Starting to delete and rewrite log files.
2014-05-11 11:21:08 8304 [Note] InnoDB: Setting log file D:\XAMMP\mysql\data\ib_logfile101 size to 5 MB
2014-05-11 11:21:09 8304 [Note] InnoDB: Setting log file D:\XAMMP\mysql\data\ib_logfile1 size to 5 MB
2014-05-11 11:21:11 8304 [Note] InnoDB: Renaming log file D:\XAMMP\mysql\data\ib_logfile101 to D:\XAMMP\mysql\data\ib_logfile0
2014-05-11 11:21:11 8304 [Warning] InnoDB: New log files created, LSN=1625987
2014-05-11 11:21:11 8304 [Note] InnoDB: 128 rollback segment(s) are active.
2014-05-11 11:21:11 8304 [Note] InnoDB: Waiting for purge to start
2014-05-11 11:21:11 8304 [Note] InnoDB: 5.6.16 started; log sequence number 1625987
2014-05-11 11:21:11 8304 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 97dae88a-d8ed-11e3-8969-001f1652e50f.
2014-05-11 11:21:11 8304 [Note] Server hostname (bind-address): '*'; port: 3306
2014-05-11 11:21:11 8304 [Note] IPv6 is available.
2014-05-11 11:21:11 8304 [Note] - '::' resolves to '::';
2014-05-11 11:21:11 8304 [Note] Server socket created on IP: '::'.
2014-05-11 11:21:17 8304 [Note] Event Scheduler: Loaded 0 events
2014-05-11 11:21:17 8304 [Note] d:\xammp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)

Your snippet doesn't match with the problem.

13:17:57 [mysql] Status change detected: stopped
13:17:57 [mysql] Error: MySQL shutdown unexpectedly.
13:17:57 [mysql] This may be due to a blocked port, missing dependencies,
13:17:57 [mysql] improper privileges, a crash, or a shutdown by another method.
13:17:57 [mysql] Press the Logs button to view error logs and check
13:17:57 [mysql] the Windows Event Viewer for more clues
13:17:57 [mysql] If you need more help, copy and post this
13:17:57 [mysql] entire log window on the forums

Where is the log section with the same timestamp as this?

oh JJ_Tagy. now am totally lost. as i had said, i am green totally. now i dont know what to do. but i appreciate your help.