MySQL notes ¶

Author: morlandi@brainstorm.it

Creato: Venerdì 14 Aprile 2017 15:55

Tags: mysql

Enable remote access

Comment this in file '/etc/mysql/mysql.conf.d/mysqld.cnf':

#bind-address           = 127.0.0.1

then

uninstall plugin validate_password;
grant all privileges on *.* to 'root'@'%' identified by 'XXXXXXXXXXXXX' with grant option;
flush privileges;