[root@10-23-52-37 bin]# yum install mysql-serverLoaded plugins: fastestmirrorSetting up Install ProcessLoading mirror speeds from cached hostfilePackage mysql-server is obsoleted by mysql-community-server, trying to install mysql-community-server-5.6.38-2.el7.x86_64 insteadResolving Dependencies--> Running transaction check---> Package mysql-community-server.x86_64 0:5.6.38-2.el7 will be installed--> Processing Dependency: mysql-community-common(x86-64) = 5.6.38-2.el7 for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: systemd for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: systemd for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: perl(DBI) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libnuma.so.1(libnuma_1.2)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libnuma.so.1(libnuma_1.1)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libc.so.6(GLIBC_2.17)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libnuma.so.1()(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Running transaction check---> Package mysql-community-client.x86_64 0:5.6.38-2.el7 will be installed--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.38-2.el7.x86_64--> Processing Dependency: libc.so.6(GLIBC_2.17)(64bit) for package: mysql-community-client-5.6.38-2.el7.x86_64---> Package mysql-community-common.x86_64 0:5.6.38-2.el7 will be installed---> Package mysql-community-server.x86_64 0:5.6.38-2.el7 will be installed--> Processing Dependency: systemd for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: systemd for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libc.so.6(GLIBC_2.17)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64---> Package numactl.x86_64 0:2.0.9-2.el6 will be installed---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed--> Running transaction check---> Package mysql-community-client.x86_64 0:5.6.38-2.el7 will be installed--> Processing Dependency: libc.so.6(GLIBC_2.17)(64bit) for package: mysql-community-client-5.6.38-2.el7.x86_64---> Package mysql-community-libs.x86_64 0:5.6.38-2.el7 will be installed--> Processing Dependency: libc.so.6(GLIBC_2.17)(64bit) for package: mysql-community-libs-5.6.38-2.el7.x86_64---> Package mysql-community-server.x86_64 0:5.6.38-2.el7 will be installed--> Processing Dependency: systemd for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: systemd for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Processing Dependency: libc.so.6(GLIBC_2.17)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64--> Finished Dependency ResolutionError: Package: mysql-community-client-5.6.38-2.el7.x86_64 (mysql56-community) Requires: libc.so.6(GLIBC_2.17)(64bit)Error: Package: mysql-community-libs-5.6.38-2.el7.x86_64 (mysql56-community) Requires: libc.so.6(GLIBC_2.17)(64bit)Error: Package: mysql-community-server-5.6.38-2.el7.x86_64 (mysql56-community) Requires: libc.so.6(GLIBC_2.17)(64bit)Error: Package: mysql-community-server-5.6.38-2.el7.x86_64 (mysql56-community) Requires: systemdError: Package: mysql-community-server-5.6.38-2.el7.x86_64 (mysql56-community) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest[root@10-23-52-37 bin]#
shell>tar -zxvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz -C /usr/local/shell>mv mysql-5.7.20-linux-glibc2.12-x86_64/ mysqlshell> groupadd mysqlshell> useradd -r -g mysql -s /bin/false mysqlshell> cd /usr/localshell> cd mysqlshell> mkdir mysql-filesshell> chmod 750 mysql-filesshell> chown -R mysql .shell> chgrp -R mysql .shell> bin/mysqld --initialize --user=mysql //这个命令执行完之后会出现默认密码如下图：
[root@10-23-52-37 mysql]# bin/mysqld --initialize -user=mysqlbin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory
solution(http://blog.csdn.net/sbwfgihc/article/details/16880813):
[root@10-23-52-37 bin]# ./mysqld --initialize --user=mysql./mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory[root@10-23-52-37 bin]# [root@10-23-52-37 bin]# [root@10-23-52-37 bin]# [root@10-23-52-37 bin]# yum remove libnuma.so.1Loaded plugins: fastestmirrorSetting up Remove ProcessNo Match for argument: libnuma.so.1Loading mirror speeds from cached hostfileNo Packages marked for removal[root@10-23-52-37 bin]# [root@10-23-52-37 bin]# [root@10-23-52-37 bin]# yum install numactl.x86_64Loaded plugins: fastestmirrorSetting up Install ProcessLoading mirror speeds from cached hostfileResolving Dependencies--> Running transaction check---> Package numactl.x86_64 0:2.0.9-2.el6 will be installed--> Finished Dependency ResolutionDependencies Resolved============================================================================================================================================================================================== Package Arch Version Repository Size==============================================================================================================================================================================================Installing: numactl x86_64 2.0.9-2.el6 base 74 kTransaction Summary==============================================================================================================================================================================================Install 1 Package(s)Total download size: 74 kInstalled size: 171 kIs this ok [y/N]: yDownloading Packages:numactl-2.0.9-2.el6.x86_64.rpm | 74 kB 00:00 Running rpm_check_debugRunning Transaction TestTransaction Test SucceededRunning Transaction Installing : numactl-2.0.9-2.el6.x86_64 1/1 Verifying : numactl-2.0.9-2.el6.x86_64 1/1 Installed: numactl.x86_64 0:2.0.9-2.el6 Complete![root@10-23-52-37 bin]# [root@10-23-52-37 bin]# [root@10-23-52-37 bin]# [root@10-23-52-37 bin]# ./mysqld --initialize --user=mysql2018-01-06T05:56:09.780808Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-01-06T05:56:10.442494Z 0 [Warning] InnoDB: New log files created, LSN=457902018-01-06T05:56:10.641425Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2018-01-06T05:56:10.709560Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4bba7d6e-f2a6-11e7-96fb-525400cb5213.2018-01-06T05:56:10.711979Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2018-01-06T05:56:10.713290Z 1 [Note] A temporary password is generated for root@localhost: L9&X;A(t+6ju[root@10-23-52-37 bin]#
[root@10-23-52-37 bin]# ./mysql_ssl_rsa_setupGenerating a 2048 bit RSA private key..................................................................................................................................................................+++........................+++writing new private key to 'ca-key.pem'-----Generating a 2048 bit RSA private key........................................................................................................................................................+++..........................................................................................+++writing new private key to 'server-key.pem'-----Generating a 2048 bit RSA private key......+++.......................................................................+++writing new private key to 'client-key.pem'-----[root@10-23-52-37 bin]#
[root@10-23-52-37 mysql]# ls -ltrtotal 60-rw-r--r-- 1 mysql mysql 2478 Sep 13 23:48 README-rw-r--r-- 1 mysql mysql 17987 Sep 13 23:48 COPYINGdrwxr-xr-x 3 mysql mysql 4096 Jan 6 10:42 includedrwxr-xr-x 4 mysql mysql 4096 Jan 6 10:43 mandrwxr-xr-x 2 mysql mysql 4096 Jan 6 10:43 bindrwxr-xr-x 5 mysql mysql 4096 Jan 6 10:43 libdrwxr-xr-x 2 mysql mysql 4096 Jan 6 10:43 support-filesdrwxr-xr-x 28 mysql mysql 4096 Jan 6 10:43 sharedrwxr-xr-x 2 mysql mysql 4096 Jan 6 10:43 docsdrwxr-x--- 2 mysql mysql 4096 Jan 6 13:50 mysql-filesdrwxr-xr-x 5 mysql mysql 4096 Jan 6 13:59 data[root@10-23-52-37 mysql]# [root@10-23-52-37 mysql]# chown -R root .[root@10-23-52-37 mysql]# ls -ltrtotal 60-rw-r--r-- 1 root mysql 2478 Sep 13 23:48 README-rw-r--r-- 1 root mysql 17987 Sep 13 23:48 COPYINGdrwxr-xr-x 3 root mysql 4096 Jan 6 10:42 includedrwxr-xr-x 4 root mysql 4096 Jan 6 10:43 mandrwxr-xr-x 2 root mysql 4096 Jan 6 10:43 bindrwxr-xr-x 5 root mysql 4096 Jan 6 10:43 libdrwxr-xr-x 2 root mysql 4096 Jan 6 10:43 support-filesdrwxr-xr-x 28 root mysql 4096 Jan 6 10:43 sharedrwxr-xr-x 2 root mysql 4096 Jan 6 10:43 docsdrwxr-x--- 2 root mysql 4096 Jan 6 13:50 mysql-filesdrwxr-xr-x 5 root mysql 4096 Jan 6 13:59 data[root@10-23-52-37 mysql]#
[root@10-23-52-37 mysql]# bin/mysqld_safe --user=mysql &[1] 8148[root@10-23-52-37 mysql]# Logging to '/usr/local/mysql/data/10-23-52-37.err'.2018-01-06T06:01:23.479595Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data2018-01-06T06:01:24.218467Z mysqld_safe mysqld from pid file /usr/local/mysql/data/10-23-52-37.pid ended^C[1]+ Done bin/mysqld_safe --user=mysql[root@10-23-52-37 mysql]#
shell> bin/mysql_ssl_rsa_setup # MySQL 5.7.6 and upshell> chown -R root .shell>bin/mysqld_safe --user=mysql & //（坑）执行这步的是为了生成pid，当你看到以.pid ended结尾，就可以ctrl+c,而且这一步mysql已经启动了，你需要执行ps -ef|grep mysqld，然后将mysql进程kill掉，然后在进行一下命令shell>cd ..shell> sudo support-files/mysql.server start //开启mysql，他会报错，需要修改/etc/my.cnf下的socket=/tmp/mysql.sock，修改完成后再次启动mysqlshell> cp support-files/mysql.server /etc/init.d/mysql.server//设置开机启动
[root@10-23-52-37 mysql]# support-files/mysql.server startStarting MySQL.Logging to '/usr/local/mysql/data/10-23-52-37.err'. ERROR! The server quit without updating PID file (/usr/local/mysql/data/10-23-52-37.pid).[root@10-23-52-37 mysql]#
[root@10-23-52-37 mysql]# [root@10-23-52-37 mysql]# chown -R mysql.mysql /usr/local/mysql/data/[root@10-23-52-37 mysql]# [root@10-23-52-37 mysql]# [root@10-23-52-37 mysql]# pwd/usr/local/mysql[root@10-23-52-37 mysql]# [root@10-23-52-37 mysql]# support-files/mysql.server startStarting MySQL.Logging to '/usr/local/mysql/data/10-23-52-37.err'. SUCCESS! [root@10-23-52-37 mysql]#
[root@10-23-52-37 bin]# ./mysqlERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)[root@10-23-52-37 bin]# ./mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.7.20Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> statusERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> mysql> mysql> mysql> set PASSWORD=PASSWORD('123qwe!@#QWE') -> ;Query OK, 0 rows affected, 1 warning (0.01 sec)mysql>
http://blog.csdn.net/Suubyy/article/details/78274070?locationNum=8&fps=1