Unable to access phpmyadmin on a new install, getting error [Solved]
Posted by: papagino (---.dhcp-dynamic.FibreOp.nb.bellaliant.net)
Date: March 06, 2015 09:59PM

Unable to access phpmyadmin, getting this error:

*****
Error

MySQL said:
#2002 - No connection could be made because the target machine actively refused it.

The server is not responding (or the local server's socket is not correctly configured).
*****

(This is on a fresh install of WAMPserver)


1 - Windows version used (Specify version number AND whether 32 or 64 bit)
= Windows 7 64bit

2 - Version WampServer (Specify version number AND whether 32 or 64 bit)
= 32bit

3 - Apache Version
= 2.4.9

4 - PHP Version
= 5.5.12

5 - MySQL Version
= 5.6.17

6 - What color is the WampServer icon (in the notification area of the taskbar)
= Orange




In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines with the name [localhost] in them?

=
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost


Full path to the installation of WampServer
= C:\wamp\

Microsoft event viewer shows this error for MySQL:
wampmysqld: unknown option '--skip-locking'




mysql.log =


2015-03-06 16:48:13 5980 [Note] Plugin 'FEDERATED' is disabled.
2015-03-06 16:48:13 5980 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-06 16:48:13 5980 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-06 16:48:13 5980 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-06 16:48:13 5980 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-06 16:48:13 5980 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-06 16:48:13 5980 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-06 16:48:13 5980 [Note] InnoDB: Completed initialization of buffer pool
2015-03-06 16:48:13 5980 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-06 16:48:14 5980 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-06 16:48:14 5980 [Note] InnoDB: Waiting for purge to start
2015-03-06 16:48:14 5980 [Note] InnoDB: 5.6.17 started; log sequence number 1626067
2015-03-06 16:48:14 5980 [ERROR] wampmysqld: unknown option '--skip-locking'
2015-03-06 16:48:14 5980 [ERROR] Aborting

2015-03-06 16:48:14 5980 [Note] Binlog end
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'partition'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-06 16:48:14 5980 [Note] Shutting down plugin 'InnoDB'
2015-03-06 16:48:14 5980 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 16:48:14 5980 [Note] InnoDB: Starting shutdown...
2015-03-06 16:48:15 5980 [Note] InnoDB: Shutdown completed; log sequence number 1626077
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'ARCHIVE'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'MyISAM'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'MEMORY'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'CSV'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'sha256_password'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'mysql_old_password'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'mysql_native_password'
2015-03-06 16:48:15 5980 [Note] Shutting down plugin 'binlog'
2015-03-06 16:48:15 5980 [Note] wampmysqld: ArrĂȘt du serveur terminĂ©



Antivirus = malwarebytes Premium
Firewall = Windows 7 firewall

Tried disabling antivirus and firewall with same results.

Any help would be appreciated.


*************************************************************************************************************

Solution: Searched for a file called "my.cnf" on the same partition I installed wampserver and renamed it "my.cnf backup" or you could delete it...

This was mostly installed from another server I installed before...



Edited 2 time(s). Last edit at 03/06/2015 10:53PM by papagino.

Options: ReplyQuote


Sorry, only registered users may post in this forum.