Info my PC:
- windows server 2008 (64bit) with 2IP
- Xampp 1.7.7
- IIS 7
when login to phpmyadmin, it show:
#1130 Cannot log in to the MySQL server
Connection for controluser as defined in your configuration failed.
Log error mysql show:
120317 9:35:41 [Note] Plugin 'FEDERATED' is disabled.
120317 9:35:41 InnoDB: The InnoDB memory heap is disabled
120317 9:35:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120317 9:35:41 InnoDB: Compressed tables use zlib 1.2.3
120317 9:35:41 InnoDB: Initializing buffer pool, size = 16.0M
120317 9:35:41 InnoDB: Completed initialization of buffer pool
120317 9:35:41 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!
120317 9:35:41 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...
120317 9:35:42 InnoDB: Waiting for the background threads to start
120317 9:35:43 InnoDB: 1.1.8 started; log sequence number 322494819
120317 9:35:43 [Note] Event Scheduler: Loaded 0 events
120317 9:35:43 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
to fix
1. Go to C:\Windows\System32\drivers\etc
2. Open “hosts” in your fav text editor
you will likely see 2 lines:
127.0.0.1 localhost
::1 localhost
3. Comment out the “::1″ line
4. save
5. Try phpmyadmin again.
Done.