Script mysql non aggregate column
Jalankan Query dibawah ini. Untuk mengatasi error non aggregate column.
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Contekan reset password mysql di ubuntu
Script Ubuntu : sudo systemctl stop mysql sudo systemctl set-environment MYSQLD_OPTS="--skip-networking --skip-grant-tables" sudo systemctl start mysql sudo mysql -u root Script MYSQL : mysql> flush privileges; mysql> use mysql; mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password_baru'; mysql> flush privileges; mysql> quit; Script Ubuntu lagi : sudo systemctl unset-environment MYSQLD_OPTS
Komentar
Posting Komentar