Benutzer:PMay/vServer at Hetzner: Unterschied zwischen den Versionen

Aus wiki.archlinux.de
Zeile 77: Zeile 77:
   CREATE USER 'wp'@'localhost' IDENTIFIED BY 'somepassword';
   CREATE USER 'wp'@'localhost' IDENTIFIED BY 'somepassword';
   CREATE DATABASE wp_db;
   CREATE DATABASE wp_db;
  GRANT ALL PRIVILEGES ON wp_db.* TO 'wp'@'localhost';

Version vom 20. November 2013, 11:05 Uhr

network

 # systemctl enable network@ens3.service
  • edit /etc/resolv.conf to setup name server (see same file from old debian installation for proper values)

sshd

 # systemctl enable sshd.service

activate swap partition

 # mkswap /dev/sda1
 # swapon /dev/sda1

edit /etc/fstab and add this line at bottom

 /dev/sda1           	none      	swap      	defaults  	0 0

LAMP

 #  pacman -S apache php php-apache mariadb

Installing MariaDB/MySQL system tables in '/var/lib/mysql' ... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following commands: '/usr/bin/mysqladmin' -u root password 'new-password' '/usr/bin/mysqladmin' -u root -h eniac password 'new-password' Alternatively you can run: '/usr/bin/mysql_secure_installation' which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the MariaDB Knowledgebase at http://kb.askmonty.org or the MySQL manual for more instructions. You can start the MariaDB daemon with: cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql' You can test the MariaDB daemon with mysql-test-run.pl cd '/usr/mysql-test' ; perl mysql-test-run.pl Please report any problems with the '/usr/scripts/mysqlbug' script! The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com Support MariaDB development by buying support/new features from Monty Program Ab. You can contact us about this at sales@montyprogram.com. Alternatively consider joining our community based development effort: http://kb.askmonty.org/en/contributing-to-the-mariadb-project/ >> If you are migrating from MySQL, don't forget to run 'mysql_upgrade' after mysqld.service restart.

MariaDB

  • login to DB
 # mysql -u root -p
 CREATE USER 'wp'@'localhost' IDENTIFIED BY 'somepassword';
 CREATE DATABASE wp_db;
 GRANT ALL PRIVILEGES ON wp_db.* TO 'wp'@'localhost';