- Welcome to Alibaba Cloud Elastic Compute Service !
- [root@izbp19stm1x1k2io1e7r3tz ~]# rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
- Retrieving http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
- Preparing... ################################# [100%]
- Updating / installing...
- 1:mysql-community-release-el7-5 ################################# [100%]
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]# yum repolist enabled | grep "mysql.*-community.*"
- mysql-connectors-community/x86_64 MySQL Connectors Community 45
- mysql-tools-community/x86_64 MySQL Tools Community 59
- mysql56-community/x86_64 MySQL 5.6 Community Server 378
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]# yum -y install mysql-community-server
- Loaded plugins: fastestmirror
- Loading mirror speeds from cached hostfile
- Resolving Dependencies
- --> Running transaction check
- ---> Package mysql-community-server.x86_64 0:5.6.39-2.el7 will be installed
- --> Processing Dependency: mysql-community-common(x86-64) = 5.6.39-2.el7 for package: mysql-community-server-5.6.39-2.el7.x86_64
- --> Processing Dependency: mysql-community-client(x86-64)>= 5.6.10 for package: mysql-community-server-5.6.39-2.el7.x86_64
- --> Processing Dependency: perl(Data::Dumper) for package: mysql-community-server-5.6.39-2.el7.x86_64
- --> Processing Dependency: perl(DBI) for package: mysql-community-server-5.6.39-2.el7.x86_64
- --> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-5.6.39-2.el7.x86_64
- --> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-5.6.39-2.el7.x86_64
- --> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-5.6.39-2.el7.x86_64
- --> Running transaction check
- ---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
- ---> Package mysql-community-client.x86_64 0:5.6.39-2.el7 will be installed
- --> Processing Dependency: mysql-community-libs(x86-64)>= 5.6.10 for package: mysql-community-client-5.6.39-2.el7.x86_64
- ---> Package mysql-community-common.x86_64 0:5.6.39-2.el7 will be installed
- ---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
- --> Processing Dependency: perl(RPC::PlServer)>= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
- --> Processing Dependency: perl(RPC::PlClient)>= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
- ---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
- --> Running transaction check
- ---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be obsoleted
- ---> Package mysql-community-libs.x86_64 0:5.6.39-2.el7 will be obsoleting
- ---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
- --> Processing Dependency: perl(Net::Daemon)>= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
- --> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
- --> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
- --> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
- --> Running transaction check
- ---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
- --> Processing Dependency: perl(Compress::Raw::Zlib)>= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
- --> Processing Dependency: perl(Compress::Raw::Bzip2)>= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
- ---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
- --> Running transaction check
- ---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
- ---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
- --> Finished Dependency Resolution
- Dependencies Resolved
- ===========================================================================================================================================================================================================================================
- Package Arch Version Repository Size
- ===========================================================================================================================================================================================================================================
- Installing:
- mysql-community-libs x86_64 5.6.39-2.el7 mysql56-community 2.0 M
- replacing mariadb-libs.x86_64 1:5.5.56-2.el7
- mysql-community-server x86_64 5.6.39-2.el7 mysql56-community 59 M
- Installing for dependencies:
- libaio x86_64 0.3.109-13.el7 base 24 k
- mysql-community-client x86_64 5.6.39-2.el7 mysql56-community 19 M
- mysql-community-common x86_64 5.6.39-2.el7 mysql56-community 257 k
- perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k
- perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k
- perl-DBI x86_64 1.627-4.el7 base 802 k
- perl-Data-Dumper x86_64 2.145-3.el7 base 47 k
- perl-IO-Compress noarch 2.061-2.el7 base 260 k
- perl-Net-Daemon noarch 0.48-5.el7 base 51 k
- perl-PlRPC noarch 0.2020-14.el7 base 36 k
- Transaction Summary
- ===========================================================================================================================================================================================================================================
- Install 2 Packages (+10 Dependent packages)
- Total download size: 82 M
- Downloading packages:
- (1/12): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00
- warning: /var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.39-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
- Public key for mysql-community-common-5.6.39-2.el7.x86_64.rpm is not installed
- (2/12): mysql-community-common-5.6.39-2.el7.x86_64.rpm | 257 kB 00:00:00
- (3/12): mysql-community-libs-5.6.39-2.el7.x86_64.rpm | 2.0 MB 00:00:00
- (4/12): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00
- (5/12): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00
- (6/12): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00
- (7/12): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00
- (8/12): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00
- (9/12): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00
- (10/12): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00
- (11/12): mysql-community-client-5.6.39-2.el7.x86_64.rpm | 19 MB 00:00:03
- (12/12): mysql-community-server-5.6.39-2.el7.x86_64.rpm | 59 MB 00:00:07
- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- Total 9.2 MB/s | 82 MB 00:00:08
- Retrieving key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
- Importing GPG key 0x5072E1F5:
- Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
- Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
- Package : mysql-community-release-el7-5.noarch (installed)
- From : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
- Running transaction check
- Running transaction test
- Transaction test succeeded
- Running transaction
- Warning: RPMDB altered outside of yum.
- Installing : perl-Data-Dumper-2.145-3.el7.x86_64 1/13
- Installing : mysql-community-common-5.6.39-2.el7.x86_64 2/13
- Installing : mysql-community-libs-5.6.39-2.el7.x86_64 3/13
- Installing : mysql-community-client-5.6.39-2.el7.x86_64 4/13
- Installing : libaio-0.3.109-13.el7.x86_64 5/13
- Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 6/13
- Installing : perl-Net-Daemon-0.48-5.el7.noarch 7/13
- Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 8/13
- Installing : perl-IO-Compress-2.061-2.el7.noarch 9/13
- Installing : perl-PlRPC-0.2020-14.el7.noarch 10/13
- Installing : perl-DBI-1.627-4.el7.x86_64 11/13
- Installing : mysql-community-server-5.6.39-2.el7.x86_64 12/13
- Erasing : 1:mariadb-libs-5.5.56-2.el7.x86_64 13/13
- Verifying : mysql-community-server-5.6.39-2.el7.x86_64 1/13
- Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 2/13
- Verifying : perl-Net-Daemon-0.48-5.el7.noarch 3/13
- Verifying : mysql-community-common-5.6.39-2.el7.x86_64 4/13
- Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 5/13
- Verifying : mysql-community-libs-5.6.39-2.el7.x86_64 6/13
- Verifying : perl-PlRPC-0.2020-14.el7.noarch 7/13
- Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 8/13
- Verifying : perl-DBI-1.627-4.el7.x86_64 9/13
- Verifying : libaio-0.3.109-13.el7.x86_64 10/13
- Verifying : mysql-community-client-5.6.39-2.el7.x86_64 11/13
- Verifying : perl-IO-Compress-2.061-2.el7.noarch 12/13
- Verifying : 1:mariadb-libs-5.5.56-2.el7.x86_64 13/13
- Installed:
- mysql-community-libs.x86_64 0:5.6.39-2.el7 mysql-community-server.x86_64 0:5.6.39-2.el7
- Dependency Installed:
- libaio.x86_64 0:0.3.109-13.el7 mysql-community-client.x86_64 0:5.6.39-2.el7 mysql-community-common.x86_64 0:5.6.39-2.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7
- perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7
- Replaced:
- mariadb-libs.x86_64 1:5.5.56-2.el7
- Complete!
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]# systemctl enable mysqld
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]# systemctl start mysqld
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]# mysql_secure_installation
- NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
- SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
- In order to log into MySQL to secure it, well need the current
- password for the root user. If youve just installed MySQL, and
- you havent set the root password yet, the password will be blank,
- so you should just press enter here.
- Enter current password for root (enter for none):
- OK, successfully used password, moving on...
- Setting the root password ensures that nobody can log into the MySQL
- root user without the proper authorisation.
- Set root password? [Y/n] Y
- New password:
- Re-enter new password:
- Password updated successfully!
- Reloading privilege tables..
- ... Success!
- By default, a MySQL installation has an anonymous user, allowing anyone
- to log into MySQL without having to have a user account created for
- them. This is intended only for testing, and to make the installation
- go a bit smoother. You should remove them before moving into a
- production environment.
- Remove anonymous users? [Y/n] Y
- ... Success!
- Normally, root should only be allowed to connect from localhost. This
- ensures that someone cannot guess at the root password from the network.
- Disallow root login remotely? [Y/n] Y
- ... Success!
- By default, MySQL comes with a database named test that anyone can
- access. This is also intended only for testing, and should be removed
- before moving into a production environment.
- Remove test database and access to it? [Y/n] n
- ... skipping.
- Reloading the privilege tables will ensure that all changes made so far
- will take effect immediately.
- Reload privilege tables now? [Y/n] Y
- ... Success!
- All done! If youve completed all of the above steps, your MySQL
- installation should now be secure.
- Thanks for using MySQL!
- Cleaning up...
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]#
- [root@izbp19stm1x1k2io1e7r3tz ~]# mysql -uroot -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 11
- Server version: 5.6.39 MySQL Community Server (GPL)
- Copyright (c) 2000, 2018, 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.
- mysql> show tables;
- ERROR 1046 (3D000): No database selected
- mysql> show dababases;
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near dababases at line 1
- mysql>
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | performance_schema |
- +--------------------+
- 3 rows in set (0.00 sec)
- mysql> use mysql
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- mysql> show tables;
- +---------------------------+
- | Tables_in_mysql |
- +---------------------------+
- | columns_priv |
- | db |
- | event |
- | func |
- | general_log |
- | help_category |
- | help_keyword |
- | help_relation |
- | help_topic |
- | innodb_index_stats |
- | innodb_table_stats |
- | ndb_binlog_index |
- | plugin |
- | proc |
- | procs_priv |
- | proxies_priv |
- | servers |
- | slave_master_info |
- | slave_relay_log_info |
- | slave_worker_info |
- | slow_log |
- | tables_priv |
- | time_zone |
- | time_zone_leap_second |
- | time_zone_name |
- | time_zone_transition |
- | time_zone_transition_type |
- | user |
- +---------------------------+
- 28 rows in set (0.00 sec)
- mysql>
- mysql>
- mysql>
- https://yq.aliyun.com/ziliao/132362
- https://www.cnblogs.com/thinkingandworkinghard/p/6711255.html
来源: http://www.bubuko.com/infodetail-2545546.html