Database server is not found on Mac using MAMP

[Ben90]

Hi guys,

 

I am trying to install database on my macbook. I am using MAMP as the local server.

 

Host: localhost

Port: 3306

User: root

Password: root

Socket: /Applications/MAMP/tmp/mysql/mysql.sock

 

I am sure I type everything correct including the db name. But this is what I got:

 

Database Server is not found. Please verify the login, password and server fields (DbPDO)

 

Anyone has a clue what is happening here?

 

Anyway this prestashop installation file I got from themeforest as I purchase their themes. It shouldn't be the problem, right?

Edited April 11, 2015 by rukano (see edit history)

[Ben90]

Never had this kind of trouble in windows. I'm trying to install it in windows using wmware on mac, everything is running smoothly.

 

Well, if there's any mac user & happy to share, I'll appreciate that. Thanks

[JoelWebsites]

try host as 127.0.0.1 ?

[bellini13]

does MAMP include a file called testmysql.php in the doc root?

 

if it does, then edit the file to add your hostname, username and password and then try to visit the testmysql.php in your browser to confirm it can connect

if it does not include this, then create the file with the contents below, and update it to use your db information and confirm you can connect.

<?php
$link = mysql_connect('hostname','dbuser','dbpassword');
if (!$link) {
    die('Could not connect to MySQL: ' . mysql_error());
}
echo 'Connection OK'; mysql_close($link);
?>

This really has nothing to do with Prestashop, in the future you might be better off using the MAMP forums