From ArchWiki
Revision as of 00:24, 6 May 2013 by Kurtis (talk | contribs) (Helpful info regarding config file, open_basedir, and a sample Nginx "sub-folder": new section)
Jump to: navigation, search

I have just installed mysql, and I've got

  1. mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Thanks to the wiki i've done:

General MySQL Connectivity

Check /var/run/mysqld for mysqld.sock and /tmp for mysql.sock. If mysql.sock doesn't exist, create a softlink:

  1. ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

Then restart the daemon:

  1. /etc/rc.d/mysqld restart

But should the mysql package do this?


in the section that begins with;

Use for PHP 5.x:

AddHandler php5-script php


AddHandler php5-script .php

It's the same, see the official documentation:
"The extension argument is case-insensitive and can be specified with or without a leading dot." -- Kynikos 04:35, 4 June 2011 (EDT)

deny from all (.htaccess for phpmyadmin)

Commenting out 'deny from all' as the article states will allow everyone access. Wouldn't a safer way to do this be:

deny from all
allow from localhost
allow from

Or something to this extent? Axanon 06:54, 19 June 2011 (EDT)

Helpful info regarding config file, open_basedir, and a sample Nginx "sub-folder"

I ran into some issues while configuring. It took me a really long time to realize why my file wasn't being read after updating it.

The Wiki page currently states:

Update open_basedir in /etc/php/php.ini and add "/usr/share/webapps/".

It should emphasize that /etc/webapps is needed. This is very important and I spent a lot of time debugging.

The wiki page should mention that the configuration file is located in /etc/webapps/phpmyadmin (unless it already does. Maybe I overlooked it?)

Also, here is a sample configuration for using PHPMyAdmin as a sub-folder instead of a document root. It assumes PHPMyAdmin is linked at /srv/http/phpmyadmin. This may not be perfect but it is working for me. It follows the current configuration instructions and doesn't stray away from them as far as I can tell.

server {
   location /phpmyadmin {
       root           /srv/http/;
       index          index.php;
   location ~ ^/phpmyadmin.+.php$ {
       root           /srv/http/; # Assumes PHPMyAdmin is linked at /srv/http/phpmyadmin
       fastcgi_pass   unix:/var/run/php-fpm/php-fpm.sock;
       fastcgi_index  index.php;
       fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
       include        fastcgi_params;

--Kurtis (talk) 00:24, 6 May 2013 (UTC)