Apache Friends Support Forum

I am looking to run a local server and database for using Joomla locally on my computer.

I have installed XAMPP using the installer and the control panel shows that that all is running. however when I click phpMyAdmin I get a #2002 error message.

Open in your text editor \xampp\mysql\bin\my.ini file and remove the # from in front of this line so it looks like this

Code: Select all

bind-address="127.0.0.1"

Save the file and restart MySQL.

Now try phpMyAdmin again.

Also make sure that this is the first line after the comments in your C:\Windows\system32\drivers\etc\HOSTS file

Code: Select all

127.0.0.1 localhost

Add it if not.

Hi
I cannot see my.ini in \xampp\mysql\bin\my.ini file, although I do have Folder Option set to show hidden files.

C:\Windows\system32\drivers\etc\HOSTS file is OK.

You need to show files with known file extensions also in your Windows folder configuration.

Remove the tick in the box next to Hide extensions for known file types.

Sharley wrote:You need to show files with known file extensions also in your Windows folder configuration.

Remove the tick in the box next to Hide extensions for known file types.

How do I show files with known file extensions in the Windows folder configuration? The Hide extensions for known file types is unchecked.

In the XAMPP control panel shows MySQL as deactivated?

You may have issues with the XAMPP installer version that sometimes gives issues with some Windows installations.

Try uninstalling XAMPP again then install using a different method by following closely the instructions in this post:
viewtopic.php?p=179699#p179699


When and if you reinstall, you could use the version 3 control panel found in the xampp installation folder:
xampp-control-3-beta.exe

The very latest version download link is in my signature.
Simply extract all the files from the archive to the xampp installation folder and overwrite when asked.
Then right click the exe file to run as administrator and to create a shortcut to the desktop, for example, for easier access.

This version has a more informative log window than the older 2.5 version.

After removing xampp is it best to restart the computer?

It won't do any harm to reboot the PC so you have a clean fresh start to use the zip method.

Sorry about this, but cannot quite understand the process or where the version 3 exe file is in your signature.

I have resolved my problem, I decided to upload XAMPP version 1.7.3 instaed of version 1/7/7 and everything went very well, now up and running with my local Joomla website. I would like to thank everyone that offered help.