Difference between revisions of "Talk:Server"

From ArchWiki
Jump to: navigation, search
(Configuration: LAMP has more update info.)
(Delete out of dated mysql info.)
Line 1: Line 1:
== Original Document ==
{{Box Note|This document was the original and is kept here for reference during the rewrite}}
==== MySQL ====
* Configure MySQL as described at the [[MySQL]] wiki.
* Edit <code>/etc/php/php.ini</code> (this is in <code>/usr/etc</code> on older systems) to uncomment the following line (''By removing <code>;</code>''):
* You can add minor privileged users for your web scripts by editing the tables found in the <code>mysql</code> database. You have to restart MySQL for changes to take effect. Don't forget to check the <code>mysql/users</code> table. If there's a second entry for root and your hostname is left with no password set, everybody from your host probably could gain full access. Perhaps see next section for these jobs.
* Run in terminal (as root):
# /etc/rc.d/mysqld start
* MySQL should now be running. Test by visiting <code>http://localhost/phpMyAdmin</code> in a web browser - for testing by phpMyAdmin, you should have installed phpMyAdmin (<code>pacman -S phpmyadmin</code>). It should display phpMyAdmin main page.
* Edit <code>/etc/rc.conf</code> (to start MySQL at boot):
DAEMONS=(... '''mysqld''' ...)
'''Or''' add this line to <code>rc.local</code>:
/etc/rc.d/mysqld start
* You can get the "<code>error no. 2013: Lost Connection to mysql server during query</code>" message instantly whenever you try to connect to the MySQL daemon by TCP/IP. This is the TCP wrappers system (tcpd), which uses the <code>hosts_access(5)</code> system to allow or disallow connections.
* If you're running into this problem, be sure to add this to your /etc/hosts.allow file:
  # mysqld : ALL : ALLOW
  # mysqld-max : ALL : ALLOW
  # and similar for the other MySQL daemons.
* Notes: The examples above are the simplest case, telling tcpd to allow connections from anywhere. You may wish to use a more-appropriate choice of permissible sources instead of ALL. Just make sure that localhost and the IP address (numeric or DNS) of the interface by which you connect are specified.
* You might also need to edit <code>/etc/my.cnf</code> and comment out the <code>skip-networking</code> line as such:

Revision as of 13:01, 17 December 2012