mysql

Auto Restart Mysql / MariaDB Using Monit In Ubuntu With EasyEngine

Install Monit $ sudo apt-get install monit Configure Monit to Monitor MySQL / MariaDB $ sudo nano /etc/monit/conf.d/mysql check process mysql with pidfile /run/mysqld/mysqld.pid start program = “/usr/sbin/service mysql start” with timeout 60 seconds stop program = “/usr/sbin/service mysql stop” if failed unixsocket /var/run/mysqld/mysqld.sock then restart $ sudo service monit reload Enable Monit service at boot time …

Auto Restart Mysql / MariaDB Using Monit In Ubuntu With EasyEngine Read More »

Cara Reset the MySQL root password on Ubuntu Linux

Ada kalanya mungkin kita lupa password root mysql di vps kita 😀 Nah ini dia caranya buat reset password root mysql kita 😉 Check it out yachhh….. Stop the MySQL Server. sudo /etc/init.d/mysql stop Start the mysqld configuration. sudo mysqld –skip-grant-tables & Login to MySQL as root. mysql -u root mysql Replace YOURNEWPASSWORD with your …

Cara Reset the MySQL root password on Ubuntu Linux Read More »

Pindah WP antar server

1. back up db mysqldump –u USERNAME –p DATABASENAME > FILENAME.sql 2. back up file tar cvzf wordpress.tar.gz * 3.  impor wp ke server baru wget serverlama.com/wordpress.tar.gz 4. extract tar -zxvf wordpress.tar.gz 5. create new DB mysql -u root -p CREATE DATABASE wordpress; GRANT ALL PRIVILEGES ON wordpress.* TO “wp_user”@”localhost” IDENTIFIED BY “ENTER_A_PASSWORD”; FLUSH PRIVILEGES; …

Pindah WP antar server Read More »