CentOS6.5下二进制安装mysql-5.6.27

感谢分享：http://blog.csdn.net/zq9017197/article/details/49871973

1. MysqL的安装分为三种：1、RPM包安装；2、二进制包安装；3、源码安装。
2. 第一种方式比较简单，直接RPM包安装就OK了，或者通过yum源来安装，而第三种方式比较复杂。
3. 一般项目中使用比较多的是通过二进制包来安装，这种安装方式可以根据企业的不同需求进行相关的自定义配置，比如安装在哪个目录，如何配置等。
4. 现在具体介绍一下MysqL的二进制安装方式
6. 1：查看系统版本
7. [root@CentOS~]#cat/etc/redhat-release
8. CentOSrelease6.5(Final)
9. 2：添加用户和组
10. [root@CentOSMysqL]#groupaddMysqL
11. [root@CentOSMysqL]#useradd-r-gMysqLMysqL
12. 3：安装MysqL到/usr/local/MysqL下
13. [root@CentOS~]#cd/tmp
14. [root@CentOStmp]#llmysql-5.6.27-linux-glibc2.5-i686.tar.gz
15. -rw-r--r--.1rootroot30405622611月1704:12mysql-5.6.27-linux-glibc2.5-i686.tar.gz
16. [root@CentOStmp]#tarzxfmysql-5.6.27-linux-glibc2.5-i686.tar.gz-C/usr/local/
17. [root@CentOStmp]#cd/usr/local/
18. [root@Centoslocal]#mvmysql-5.6.27-linux-glibc2.5-i686/MysqL
19. [root@Centoslocal]#chown-RMysqL:MysqLMysqL/
20. [root@CentOSMysqL]#mkdir/mydata
21. [root@CentOSMysqL]#chown-RMysqL:MysqL/mydata
23. 4：初始化MysqL
24. [root@CentOS/]#cd/usr/local/MysqL
25. [root@CentOSMysqL]#./scripts/MysqL_install_db--user=MysqL--basedir=/usr/local/MysqL--datadir=/mydata
26. [root@CentOSMysqL]#chown-RMysqL:MysqL*
27. 5：修改MysqL主配置文件
28. [root@CentOSMysqL]#cd/usr/local/MysqL
29. [root@CentOSMysqL]#cpsupport-files/my-default.cnf/etc/my.cnf##注：如果/etc/my.cnf文件存在，则覆盖。
30. [root@CentOSMysqL]#vi/etc/my.cnf
31. [client]
32. password=123456
33. port=3306
34. default-character-set=utf8
35. [MysqLd]
36. datadir=/mydata
37. port=3306
38. character_set_server=utf8
39. character_set_client=utf8
40. collation-server=utf8_general_ci
41. lower_case_table_names=1
42. max_connections=1000
43. [MysqL]
44. 6：为MysqL提供服务脚本
45. [root@CentOSMysqL]#cd/usr/local/MysqL
46. [root@CentOSMysqL]#cpsupport-files/MysqL.server/etc/rc.d/init.d/MysqLd
47. 7：添加开启自启
48. [root@CentOSinit.d]#chkconfig--addMysqLd
49. [root@CentOSinit.d]#chkconfigMysqLdon
50. 8：启动MysqL
51. [root@CentOSinit.d]#serviceMysqLdstart
52. StartingMysqL...[确定]
53. [root@CentOSinit.d]#serviceMysqLdstatus
54. MysqLrunning(2068)[确定]
55. 9：添加环境变量
56. [root@CentOSbin]#vi/etc/profile
57. PATH=/usr/local/MysqL/bin:/usr/local/MysqL/lib:$PATH
58. exportPATH
59. 或
60. [root@CentOSinit.d]#ln-s/usr/local/MysqL/bin/MysqL/usr/bin
61. 10：登录MysqL，修改密码，删除空用户（密码为空）
62. [root@CentOSinit.d]#MysqL-uroot-p-S/tmp/MysqL.sock
63. MysqL>selectuser,host,passwordfromMysqL.user;
64. +------+-----------+----------+
65. |user|host|password|
66. |root|localhost||
67. |root|centos||
68. |root|127.0.0.1||
69. |root|::1||
70. ||localhost||
71. ||centos||
72. +------+-----------+----------+
73. 6rowsinset(0.00sec)
74. MysqL>updateMysqL.usersetpassword=PASSWORD('123456')whereuser='root';
75. +------+-----------+-------------------------------------------+
76. |root|localhost|*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9|
77. |root|centos|*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9|
78. |root|127.0.0.1|*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9|
79. |root|::1|*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9|
80. +------+-----------+-------------------------------------------+
81. MysqL>dropuser''@localhost;
82. ||centos||
83. MysqL>useMysqL
84. MysqL>updateusersethost='%'whereuser='root'andhost='localhost';
85. QueryOK,1rowaffected(0.00sec)
86. Rowsmatched:1Changed:1Warnings:0
87. |root|%|*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9|
88. 5rowsinset(0.00sec)
89. MysqL>FLUSHPRIVILEGES;
90. 参考：
91. http://blog.csdn.net/cnyyx/article/details/45151693
92. //www.cnblogs.com/xiaoit/p/3988640.html