Error 2002 on PHPMy Admin [Solved]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Error 2002 on PHPMy Admin [Solved]

Postby Kowagaru » 25. April 2012 14:08

ApacheFriends XAMPP version 1.7.7

XAMPP Control Panel Version 3

Windows 7 Home Basic 64bits

I recently installed XAMPP in the computer of my company to work in a site using Joomla. I used it before at my home (That have a Windows 7 Ultimate Edition 64x) and was surprised when XAMPP started to have problems with ports. I solved that problem (I have to write the ip:port to enter XAMPP)

When I tried to enter PHPmyADM I run into a problem: Error 2002. I googled it and discovered that is a problem with a missing socket in MySql. But I didn’t find a solution for that. I really need some help right now.
Kowagaru
 
Posts: 6
Joined: 25. April 2012 14:06
Operating System: Windows 7 Home Basic 64x

Re: Error 2002 on PHPMy Admin

Postby Theslcguy » 25. April 2012 21:23

check your my.cnf/config.inc.php for a setting similar to the following

socket = /tmp/mysql.sock

Then php.ini for the following

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket = /tmp/mysql.sock


make sure that the path for the two files match

restart whichever one you make changes to(MySQL or Apache), then try it again.
Theslcguy
 
Posts: 11
Joined: 23. April 2012 21:06
Operating System: Win7

Re: Error 2002 on PHPMy Admin

Postby hackattack142 » 28. April 2012 00:18

This sometimes fixes this error:
Try opening your "/xampp/mysql/bin/my.ini" file, and finding this line:
Code: Select all
#bind-address="127.0.0.1"
, remove the "#" in front of it, save the file, and restart MySQL. When you visit the phpMyAdmin page http://localhost/phpmyadmin make sure you manually refresh the page in your browser so you do not get a cached error page.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: Error 2002 on PHPMy Admin

Postby Kowagaru » 03. May 2012 15:29

Both of the solutions you presented didn't worked.

Also, i can't connect on my Xampp using "localhost", i have to use the IP "http://127.0.0.1:40" (The 40 is a modified port, because Skype is using port number 80)

Aniway, i thank you for the anwser.
Kowagaru
 
Posts: 6
Joined: 25. April 2012 14:06
Operating System: Windows 7 Home Basic 64x

Re: Error 2002 on PHPMy Admin

Postby lg1 » 03. May 2012 17:54

hackattack142 wrote:This sometimes fixes this error:
Try opening your "/xampp/mysql/bin/my.ini" file, and finding this line:
Code: Select all
#bind-address="127.0.0.1"
, remove the "#" in front of it, save the file, and restart MySQL. When you visit the phpMyAdmin page http://localhost/phpmyadmin make sure you manually refresh the page in your browser so you do not get a cached error page.


WOW :lol: THANKS hackattack142 - i have just registed to say thanks , its took me two days to get the mysql connection working
i have tried for 48 hours looking through countless forums and trying loads of fixes and 6 installs , and finally your fix has solved it

I have just done what you said - removed the " #" from that line and its working yiippee
Also as Hackattack142 says - remember to restart you mysql service

For other users -i was trying to install xammp on windows 7 64k and was getting the error

Connection for controluser as defined in your configuration failed

and the mysql server in xammp was showing deactivated but my services were running ok, it seems to be a firewall problem but had tried everything till this, its the 1st place i have come across this fix

Also i was having the same problem when trying to install mysql and apache as seperate items, and the mysql server instatnce was jamming after staring the mysql service - on the finall security part



Hope this also helps other users
thanks again
Lg
lg1
 
Posts: 2
Joined: 03. May 2012 16:51
Operating System: windows 7

Re: Error 2002 on PHPMy Admin [Solved]

Postby dugowe » 04. May 2012 12:49

Hello Thanks for your help but This solution haven't solved my problem. I have change all that mention above but I am still stack in this error for more than 3 days

This is mysql_error.log File
120505 16:09:48 [Note] Event Scheduler: Purging the queue. 0 events
120505 16:09:48 InnoDB: Starting shutdown...
120505 16:09:49 InnoDB: Shutdown completed; log sequence number 1595675
120505 16:09:49 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

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

Let see any body can find where the problem is coming from

regards
Dave
dugowe
 
Posts: 4
Joined: 04. May 2012 12:39
Operating System: Windows7 64Bit

Re: Error 2002 on PHPMy Admin [Solved]

Postby Kowagaru » 15. May 2012 13:24

Found a solution:

Go to Control Panel > Programs > Activate or Deactivate Windows Resources. There. Disable IIS on the checkbox. (Information and Internet Services)
Kowagaru
 
Posts: 6
Joined: 25. April 2012 14:06
Operating System: Windows 7 Home Basic 64x

Re: Error 2002 on PHPMy Admin [Solved]

Postby dugowe » 16. May 2012 08:04

Thank you for your reply, I have disable IIS but now I have this error message in step 4. I don't know what do do anymore I am frostrated
"No se puede conectar con la base de datos. Número de conector devuelto: 2
dugowe
 
Posts: 4
Joined: 04. May 2012 12:39
Operating System: Windows7 64Bit

Re: Error 2002 on PHPMy Admin [Solved]

Postby Kowagaru » 16. May 2012 13:11

That is when you try to install Joomla or Wordpress?
Kowagaru
 
Posts: 6
Joined: 25. April 2012 14:06
Operating System: Windows 7 Home Basic 64x

Re: Error 2002 on PHPMy Admin [Solved]

Postby dugowe » 17. May 2012 13:19

When I am trying to install Joomla
dugowe
 
Posts: 4
Joined: 04. May 2012 12:39
Operating System: Windows7 64Bit

Re: Error 2002 on PHPMy Admin [Solved]

Postby Kowagaru » 17. May 2012 16:00

First you need to go to your PHPMyAdmin and create a new database for Joomla (To do that, have to enter in your localhost/127.0.0.1, go in PHPMyAdmin, go in Database>Create New Database and name it. Remember that name.)

Then, in the Phase 4, try to leave like that:
Mysqli
localhost
root

the name of your database


Then click in Next.

That should work.
Kowagaru
 
Posts: 6
Joined: 25. April 2012 14:06
Operating System: Windows 7 Home Basic 64x

Re: Error 2002 on PHPMy Admin [Solved]

Postby dugowe » 17. May 2012 21:23

Kowagaru wrote:First you need to go to your PHPMyAdmin and create a new database for Joomla (To do that, have to enter in your localhost/127.0.0.1, go in PHPMyAdmin, go in Database>Create New Database and name it. Remember that name.)

Then, in the Phase 4, try to leave like that:
Mysqli
localhost
root

the name of your database


Then click in Next.

That should work.


Thank you again! the problem is I can not have access to phpMyAdmin I have a message of cotroluser is not configure. where should I configure the password for phpMyAdmin to have access to login as root to be able to create a user
dugowe
 
Posts: 4
Joined: 04. May 2012 12:39
Operating System: Windows7 64Bit

Re: Error 2002 on PHPMy Admin [Solved]

Postby Kowagaru » 18. May 2012 13:56

By default, PHPMyAdmin root account don't have a Password. Joomla should acept if you don't use any password.
Kowagaru
 
Posts: 6
Joined: 25. April 2012 14:06
Operating System: Windows 7 Home Basic 64x


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 59 guests