Trouble with PHP $connection command and MySQL

Question

Probably just because I'm not experienced with this sort of thing, but I downloaded MySQL with Apache running, and I'm working with the following code in a PHP file:

public static $connection = NULL;

private static $host = MYSQL_HOST;
private static $username = MYSQL_USER;
private static $passwd = MYSQL_PASS;
private static $db = MYSQL_DBNAME;

public static function init() {
  if(!self::$connection) {
    self::$connection = new mysqli(self::$host, self::$username, self::$passwd, self::$db);
}

}

It comes up with this when I open it in Firefox:

trying to connect via unix:///var/mysql/mysql.sock (says this doesn't exist—which, it doesn't)

I replaced MYSQL_HOST with 'localhost', MYSQL_USER with both 'mysql' and 'root' (stupid, yes), MYSQL_PASS with both my system password and NULL, and MYSQL_DBNAME with a few more things (I am having trouble finding out what my database name is called, even with MySQLWorkbench...I started learning this entire field of computing two days ago). It does say that a MySQL server is running on my machine, just not sure how to put the legos together here. Most of the settings are default (port 3306 and such). A test database migration over MySQLWorkBench failed (something to do with not reading the number of rows correctly), but otherwise it was fine and dandy, from what I saw.

Any help would be very welcome!

Don't kill your testability with statics!

deceze
– deceze ♦

2013-01-08 06:05:42 +00:00
Commented Jan 8, 2013 at 6:05 — deceze
– deceze ♦, Commented Jan 8, 2013 at 6:05
What operating system are you using?

Arjan
– Arjan

2013-01-08 07:00:40 +00:00
Commented Jan 8, 2013 at 7:00 — Arjan
– Arjan, Commented Jan 8, 2013 at 7:00
Sorry, failed to mention that—MAC OS X Mountain Lion

user1956177
– user1956177

2013-01-08 13:54:07 +00:00
Commented Jan 8, 2013 at 13:54 — user1956177
– user1956177, Commented Jan 8, 2013 at 13:54

Community · Accepted Answer · 2017-05-23 12:12:34Z

1

When you specify localhost as the host name, your computer will try to access the MySQL server using sockets in /var/mysql/mysql.sock. Since that file does not exist, this won't work. However, when you specify 127.0.0.1 as host name, the MySQL connection is set up over TCP/IP.

Comments

DWright · Accepted Answer · 2013-01-08 06:10:20Z

0

Try restarting SQL server. This may recreate the missing .sock file. See here for info on restarting: http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/

answered Jan 8, 2013 at 6:10

DWright

9,5594 gold badges39 silver badges57 bronze badges

Collectives™ on Stack Overflow

Trouble with PHP $connection command and MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related