Contekan mycnf mysql non aggregate column
Edit file mycnf di server database (mysql)
Tambahkan baris dibawah
[mysqld]
sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
Kemudian restart mysql.
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