Mysql-community-server. 5.7.18-1. el6 installation in centos 6.5, centosmysqlserver

Mysql-community-server. 5.7.18-1. el6 installation in centos 6.5, centosmysqlserver

Run the following command to check whether MySQL Server is installed.

[Root @ localhost etc] # rpm-qa | grep mysql // This command will check whether the mysql database has been installed on the Operating System

If yes, run the rpm-e command or the rpm-e -- nodeps command to uninstall it.

[Root @ localhost ~] # Rpm-e mysql // normal deletion mode [root @ localhost ~] # Rpm-e -- nodeps mysql // strong deletion mode. If the above command is used to delete other dependent files, you can use this command to forcibly delete them.

After deletion, run the rpm-qa | grep mysql command to check whether mysql has been uninstalled successfully !!

Download the installation package from yum repository

[root@localhost ~]# wget http://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpm

 

--2017-04-24 18:53:49--  http://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpmResolving dev.mysql.com... 137.254.60.11Connecting to dev.mysql.com|137.254.60.11|:80... connected.HTTP request sent, awaiting response... 301 Moved PermanentlyLocation: https://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpm [following]--2017-04-24 18:53:49--  https://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpmConnecting to dev.mysql.com|137.254.60.11|:443... connected.ERROR: certificate common name “www.mysql.com” doesn’t match requested host name “dev.mysql.com”.To connect to dev.mysql.com insecurely, use ‘--no-check-certificate’

　　

Install the downloaded rpm package locally

[root@localhost ~]# yum localinstall mysql57-community-release-el6-10.noarch.rpm

　　

Loaded plugins: fastestmirror, refresh-packagekit, securitySetting up Local Package ProcessExamining mysql57-community-release-el6-10.noarch.rpm: mysql57-community-release-el6-10.noarchMarking mysql57-community-release-el6-10.noarch.rpm to be installedLoading mirror speeds from cached hostfile * base: mirrors.cn99.com * extras: mirrors.cn99.com * updates: mirrors.cn99.comResolving Dependencies--> Running transaction check---> Package mysql57-community-release.noarch 0:el6-10 will be installed--> Finished Dependency ResolutionDependencies Resolved=============================================================================================================================================================================================== Package                                            Arch                            Version                            Repository                                                         Size===============================================================================================================================================================================================Installing: mysql57-community-release                          noarch                          el6-10                             /mysql57-community-release-el6-10.noarch                           30 kTransaction Summary===============================================================================================================================================================================================Install       1 Package(s)Total size: 30 kInstalled size: 30 kIs this ok [y/N]: yDownloading Packages:Running rpm_check_debugRunning Transaction TestTransaction Test SucceededRunning Transaction  Installing : mysql57-community-release-el6-10.noarch                                                                                                                                     1/1   Verifying  : mysql57-community-release-el6-10.noarch                                                                                                                                     1/1 Installed:  mysql57-community-release.noarch 0:el6-10                                                                                                                                                    Complete!

View available installation packages

[root@localhost ~]# yum repolist enabled|grep mysqlmysql-connectors-community           MySQL Connectors Community              33mysql-tools-community                MySQL Tools Community                   47mysql57-community                    MySQL 5.7 Community Server             183

　　

Install all gcc packages before installation to prevent [Errno-1] Package does not match intended download

[root@localhost yum.repos.d]# yum install gcc*

　　

Install mysql

[root@localhost yum.repos.d]# yum install -y  mysql-community-server

　　

Loaded plugins: fastestmirror, refresh-packagekit, securityLoading mirror speeds from cached hostfile * base: mirrors.cn99.com * extras: mirrors.cn99.com * updates: mirrors.cn99.comSetting up Install ProcessResolving Dependencies--> Running transaction check---> Package mysql-community-server.x86_64 0:5.7.18-1.el6 will be installed--> Processing Dependency: mysql-community-common(x86-64) = 5.7.18-1.el6 for package: mysql-community-server-5.7.18-1.el6.x86_64--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.18-1.el6.x86_64--> Running transaction check---> Package mysql-community-client.x86_64 0:5.7.18-1.el6 will be installed--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.18-1.el6.x86_64---> Package mysql-community-common.x86_64 0:5.7.18-1.el6 will be installed--> Running transaction check---> Package mysql-community-libs.x86_64 0:5.7.18-1.el6 will be obsoleting---> Package mysql-libs.x86_64 0:5.1.71-1.el6 will be obsoleted--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64--> Running transaction check---> Package mysql-community-libs-compat.x86_64 0:5.7.18-1.el6 will be obsoleting---> Package postfix.x86_64 2:2.6.6-2.2.el6_1 will be updated---> Package postfix.x86_64 2:2.6.6-8.el6 will be an update--> Finished Dependency ResolutionDependencies Resolved============================================================================================================================= Package                                 Arch               Version                      Repository                     Size=============================================================================================================================Installing: mysql-community-libs                    x86_64             5.7.18-1.el6                 mysql57-community             2.1 M     replacing  mysql-libs.x86_64 5.1.71-1.el6 mysql-community-libs-compat             x86_64             5.7.18-1.el6                 mysql57-community             1.6 M     replacing  mysql-libs.x86_64 5.1.71-1.el6 mysql-community-server                  x86_64             5.7.18-1.el6                 mysql57-community             152 MInstalling for dependencies: mysql-community-client                  x86_64             5.7.18-1.el6                 mysql57-community              23 M mysql-community-common                  x86_64             5.7.18-1.el6                 mysql57-community             328 kUpdating for dependencies: postfix                                 x86_64             2:2.6.6-8.el6                base                          2.0 MTransaction Summary=============================================================================================================================Install       5 Package(s)Upgrade       1 Package(s)Total size: 180 MTotal download size: 152 MDownloading Packages:mysql-community-server-5.7.18-1.el6.x86_64.rpm                                                        | 152 MB     01:41     warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYRetrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysqlImporting GPG key 0x5072E1F5: Userid : MySQL Release Engineering <mysql-build@oss.oracle.com> Package: mysql57-community-release-el6-10.noarch (@/mysql57-community-release-el6-10.noarch) From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysqlRunning rpm_check_debugRunning Transaction TestTransaction Test SucceededRunning Transaction  Installing : mysql-community-common-5.7.18-1.el6.x86_64                                                                1/8   Installing : mysql-community-libs-5.7.18-1.el6.x86_64                                                                  2/8   Installing : mysql-community-libs-compat-5.7.18-1.el6.x86_64                                                           3/8   Installing : mysql-community-client-5.7.18-1.el6.x86_64                                                                4/8   Installing : mysql-community-server-5.7.18-1.el6.x86_64                                                                5/8   Updating   : 2:postfix-2.6.6-8.el6.x86_64                                                                              6/8   Cleanup    : 2:postfix-2.6.6-2.2.el6_1.x86_64                                                                          7/8   Erasing    : mysql-libs-5.1.71-1.el6.x86_64                                                                            8/8   Verifying  : 2:postfix-2.6.6-8.el6.x86_64                                                                              1/8   Verifying  : mysql-community-libs-compat-5.7.18-1.el6.x86_64                                                           2/8   Verifying  : mysql-community-server-5.7.18-1.el6.x86_64                                                                3/8   Verifying  : mysql-community-libs-5.7.18-1.el6.x86_64                                                                  4/8   Verifying  : mysql-community-common-5.7.18-1.el6.x86_64                                                                5/8   Verifying  : mysql-community-client-5.7.18-1.el6.x86_64                                                                6/8   Verifying  : 2:postfix-2.6.6-2.2.el6_1.x86_64                                                                          7/8   Verifying  : mysql-libs-5.1.71-1.el6.x86_64                                                                            8/8 Installed:  mysql-community-libs.x86_64 0:5.7.18-1.el6                 mysql-community-libs-compat.x86_64 0:5.7.18-1.el6                mysql-community-server.x86_64 0:5.7.18-1.el6              Dependency Installed:  mysql-community-client.x86_64 0:5.7.18-1.el6                  mysql-community-common.x86_64 0:5.7.18-1.el6                 Dependency Updated:  postfix.x86_64 2:2.6.6-8.el6                                                                                               Replaced:  mysql-libs.x86_64 0:5.1.71-1.el6                                                                                           Complete!

　

Start mysql

[root@localhost yum.repos.d]# service mysqld start

　　

Initializing MySQL database:                               [  OK  ]Installing validate password plugin:                       [  OK  ]Starting mysqld:                                           [  OK  ]

Enter mysql Security Mode

[root@localhost yum.repos.d]# killall -TERM mysqld[root@localhost yum.repos.d]# mysqld_safe --skip-grant-tables & [1] 40422[root@localhost yum.repos.d]# 2017-04-25T07:45:39.222061Z mysqld_safe Logging to '/var/log/mysqld.log'.2017-04-25T07:45:39.246117Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysqlmysql -uroot -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.7.18 MySQL Community Server (GPL)Copyright (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> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select * from users;ERROR 1146 (42S02): Table 'mysql.users' doesn't existmysql> select * from user;mysql> update user set authentication_string=PASSWORD('mysql') where user='root';Query OK, 1 row affected, 1 warning (0.00 sec)Rows matched: 1  Changed: 1  Warnings: 1mysql> quitBye[2]+  Exit 1                  mysqld_safe --skip-grant-tables

　　

 

[root@localhost yum.repos.d]# service mysqld startStarting mysqld:                                           [  OK  ][root@localhost yum.repos.d]# mysql -uroot -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 5Server version: 5.7.18 MySQL Community Server (GPL)Copyright (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-h host address-u user name-p User Password
1. Example 1: connect to MYSQL on the local machine

 

Find the installation directory of mysql. Generally, you can directly enter the mysql-uroot-p command and press enter to prompt you to enter the password. If you have just installed MYSQL, the Super User root has no password, press enter to enter MYSQL.

The MYSQL prompt is: mysql>

 

2. Connect to MYSQL on the remote host

 

Assume that the IP address of the remote host is 10.0.0.1, the user name is root, and the password is 123. Enter the following command:

 

Mysql-h10.0.0.1-uroot-p123

 

(Note: you do not need to add spaces for u and root. The same applies to others)

 

Configure Firewall
Port 3306 of the firewall is disabled by default. To access the firewall remotely, you must enable this port.
Open/etc/sysconfig/iptables
In "-a input-m state -- state NEW-m tcp-p tcp-dport 22-j ACCEPT", add:
-A input-m state -- state NEW-m tcp-p tcp -- dport 3306-j ACCEPT
Save and close the file. Run the following command in the terminal to refresh the Firewall Configuration:
Service iptables restart OK. After all configurations are completed, you can access your MySQL instance ~

Note: The added statement to open port 3306 must be before icmp-host-prohibited.

　　

 

 

 

 

Mysql-uroot-p
Enter password:
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 3
Server version: 5.7.18 MySQL Community Server (GPL)

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

Oracle is a registered trademark of Oracle Corporation and/or its
Affiliates. Other names may be trademarks of their respective
Owners.

Type 'help; 'or' \ H' for help. type' \ C' to clear the current input statement.