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

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -