Benutzer:PMay/vServer at Hetzner: Unterschied zwischen den Versionen
PMay (Diskussion | Beiträge) |
PMay (Diskussion | Beiträge) Keine Bearbeitungszusammenfassung |
||
Zeile 68: | Zeile 68: | ||
>> If you are migrating from MySQL, don't forget to run 'mysql_upgrade' | >> If you are migrating from MySQL, don't forget to run 'mysql_upgrade' | ||
after mysqld.service restart.</nowiki> | after mysqld.service restart.</nowiki> | ||
== MariaDB == | |||
* login to DB | |||
# mysql -u root -p |
Version vom 20. November 2013, 10:56 Uhr
network
- also see en:Network Configuration or en:Network Configuration#Static IP address
- proper values forIP adress and so on can be found from old debian installation at /etc/network/interfaces
- create and edit /etc/conf.d/network@ens3
- create and edit /etc/systemd/system/network@.service (without ens3 after @)
# systemctl enable network@ens3.service
- edit /etc/resolv.conf to setup name server (see same file from old debian installation for proper values)
sshd
- see also en:Secure Shell
- install openssh wih pacman
- enable it:
# 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