Mysql

。。。。。

hadoop@Master:/etc/init.d$ sudo mysql restart
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

解决办法：

hadoop@Master:/etc/init.d$ cd /etc/mysql
hadoop@Master:/etc/mysql$ mysql -uroot -p

登入MySQL后，更改 “MySQL” 数据库里的 “user” 表里的 “host” 项，从“localhost”改称“%

mysql> update user set host = '%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

。。。。

mysql>grant all privileges on *.* to 'user'@'%' identified by 'password' with grant option; mysql>FLUSH PRIVILEGES; 

user是用户名，mysql默认的是root ，password是密码自己设置 。%表示任意主机。这样就允许远程任意一台主机访问了。

示例：

mysql> grant all privileges on *.* to 'hadoop'@'%' identified by '000000fzx' with grant option;

结果：

mysql> select host, user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | hadoop           |
| %         | root             |
| localhost | debian-sys-maint |
| localhost | mysql.session    |
| localhost | mysql.sys        |
+-----------+------------------+

重启；

/etc/init.d/mysql  start

hadoop@Master:/usr/bin$ cd /etc/init.d/
hadoop@Master:/etc/init.d$ ./mysql restart
[ ok ] Restarting mysql (via systemctl): mysql.service.