create mysql database on mac os x

Question

I know this sounds a little ridiculous, but I'm just honestly wondering how I can create a MySQL database on my Mac OS X machine. I have MySQL installed (as far as I know) as well as PHP, and I'm wondering how I can create one.

I have downloaded a sample PHP ecommerce site to kind of delve into what I'm trying to familiarze myself with, and the PHP files are attempting to connect to a nonexistant database, which I'm hoping to create right now.

Do they have an extension of .sock? Because, here is the "error" code when I try to test a PHP page referencing the nonexistant database:

Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in< /Library/WebServer/Documents/plaincart/library/database.php on line 4 Warning: mysql_connect(): No such file or directory in
/Library/WebServer/Documents/plaincart/library/database.php on line 4 MySQL connect failed. No such file or directory

if you are as lazy as I am, you may consider XAMPP on Mac as a good all-in-one package of MAMP :) — Michael Mao
– Michael Mao, Commented Oct 18, 2010 at 22:31
No solution, but maybe an easier alternative: MAMP: Mac, Apache, MySQL, PHP — Alec
– Alec, Commented Oct 18, 2010 at 22:31
@Michael Thanks for that! Although I'm not lazy (well, never-mind!), just overwhelmed by the massive amounts of sudoing and terminal commands necessary for all of this to work just right. Thanks for the sample @Alec — Qcom
– Qcom, Commented Oct 18, 2010 at 22:34
Also, just wondering, does it matter if I already installed PHP and partially installed MySQL? — Qcom
– Qcom, Commented Oct 18, 2010 at 22:36

Pekka · Accepted Answer · 2010-10-18 22:31:10Z

6

My guess is you are specifying the database server as localhost somewhere. Try 127.0.0.1 instead.

answered Oct 18, 2010 at 22:31

Pekka

451k150 gold badges990 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Qcom Over a year ago

I can't seem to find it, but I'm still checking, also, I'm trying this out on my localhost if that makes a difference.

Pekka Over a year ago

@BOSS yup, 127.0.0.1 can still be correct. It's probably somewhere in the E-Commerce system's settings

Qcom Over a year ago

Hmm, just saying, I ran this through XAMPP on my Mac, and got this now: Cannot select database. Unknown database 'phpwebco_shop'. Wondering if it's still the sample problem, considering I don't have a database yet.

Pekka Over a year ago

@BOSS nope - it's solved, you are now talking to your database. That is a new issue, you'll probably need to set up a database for the E-Commerce package. The installation instructions should help you there

ofi · Accepted Answer · 2010-10-18 23:57:26Z

2

I had this problem once with WordPres on Mac OS X. The answer was to name the local machine in the db connection configuration 'Localhost' with capital 'L', because on OS X localhost != Localhost.

answered Oct 18, 2010 at 23:57

ofi

3841 silver badge4 bronze badges

Comments

CodeTwice · Accepted Answer · 2010-10-19 00:23:14Z

2

I had the same problem with MySQL on the OSX. It turned out that the MySQL server was actually set up to use a different socket than the default setting in PHP.

PHP was looking in /var/mysql/mysql.sock, while mysql was creating the socket in /tmp/mysql.sock.

I fixed it by editing the php.ini and set mysql.default_socket = /tmp/mysql.sock

answered Oct 19, 2010 at 0:23

CodeTwice

2,9763 gold badges20 silver badges18 bronze badges

Collectives™ on Stack Overflow

create mysql database on mac os x

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related