# 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