Instalace a konfigurace mysql-serveru

# instalace mysql serveru
sudo apt-get install mysql-server
# mysql server ma data v adresari /var/lib/mysql

# pro reconfiguraci 
sudo dpkg-reconfigure myslq-server

# pro odinstalaci plna
sudo apt-get purge mysql-server

# pro odinstalaci pouze balicku data zustanou
sudo apt-get delete mysql-server
# od verze 18.04
sudo su -
mysql
# v mysql console
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

FLUSH PRIVILEGES;
\q
# konec konsole

#viz https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04
# pro dalsi konfiguraci server /etc/mysql/my.cnf

# zalohovani dat mysql servery
mysqldump [jmeno DB] -u [user] -p[password] > [soubor].sql
mysqldump --all-databases -u [user] -p[password] > [soubor].sql
mysqldump --all-databases -u root -proot > /tmp/zaloha.sql



#obnova dat DB serveru 
mysql [jmenoDB] -u [user] -p[password] < [soubor].sql

# zakladni prikazy pouzivani mysql
show databases;
use [database];
show tables;
select * from [table];

# mysql pracuje na portu 3306
netstat -vapnl|grep 3306
# mysql pracuje s file socketem 
socket = /var/run/mysqld/mysqld.sock