MySQL

From Q
Jump to navigation Jump to search

Initial Configuration

# systemd-tmpfiles --create
# mysql_install_db --basedir=/usr --datadir=/var/lib/mysql --user=mysql
# systemctl start mysql.service
# mysql_secure_installation

Change the root password

# mysqladmin -u root password 'new-password'

Allow external connections, e.g. for phpMyAdmin

# mysql -u root -p
$ mysql> CREATE USER 'root'@'host.domain.local' IDENTIFIED BY 'xxx';
$ mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'host.domain.local' IDENTIFIED BY 'xxx' WITH GRANT OPTION;
$ mysql> FLUSH PRIVILEGES;

Dump

mysqldump -uroot -p -hlocalhost --databases --opt --allow-keywords --flush-logs --hex-blob --max_allowed_packet=16M --quote-names --result-file=database_backup.SQL database

Restore

cat database.SQL | mysql database -uroot -p -hlocalhost --max_allowed_packet=16M