MySQL Bin Files Memakan Banyak Space Hardisk Server

Disable MySQL binlogging If you are not replicating, you can disable binlogging by changing your my.ini or my.cnf file. Open your my.ini or /etc/my.cnf (/etc/mysql/my.cnf), enter:# vi /etc/my.cnfFind a line that reads “log_bin” and remove or comment it as follows: #log_bin = /var/log/mysql/mysql-bin.log You also need to remove or comment following lines: #expire_logs_days = 10 #max_binlog_size = 100M Close and save the fi ...

View More
  Dibaca 186 kali

cant login as mysql user root from normal user account in ubuntu 18.04

So in order to to change the plugin back to mysql_native_password: Login with sudo: sudo mysql -u root Change the plugin and set a password with a single command: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test'; note test is your password   OR    ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret") ...

View More
  Dibaca 148 kali