xampp cannont use phpmyadmin ( mysql error ) -
i installed xampp on manjaro ( archlinux distribution ) cannot use phpmyadmin mysql seems not respond.
use sudo xampp start
output follows :
xampp: starting apache...ok. xampp: starting mysql...ok. xampp: starting proftpd...ok.
but when trying restart using sudo xampp restart
, displays :
xampp: stopping apache...ok. xampp: stopping mysql...not running. xampp: stopping proftpd...ok. xampp: starting apache...ok. xampp: starting mysql...ok. xampp: starting proftpd...ok.
when connecting http://localhost/phpmyadmin/ welcome displayed 4 errors displayed in order :
\#2002 - no such file or directory — server not responding (or local server's socket not correctly configured). mysqli_real_connect(): (hy000/2002): no such file or directory connection controluser defined in configuration failed. mysqli_real_connect(): (hy000/2002): no such file or directory
after researching, did notice missing /opt/lampp/var/mysql/mysql.sock
file not know how create , configure it.
i tryed use mysqld
seen in few tutorials got these errors :
2017-04-14 12:41:29 140391574202432 [note] mysqld (mysqld 10.1.22-mariadb) starting process 4483 ... 2017-04-14 12:41:29 140391574202432 [error] mysqld: file './mysql-bin.index' not found (errcode: 13 "permission denied") 2017-04-14 12:41:29 140391574202432 [error] aborting
sounds you'll need check local socket configuration. configured in /etc/mysql/my.cnf
, should following:
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock
open phpmyadmin config file (config.inc.php
) , change socket address. maybe there's no local socket configuration on phpmyadmin, or maybe different. file should contain line (of course, adapt address found on my.cnf
):
$cfg['servers'][$i]['socket'] = '/var/run/mysqld/mysqld.sock';
Comments
Post a Comment