Hier werden die Unterschiede zwischen zwei Versionen gezeigt.
lpi2:mysql [2017/09/22 14:51] |
lpi2:mysql [2022/08/15 14:32] (aktuell) |
||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | ====== Installation MySQL ====== | ||
+ | ===== Pakete ===== | ||
+ | === CentOS === | ||
+ | ab 5.3 | ||
+ | mysql-server | ||
+ | |||
+ | ab 7 | ||
+ | mariadb-server | ||
+ | |||
+ | === Debian ab 5.0 === | ||
+ | mysql-server | ||
+ | |||
+ | === OpenSuSE ab 11.1 === | ||
+ | mysql | ||
+ | (( installiert in openSuSE 12.1 das Paket ''mysql-community-server'' )) | ||
+ | |||
+ | ===== MySQL starten ===== | ||
+ | === CentOS === | ||
+ | |||
+ | service mysqld start | ||
+ | chkconfig mysqld on | ||
+ | |||
+ | ab 7 | ||
+ | service mariadb start | ||
+ | chkconfig mariadb on | ||
+ | |||
+ | === OpenSuSE === | ||
+ | service mysql start | ||
+ | chkconfig mysql on | ||
+ | |||
+ | === Debian / Ubuntu === | ||
+ | MySQL wird bei der Installation automatisch gestartet | ||
+ | |||
+ | ===== MySQL root Passwort setzen ===== | ||
+ | === SuSE, CentOS === | ||
+ | /usr/bin/mysqladmin -u root password 'vogelsang' | ||
+ | === Debian / Ubuntu === | ||
+ | MySQL root Passwort wird bei der Installation gesetzt | ||
+ | dpkg-reconfigure mysql-server-5.0 | ||
+ | |||
+ | ====== Vergessenes root Passwort neu setzen ====== | ||
+ | Ubuntu (14.04): | ||
+ | dpkg-reconfigure mariadb-server-5.5 | ||
+ | |||
+ | ===== MySQL anhalten ===== | ||
+ | === openSuSE 12.1 === | ||
+ | service mysql stop | ||
+ | |||
+ | ===== MySQL Passwort setzen ===== | ||
+ | (( laut http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html weniger sicher, aber dafür schneller geht es so: | ||
+ | mysqld_safe --skip-grant-tables --skip-networking & | ||
+ | mysql | ||
+ | UPDATE mysql.user SET Password=PASSWORD('villa') WHERE User='root'; | ||
+ | FLUSH PRIVILEGES; | ||
+ | )) | ||
+ | |||
+ | ''set-mysql-root-password.sql'' : | ||
+ | <file> | ||
+ | UPDATE mysql.user SET Password=PASSWORD('villa') WHERE User='root'; | ||
+ | FLUSH PRIVILEGES; | ||
+ | </file> | ||
+ | chown mysql set-mysql-root-password.sql | ||
+ | chmod 600 set-mysql-root-password.sql | ||
+ | MYSQL_HOME=$(getent passwd mysql | cut -d: -f 6) | ||
+ | mv set-mysql-root-password.sql $MYSQL_HOME | ||
+ | mysqld_safe --init-file=$MYSQL_HOME/set-mysql-root-password.sql & | ||
+ | |||
+ | ===== testen ===== | ||
+ | mysql -u root -p | ||
+ | ===== mysql neu starten ===== | ||
+ | rm $MYSQL_HOME/set-mysql-root-password.sql | ||
+ | pkill mysqld | ||
+ | service mysql start | ||
+ | |||
+ | ====== Datenbank anlegen ====== | ||
+ | <code sql> | ||
+ | mysql -u root -p | ||
+ | CREATE DATABASE keystone; | ||
+ | </code> | ||
+ | oder | ||
+ | mysql -u root -p -e 'CREATE DATABASE keystone' | ||
+ | |||
+ | ===== Datenbanken anzeigen ===== | ||
+ | <code sql> | ||
+ | SHOW DATABASES; | ||
+ | </code> | ||
+ | |||
+ | ====== Benutzer anlegen ====== | ||
+ | mysql -u root -p | ||
+ | <code sql> | ||
+ | GRANT ALL PRIVILEGES ON keystone_db.* TO 'keystone_user'@'localhost' IDENTIFIED BY 'keystone_pw'; | ||
+ | GRANT ALL PRIVILEGES ON keystone_db.* TO 'keystone_user'@'%' IDENTIFIED BY 'keystone_pw'; | ||
+ | flush privileges; | ||
+ | </code> | ||
+ | |||
+ | ===== testen: als Benutzer anmelden ===== | ||
+ | mysql -u keystone_user -p | ||
+ | SHOW DATABASES; | ||
+ | |||
+ | ====== MySQL Installation absichern ====== | ||
+ | mysql_secure_installation | ||
+ | |||
+ | ====== Datenbank sichern ====== | ||
+ | mysqldump keystone_db | gzip > keystone_db.mysql.gz | ||
+ | |||
+ | ====== Datenbank löschen ====== | ||
+ | echo 'drop database keystone_db;' | mysql | ||
+ | |||
+ | ====== Datenbank wiederherstellen ====== | ||
+ | evtl. bestehende Datenbank löschen, neue anlegen, dann so befüllen: | ||
+ | zcat keystone_db.mysql.gz | mysql keystone_db | ||
+ | |||
+ | |||
+ | ====== Dokumentation ====== | ||
+ | * http://www.pantz.org/software/mysql/mysqlcommands.html | ||
+ | |||