MySQL Password Allow

From MS Computech
Revision as of 16:55, 1 December 2008 by Snifer (talk | contribs) (New page: ===== MySQL password&host stuff. ===== Use this for new password <pre># mysqladmin -u root password NEWPASSWORD</pre> Use this for change <pre># mysqladmin -u root -p oldp...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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