CODEWITHSUNDEEP
phpmysql
Sandi Budic
Sandi Budic

Reputation: 59

How to connect with PhpMyAdmin to the localhost via a Unix socket?

Can someone help with connecting to my web server?

In phpMyAdmin database is Server: localhost:3306 when click on it I get:

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.52-cll - MySQL Community Server (GPL)

So how I can connect on it without an address or an IP?

The PhpMyAdmin and the MySQL run on the same, non-local system.

Upvotes: 1

Views: 9182

Answers (2)

hanshenrik
hanshenrik

Reputation: 21513

in config.inc.php, instead of

$cfg['Servers'][$i]['host'] = 'localhost';

set

$cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';

Upvotes: 0

num8er
num8er

Reputation: 19372

Probably You wanted this:

$socket = '/var/run/mysqld.sock'; // or: /tmp/mysqld.sock
$db = new mysqli('localhost', 'username', 'password', "database", 3306, $socket);
// $db = mysql_connect('localhost:'.$socket, 'username', 'password');

Upvotes: 2

Related Questions