Difference between revisions of "MySQL Password Allow"
From MS Computech
(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...) |
(No difference)
|
Latest revision as of 16:55, 1 December 2008
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
- bindaddress 127.0.0.1
