CENTOS 7 MySQL 5.7<\/p>\n
<\/p>\n
wget http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-7.noarch.rpm<\/p>\n
yum install -y mysql-community-server<\/p>\n
<\/p>\n
systemctl start mysqld.service<\/p>\n
[root@clusterserver1 software]# systemctl start mysqld.service
\n[root@clusterserver1 software]# mysql -uroot -p
\nEnter password:
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 3
\nServer version: 5.7.19 MySQL Community Server (GPL)<\/p>\n
Copyright (c) 2000, 2017, Oracle and\/or its affiliates. All rights reserved.<\/p>\n
Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n
mysql>update mysql.user set authentication_string=password(“test123″) where user=”root” and Host=”localhost”;
\nmysql>flush privileges;
\nmysql>quit;<\/p>\n
systemctl restart mysqld;<\/p>\n
<\/p>\n
vi \/etc\/my.cnf<\/p>\n
<\/p>\n
[mysqld]<\/p>\n
skip-grant-tables<\/p>\n
skip-networking<\/p>\n
<\/p>\n
[root@clusterserver1 software]# mysql -u root -p
\nEnter password:
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 4
\nServer version: 5.7.19 MySQL Community Server (GPL)<\/p>\n
Copyright (c) 2000, 2017, Oracle and\/or its affiliates. All rights reserved.<\/p>\n
Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n
mysql> use mysql;
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n
Database changed
\nmysql> GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘test123’ WITH GRANT OPTION;
\nmysql> select host, user from user;
\n+—————————+——+
\n| host | user |
\n+—————————+——+
\n| 127.0.0.1 | root |
\n| ::1 | root |
\n| clusterserver1.rmohan.com | |
\n| clusterserver1.rmohan.com | root |
\n| localhost | |
\n| localhost | root |
\n+—————————+——+
\n6 rows in set (0.00 sec)<\/p>\n
<\/p>\n
vi \/etc\/sysconfig\/iptables<\/p>\n
-A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT<\/p>\n
<\/p>\n
vi \/etc\/my.cnf<\/p>\n
<\/p>\n
[mysqld]<\/p>\n
character-set-server=utf8<\/p>\n
collation-server=utf8_general_ci<\/p>\n
<\/p>\n
mysql> status;
\n————–
\nmysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper<\/p>\n
Connection id: 5
\nCurrent database:
\nCurrent user: root@localhost
\nSSL: Not in use
\nCurrent pager: stdout
\nUsing outfile: ”
\nUsing delimiter: ;
\nServer version: 5.7.19 MySQL Community Server (GPL)
\nProtocol version: 10
\nConnection: Localhost via UNIX socket
\nServer characterset: latin1
\nDb characterset: latin1
\nClient characterset: utf8
\nConn. characterset: utf8
\nUNIX socket: \/var\/lib\/mysql\/mysql.sock
\nUptime: 3 min 28 sec<\/p>\n
Threads: 1 Questions: 44 Slow queries: 0 Opens: 56 Flush tables: 1 Open tables: 49 Queries per second avg: 0.211
\n————–<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
CENTOS 7 MySQL 5.7<\/p>\n
<\/p>\n
wget http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-7.noarch.rpm<\/p>\n
yum install -y mysql-community-server<\/p>\n
<\/p>\n
systemctl start mysqld.service<\/p>\n
[root@clusterserver1 software]# systemctl start mysqld.service [root@clusterserver1 software]# 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.19 MySQL Community Server (GPL)<\/p>\n
Copyright (c) 2000, 2017, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6942"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6942"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6942\/revisions"}],"predecessor-version":[{"id":6943,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6942\/revisions\/6943"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}