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, we will pass rpm -e Command or rpm -e --nodeps Command to uninstall

[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, we can userpm -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.rpmLoaded 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/1Installed: 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/8Installed: 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: 

　　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 -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,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.

The above section describes mysql-community-server in centos 6.5. 5.7.18-1. el6 installation, I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!