MySQL Password Allow

From MS Computech
Jump to: navigation, search
MySQL password&host stuff.

Use this for new password

# mysqladmin -u root password NEWPASSWORD

Use this for change

# mysqladmin -u root -p oldpassword newpass
==============================

Allow Access

mysql -uroot -p
use mysql;
select host, user from user;
update user set host='%' where user='root' and host='ubuntuserv';
flush privileges;
nano /etc/mysql/my.cnf
  1. bindaddress 127.0.0.1