MySQL not connect with XAMPP & IIS [SOLVED]

[nightrelax]

all not connect with sql
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.

[mylife2012vn]

Hepl me. i have a erro same above.
i also use, IIS 7. Windows 7. Xmapp 1.7.7. and MSsql 2008 R2.

#2002 Cannot log in to the MySQL server
Connection for controluser as defined in your configuration failed.

in file C:\xampp\mysql\data\mysql_error
120421 9:06:10 [Note] Plugin 'FEDERATED' is disabled.
120421 9:06:10 InnoDB: The InnoDB memory heap is disabled
120421 9:06:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120421 9:06:10 InnoDB: Compressed tables use zlib 1.2.3
120421 9:06:10 InnoDB: Initializing buffer pool, size = 16.0M
120421 9:06:10 InnoDB: Completed initialization of buffer pool
120421 9:06:10 InnoDB: highest supported file format is Barracuda.
120421 9:06:10 InnoDB: Waiting for the background threads to start
120421 9:06:11 InnoDB: 1.1.8 started; log sequence number 1595675
120421 9:06:11 [Note] Event Scheduler: Loaded 0 events
120421 9:06:11 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 8888 MySQL Community Server (GPL)

[Altrea]

Hi mylife2012vn,

First rule: If you want to get help from volunteers, you have to be polite. Some sort of greeting and complimentary close don't cost much time. Some sort of request with Please and a question mark would be polite too.

Second rule: It is an unwritten rule here that each user opens an own thread for each single issue. That will help the volunteers to find that issues they are familiar with (for example that thread here is marked as solved. But your issue is not solved yet), and will help others with the same problem to find helping threads much easier and faster.
Another reason for this rule is, that your issue might sound similar to the OPs one, but the solution can be different.

In your case:

Version: '5.5.16' socket: '' port: 8888 MySQL Community Server (GPL)

you don't use the original port for MySQL as the OP uses. That can cause other issues with DB driven scripts, so that change is not recommend.
Have you configured phpmyadmin to request on that new port?

best wishes,
Altrea