[Faevilangel]

I have installed xampp on my vista laptop, and then installed magento but mysql won't start, I have turned it on using the xampp control panel but still no luck.

Anyone got any ideas? I used the xampp instructions & files here

the errors I get:

SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'localhost' (10061)
Trace:
#0 C:\xampp\htdocs\magento\lib\Varien\Db\Adapter\Pdo\ Mysql.php(211): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 C:\xampp\htdocs\magento\lib\Zend\Db\Adapter\Abstra ct.php(441): Varien_Db_Adapter_Pdo_Mysql->_connect()
#2 C:\xampp\htdocs\magento\lib\Zend\Db\Adapter\Pdo\Ab stract.php(230): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#3 C:\xampp\htdocs\magento\lib\Varien\Db\Adapter\Pdo\ Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#4 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Resource\Type\Db\Pdo\Mysql.php(45): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#5 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Resource.php(87): Mage_Core_Model_Resource_Type_Db_Pdo_Mysql->getConnection(Object(Mage_Core_Model_Config_Eleme nt))
#6 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Mysql4\Abstract.php(255): Mage_Core_Model_Resource->getConnection('core_read')
#7 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Mysql4\Abstract.php(270): Mage_Core_Model_Mysql4_Abstract->_getConnection('read')
#8 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Mysql4\Abstract.php(290): Mage_Core_Model_Mysql4_Abstract->_getReadAdapter()
#9 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Mysql4\Collection\Abstract.php(68): Mage_Core_Model_Mysql4_Abstract->getReadConnection()
#10 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Config.php(1086): Mage_Core_Model_Mysql4_Collection_Abstract->__construct(Object(Mage_Core_Model_Mysql4_Website ))
#11 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Config.php(1119): Mage_Core_Model_Config->getModelInstance('core_mysql4/web...', Object(Mage_Core_Model_Mysql4_Website))
#12 C:\xampp\htdocs\magento\app\Mage.php(347): Mage_Core_Model_Config->getResourceModelInstance('core/website_co...', Object(Mage_Core_Model_Mysql4_Website))
#13 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Abstract.php(200): Mage::getResourceModel('core/website_co...', Object(Mage_Core_Model_Mysql4_Website))
#14 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\Abstract.php(205): Mage_Core_Model_Abstract->getResourceCollection()
#15 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\App.php(405): Mage_Core_Model_Abstract->getCollection()
#16 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Mo del\App.php(268): Mage_Core_Model_App->_initStores()
#17 C:\xampp\htdocs\magento\app\Mage.php(434): Mage_Core_Model_App->init('', 'store', Array)
#18 C:\xampp\htdocs\magento\app\Mage.php(455): Mage::app('', 'store', Array)
#19 C:\xampp\htdocs\magento\index.php(65): Mage::run()
#20 {main} 

[notbanksy]

Are you sure that MySQL isn't starting, or is it that magento won't connect to it? Did you test XAMPP after you installed it but before you installed magento.

Also, are you sure you have the right information in the config file for magento? The default setup for xampp is username: root with no password, server name is localhost.

If it is a broken installation of xampp just download a fresh copy and reinstall. Let us know how you get on.

[Faevilangel]

The system is already set up in xampp, see the link I provided. Everything is configured and all I had to do is move all the files to the c:/ and then start apache and mysql through xampp control panel. I did this and it failed. I also did a port check and they are all clear...

I am at a loss to what to do now .... I don't know why but I tried to install mysql with wamp ages ago and that failed too.

[Faevilangel]

I just realised, in the xampp control panel it says

**warning:directory mismatch**

Would that be my problem??

[notbanksy]

Just because you followed the instructions doesn't mean XAMPP was working. Did you check it before you started using it?

Also, you say you've installed WAMPP previously. Did you uninstall it before trying XAMPP? Also you shouldn't need to install MySQL with WAMP as it's packaged. The clue is in the name Windows Apache Mysql Php. That installation of MySQL might be the reason why XAMPP isn't working....

[Faevilangel]

No what I meant was I can never get mysql running, always get errors.

The person who built the package had it running fine on his linux and xp machines, so it should work.

I am going to remove the whole lot and restart with a bare copy of xampp

[Faevilangel]

installed xampp and started apache, went to http://localhost/phpmyadmin/ and I get a blank page, but goint to http://localhost/ works fine!

Why isn't phpmyadmin loading, do I need to run an installer ? I went to http://localhost/phpmyadmin/install and it says

Quote

$Id: INSTALL 9537 2006-10-12 16:27:13Z nijel $

phpMyAdmin - Installation
-------------------------

Please have a look to the Documentation.txt or
Documentation.html files.

I suck at this stuff

[notbanksy]

Does the control centre show MySQL as running?

[Faevilangel]

I gave up on Xampp and installed wamp, working fine so far cept I can't access phpmyadmin, when i go to http://localhost/phpmyadmin I just get a white page. I tried using the link provided in the wamp menu too and got this, what am I doing wrong?

[pat24]

Faevilangel, on 18 March 2010 - 01:13 PM, said:

I gave up on Xampp and installed wamp, working fine so far cept I can't access phpmyadmin, when i go to http://localhost/phpmyadmin I just get a white page. I tried using the link provided in the wamp menu too and got this, what am I doing wrong?

A few things to check

1. check the xammp folder is definately gone
2. check that Mysql is allowed in your firewall

[Faevilangel]

pat24, on 18 March 2010 - 01:44 PM, said:

A few things to check

1. check the xammp folder is definately gone
2. check that Mysql is allowed in your firewall

Both correct, I can access the setup and have made the config file using the script but instead of a white page now, I am getting a firefox error page saying can't access the server.

I can't access http://localhost/phpmyadmin but can access http://localhost/phpmyadmin/setup

If I try to access file:///C:/wamp/apps/phpmyadmin3.2.0.1/index.php, it opens the file in notepad

[pat24]

Faevilangel, on 18 March 2010 - 01:58 PM, said:

Both correct, I can access the setup and have made the config file using the script but instead of a white page now, I am getting a firefox error page saying can't access the server.

I can't access http://localhost/phpmyadmin but can access http://localhost/phpmyadmin/setup

If I try to access file:///C:/wamp/apps/phpmyadmin3.2.0.1/index.php, it opens the file in notepad

At a guess I would say you have another instance of mysql running do a search for other mysql folders outside of the wamp directory, have you ever installed mysql as a stand alone app.

[Faevilangel]

pat24, on 18 March 2010 - 02:07 PM, said:

At a guess I would say you have another instance of mysql running do a search for other mysql folders outside of the wamp directory, have you ever installed mysql as a stand alone app.

Nope, I have checked the c:/ drive and nothing, there is zilch in the programs list too

When I go to localhost/phpmyadmin, I am getting the firefox error page with
"Firefox can't establish a connection to the server at localhost."

The apache service along with php & mysql are on also, I am using vista but have disabled the windows firewall and disabled comodo firewall, and the UAC is turned off.

[pat24]

Faevilangel, on 18 March 2010 - 02:11 PM, said:

Nope, I have checked the c:/ drive and nothing, there is zilch in the programs list too

When I go to localhost/phpmyadmin, I am getting the firefox error page with
"Firefox can't establish a connection to the server at localhost."

The apache service along with php & mysql are on also, I am using vista but have disabled the windows firewall and disabled comodo firewall, and the UAC is turned off.

are you running skype

also what do you get if you just type http://localhost

[Faevilangel]

pat24, on 18 March 2010 - 02:17 PM, said:

are you running skype

also what do you get if you just type http://localhost

I have it installed but it's not turned on though,

I get the wamp server start page

[pat24]

Not sure what to suggest, sorry

apart from a reeboot, at least then the servers will restart

[bisto]

if you are running under windows, have a look at the list of services that are currently running on your machine.

I had a problem getting my scripts to access mysql services after I installed media portal. This installs and uses mysql as a service. I usually don't let them run as services windows startup time.

if it is running, turn it off then restart the mysql server from the location wamp expects it.

[Faevilangel]

No other scripts are being used on the machine, I can access magento fine but phpmyadmin won't load.

I have rebooted the machine and still nada, how hard can it be to get apache running on vista

[pat24]

Faevilangel, on 18 March 2010 - 03:36 PM, said:

No other scripts are being used on the machine, I can access magento fine but phpmyadmin won't load.

I have rebooted the machine and still nada, how hard can it be to get apache running on vista

one last thing

in the phpmyadmin folder their should be a file called config.inc.php can you replace the section of code in your file with what is below, make a copy of the original file just incase.

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] 	= 'config';
$cfg['Servers'][$i]['user'] 	= 'root';
$cfg['Servers'][$i]['password'] 	= '';
$cfg['Servers'][$i]['AllowNoPassword'] 	= true;

/* Server parameters */
$cfg['Servers'][$i]['host'] 	= 'localhost';
$cfg['Servers'][$i]['connect_type'] 	= 'tcp';
$cfg['Servers'][$i]['compress'] 	= false;

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

[Faevilangel]

pat24, on 18 March 2010 - 03:40 PM, said:

one last thing

in the phpmyadmin folder their should be a file called config.inc.php can you replace the section of code in your file with what is below, make a copy of the original file just incase.

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] 	= 'config';
$cfg['Servers'][$i]['user'] 	= 'root';
$cfg['Servers'][$i]['password'] 	= '';
$cfg['Servers'][$i]['AllowNoPassword'] 	= true;

/* Server parameters */
$cfg['Servers'][$i]['host'] 	= 'localhost';
$cfg['Servers'][$i]['connect_type'] 	= 'tcp';
$cfg['Servers'][$i]['compress'] 	= false;

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

You absolute legend, it works. I used the set up script from phpmyadmin, so no idea why it didn't work, but yours does

Have some rep... cheers dude

I have an error on the page though, "Invalid server index: "" "

How do I fix that?

[pat24]

Faevilangel, on 18 March 2010 - 03:45 PM, said:

You absolute legend, it works. I used the set up script from phpmyadmin, so no idea why it didn't work, but yours does

Have some rep... cheers dude

I have an error on the page though, "Invalid server index: "" "

How do I fix that?

can you post the saved version of what you changed, it could be that you set a password when you originally set it up and the passwords dont correspond

[Faevilangel]

pat24, on 18 March 2010 - 04:10 PM, said:

can you post the saved version of what you changed, it could be that you set a password when you originally set it up and the passwords dont correspond

I set up no PW when I set up mysql, cos wamp doesn't ask for one, does it?

My file is what you put, and works cept for that error

I tried adding $i=1; but gives a white page

[pat24]

Faevilangel, on 18 March 2010 - 04:22 PM, said:

I set up no PW when I set up mysql, cos wamp doesn't ask for one, does it?

My file is what you put, and works cept for that error

I tried adding $i=1; but gives a white page

can you check you have this in config.inc.php

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;

[Faevilangel]

adding that code gives me the "firefox can't find the server" error

[pat24]

Faevilangel, on 18 March 2010 - 04:36 PM, said:

adding that code gives me the "firefox can't find the server" error

ok can you rename config.inc.php to something else and then save a file which is in the libraries directory called config.default.php and save it as config.inc.php to the location of the renamed file

[Faevilangel]

MySQL said: Documentation
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Invalid server index: ""
Open new phpMyAdmin window