ab 5.3

mysql-server

ab 7

mariadb-server

mysql-server

mysql

¹⁾

service mysqld start
chkconfig mysqld on

ab 7

service mariadb start
chkconfig mariadb on

service mysql start
chkconfig mysql on

MySQL wird bei der Installation automatisch gestartet

/usr/bin/mysqladmin -u root password 'vogelsang'

MySQL root Passwort wird bei der Installation gesetzt

dpkg-reconfigure mysql-server-5.0

Ubuntu (14.04):

dpkg-reconfigure mariadb-server-5.5

service mysql stop

²⁾

set-mysql-root-password.sql :

UPDATE mysql.user SET Password=PASSWORD('villa') WHERE User='root';
FLUSH PRIVILEGES;

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 &

mysql -u root -p

rm $MYSQL_HOME/set-mysql-root-password.sql
pkill mysqld
service mysql start

  mysql -u root -p 
  CREATE DATABASE keystone;

oder

mysql -u root -p -e 'CREATE DATABASE keystone'

  SHOW DATABASES;

mysql -u root -p

  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;

mysql -u keystone_user -p
SHOW DATABASES;

mysql_secure_installation

mysqldump keystone_db | gzip > keystone_db.mysql.gz

echo 'drop database keystone_db;' | mysql

evtl. bestehende Datenbank löschen, neue anlegen, dann so befüllen:

zcat keystone_db.mysql.gz | mysql keystone_db

• http://www.pantz.org/software/mysql/mysqlcommands.html