https://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y

/etc/init.d/mysql stop

mysqld_safe --skip-grant-tables &

mysql -u root


sudo mysqld_safe --skip-grant-tables --skip-networking
mysql -u root -p

CREATE DATABASE cbts6;


CREATE USER 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

masalah max_allowed_packet

login root mysql -u root -p
set global net_buffer_length=1000000; 
set global max_allowed_packet=1000000000;

https://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes