mysql_connect( ) function not having the right username-password

Question

I'm new to PHP and MySQL and I'm having a problem with MySQL database, on how to create that username-password combination for the mysql_connect() function on a Mac 10.10. Have a look at this excerpt of code from WROX book: Beginning PHP5, Apache and MySQL web development. Please help me, thanks in advance.

<?php

$connect = mysql_connect("localhost", "b5pm", "bm5pm") or die ("Hey loser, check your server connection.");

$create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") or die(mysql_error());

mysql_select_db("moviesite"); ... ?>

Is that the username and password for when you set up your database? — Harry, Oct 24 '14 at 07:16
Can you show the error message you are getting? Also are you using xampp? — Harry, Oct 24 '14 at 07:26
No i'm not using XAMPP, here it is: Warning: mysql_connect(): No such file or directory in /Library/WebServer/Documents/doc/createmovie.php on line 4 Hey loser, check your server connection. — Alvarez, Oct 24 '14 at 07:28
It seems your mac is looking in the wrong place try this answer http://stackoverflow.com/questions/4219970/warning-mysql-connect-2002-no-such-file-or-directory-trying-to-connect-vi — Harry, Oct 24 '14 at 07:32

score 1 · Accepted Answer · answered Oct 24 '14 at 07:41

1

It seems your mac is using a UNIX socket, please change from "localhost" to "127.0.0.1"

answered Oct 24 '14 at 07:41

Harry

3,031
7
42
67

mysql_connect( ) function not having the right username-password

1 Answers1