Mysql安装后必做的事情

mysql -u用户 -p密码
mysql> use mysql;
mysql> select host,user,password from mysql.user;
mysql> delete from mysql.user where host <> 'localhost';
如果误删 mysql.user中的localhost，使用以下语句：
grant all privileges on *.* to 'root'@'localhost' identified by '密码';
mysql> update mysql.user set host='%' where user='root';
mysql> flush privileges;

service mysql restart
mysql -hIP -u用户 -p密码		连接成功说明配置成功.

否则 Mysql 默认是拒绝外部链接的， 
SQL Error: Host ‘XXX’ is not allowed to connect to this MySQL server.

[root@Node4 mysql]# mysql -hNode3 -uroot -pcentos
Warning: Using a password on the command line interface can be insecure.

Mysql5.6版本以后默认命令行输入密码不安全，
	vi /etc.my.cnf
# 添加如下内容：
[client]
host=IP/主机名
user=数据库用户
password='数据库密码'

客户端直接 mysql 默认读取配置文件中的参数登录；
	mysqldump 也会不好用了,
[root@qttc ~]# /usr/local/mysql/bin/mysqldump  -uroot -proot db > bak.sql
Warning: Using a password on the command line interface can be insecure.
# 修改配置文件.
	vi /etc.my.cnf
# 添加如下内容：
[mysqldump]
user=your_backup_user_name
password=your_backup_password