centos6.5安装mysql

• 查看mysql是否安装

[root@node1 lib]# rpm -qa |grep mysql
mysql-libs-5.1.71-1.el6.x86_64

• 安装

[root@node1 ~]# yum -y install mysql-server
检查
[root@node1 ~]# rpm -qa |grep mysql
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-server-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64

• 重启

[root@node1 ~]# service mysqld restart

• 操作：

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select user,host from user;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
|      | localhost |
| root | localhost |
|      | node1     |
| root | node1     |
+------+-----------+
5 rows in set (0.03 sec)

---------------------------
mysql> delete from user where user='';
Query OK, 2 rows affected (0.09 sec)

mysql> select user,host from user;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
| root | localhost |
| root | node1     |
+------+-----------+
3 rows in set (0.00 sec)

mysql> update user set password=PASSWORD('123456') where user='root';
Query OK, 2 rows affected (0.03 sec)
Rows matched: 3  Changed: 2  Warnings: 0

mysql> flush privileges;#设置权限
Query OK, 0 rows affected (0.00 sec)
------------------
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | node1     | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | 127.0.0.1 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+------+-----------+-------------------------------------------+
3 rows in set (0.00 sec)

#配置密码
[root@node1 ~]# mysqladmin -u root password '123456'
[root@node1 ~]# mysql -uroot -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

设置远程登录

mysql> grant all PRIVILEGES on *.* to root@'%'  identified by '123456' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)