Server/database: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „== Installation == <code>pkg install -y mariadb100-server</code> == Konfiguration == === MariaDB === : <code>'/usr/local/bin/mysqladmin' -u root password '…“) |
|||
| Zeile 11: | Zeile 11: | ||
==== Account ''semaphore'' ==== | ==== Account ''semaphore'' ==== | ||
: <code>mysql -u root -p</code> | : <code>mysql -u root -p</code> | ||
$ create database | <code> | ||
$ create user '<name-account>'@'<ip-client>' identified by '<password-account>'; | : $ create database [[Intern:Server#Datenbanken|<name-datenbank>]]; | ||
$ grant all on <name-datenbank>.* to '<name-account>'@'<ip-client>'; | : $ create user '<name-account>'@'<ip-client>' identified by '<password-account>'; | ||
: $ grant all on <name-datenbank>.* to '<name-account>'@'<ip-client>'; | |||
</code> | |||
Aktuelle Version vom 23. Mai 2017, 15:27 Uhr
Installation[Bearbeiten]
pkg install -y mariadb100-server
Konfiguration[Bearbeiten]
MariaDB[Bearbeiten]
'/usr/local/bin/mysqladmin' -u root password 'passwd'
Account semaphore[Bearbeiten]
mysql -u root -p
- $ create database <name-datenbank>;
- $ create user '<name-account>'@'<ip-client>' identified by '<password-account>';
- $ grant all on <name-datenbank>.* to '<name-account>'@'<ip-client>';