Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
people:tomka [2019/10/15 11:43]
tomka
people:tomka [2019/10/15 16:56]
tomka [MySQL backup user]
Line 56: Line 56:
 ====== MySQL backup user ====== ====== MySQL backup user ======
    mysql -u root -p    mysql -u root -p
-   grant select, lock tables, super, process, reload on *.* to backup identified by '​tajneheslo'​+   use mysql
        
 +   ​select user from mysql.user; ​
 +   
 +   grant select, lock tables, super, process, reload on *.* to backup identified by '​cah7Eingoogh';​
 +   
 +  ​
 +   ​update user set password=password('​cah7Eingoogh'​) where user='​backup';​
 +   flush privileges;
 +   
 +   ​ctrl+d quit
 +   bacha na stredniky
 ====== Puppet ====== ====== Puppet ======
 spusteni puppetu na serveru : puppet agent -t spusteni puppetu na serveru : puppet agent -t
 
people/tomka.txt · Last modified: 2019/10/15 17:28 by tomka