Linux安装MySQL8.0.12之二进制安装

2018年07月29日 01:21:31 vkingnew 阅读数：6050

版权声明：本文为博主原创文章,转载请注明出处 https://blog.csdn.net/vkingnew/article/details/81267223

1. 运行环境：centos+mysql8.0.12

2. 1.下载官方打包好的二进制安装包：

3. #wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

4. 可以看到这个版本采用了tar.xz的打包压缩方式，文件只有350M左右，下载还是满方便的。

5. # du -sh mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

6. 339M mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

7. 2.解压文件：

8. #tar -xJvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

9. # mv /usr/local/mysql-8.0.12-linux-glibc2.12-x86_64/ /usr/local/mysql

10. 3.配置参数文件：

11. # cat /etc/my.cnf

12. [mysqld]

13. server-id = 1

14. port = 3306

15. mysqlx_port = 33060

16. mysqlx_socket = /tmp/mysqlx.sock

17. datadir = /data/mysql

18. socket = /tmp/mysql.sock

19. pid-file = /tmp/mysqld.pid

20. log-error = error.log

21. slow-query-log = 1

22. slow-query-log-file = slow.log

23. long_query_time = 0.2

24. log-bin = bin.log

25. relay-log = relay.log

26. binlog_format =ROW

27. relay_log_recovery = 1

28. character-set-client-handshake = FALSE

29. character-set-server = utf8mb4

30. collation-server = utf8mb4_unicode_ci

31. init_connect ='SET NAMES utf8mb4'

32. innodb_buffer_pool_size = 1G

33. join_buffer_size = 128M

34. sort_buffer_size = 2M

35. read_rnd_buffer_size = 2M

36. log_timestamps = SYSTEM

37. lower_case_table_names = 1

38. default-authentication-plugin =mysql_native_password

39. 4.创建目录授权等：

40. # groupadd mysql

41. # useradd mysql

42. # mkdir -p /data/mysql

43. # chown -R mysql:mysql /data/mysql/

44. # chmod -R 775 /data/mysql/

45. 5.初始化数据库：

46. #/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --initialize-insecure

47. 官方推荐使用--initialize，会在错误日志中生成难以输入的临时密码，我这里使用的免密码的方式。

48. # cat /data/mysql/error.log | grep -i password

49. 2018-07-29T02:06:41.253856+08:00 5 [Note] [MY-010454] [Server] A temporary password is generated for root[@localhost](https://my.oschina.net/u/570656): wquR3-Kxlg1d

50. 6.设置启动文件和环境变量：

51. #cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

52. --启动数据库：

53. # /etc/init.d/mysql start

54. Starting MySQL.Logging to '/data/mysql/error.log'.

55. SUCCESS!

56. # vim /etc/profile.d/mysql.sh

57. # cat /etc/profile.d/mysql.sh

58. export PATH=$PATH:/usr/local/mysql/bin

59. # source /etc/profile.d/mysql.sh

60. # mysqld --version

61. mysqld Ver 8.0.12 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)

62. [root@node4 mysql]# /usr/local/mysql/bin/mysql -p -S /tmp/mysql.sock

63. Enter password:

64. Welcome to the MySQL monitor. Commands end with ; or \g.

65. Your MySQL connection id is 7

66. Server version: 8.0.12 MySQL Community Server - GPL

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

68. Oracle is a registered trademark of Oracle Corporation and/or its

69. affiliates. Other names may be trademarks of their respective

70. owners.

71. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

72. mysql> select version();

73. +-----------+

74. | version() |

75. +-----------+

76. | 8.0.12 |

77. +-----------+

78. 1 row in set (0.00 sec)

79. 7.设置可以远程登录的账号：

80. mysql> show variables like '%valid%pass%';

81. Empty set (0.00 sec)

82. mysql> create user root@'%' identified by 'oracle';

83. ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

84. mysql> show variables like '%valid%pass%';

85. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

86. mysql> alter user root@'localhost' identified by 'oracle';

87. Query OK, 0 rows affected (0.07 sec)

88. mysql> show variables like '%valid%pass%';

89. Empty set (0.01 sec)

90. --创建可以远程登录的用户：

91. mysql> create user root@'%' identified by 'oracle';

92. Query OK, 0 rows affected (0.06 sec)

93. mysql> grant all privileges on *.* to root@'%' with grant option;

94. Query OK, 0 rows affected (0.07 sec)

95. mysql> flush privileges;

96. Query OK, 0 rows affected (0.00 sec)

97. 总结：

98. 官方虽然提供RPM安装方式但是不少默认参数还是不太方便平常的使用，对生产而言则需要修改更多的地方，但是很适合初级用户快速安装使用；

99. 而对二进制安装包 只需要下载按照自定义的设置安装即可 方便快捷 可自主配置，适合生产布署。