Unix/linux Environment C Programming Novice Tutorial (in) MySQL 5.7.4 for Red Hat Enterprise 7 (RHEL7) installation

Source: Internet
Author: User
Tags mysql code



Far from history, MySQL's main purpose is to be able to execute on a single processor core business Server. Now a change in MySQL users may not notice that Oracle has started to structure the MySQL code again, making it a lot of modularity. such as software parsers, optimizations and replication functions are rewritten in a modular format.
The version number of the query performance significantly improved, 1 time times higher than the MySQL 5.6, the new version of MySQL on the test platform can be up to 512000 per second to read the QPS, and MySQL 5.6 up to only 250000 QPS. This performance improvement is achieved through its Memcached plug-in. At the same time, the version number has been improved in other aspects of the database, such as reducing the time it takes to establish a database connection, thanks to Facebook's contribution.






1. First we understand the features of MySQL





Features of MySQL


  • Use C and C + + written, and use a variety of compilers to test, to ensure the portability of the source code.
  • Supports various operating systems such as AIX, BSDi, FreeBSD, HP-UX, Linux, Mac OS, Novell Netware, NetBSD, OpenBSD, Os/2 Wrap, Solaris, SunOS, Windows, and more.
  • Provides APIs for a variety of programming languages. These programming languages include C, C + +, C #, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl.
  • Support multi-threading, make full use of CPU resources, support multi-user.
  • Optimized SQL query algorithm to improve query speed effectively.
  • It can be applied either as a standalone application in a client server network environment or as a library and embedded in other software.
  • Multi-language support, common encoding such as Chinese GB 2312, BIG5, Japanese shift_jis, etc. can be used as data table name and data column name.
  • Provides a variety of database connectivity pathways such as TCP/IP, ODBC, and JDBC.
  • Provides management tools for managing, inspecting, and optimizing database operations.
  • You can handle large databases that have thousands records.


English MySQL document:Http://tool.oschina.net/apidocs/apidoc?api=mysql-5.1-zh



English MySQL document:http://tool.oschina.net/apidocs/apidoc?api=mysql-5.5-en



2. Below we start downloading MySQL



Open http://dev.mysql.com/downloads/mysql/Select Developer Version number






Select the version number of Rhel






Download the 32 or 64-bit MySQL version number you need for the corresponding x86 architecture click to download






Select Download Now or download tool to open



Http://cdn.mysql.com/Downloads/MySQL-5.7/MySQL-5.7.4-m14-0.2.m14.el7.x86_64.rpm-bundle.tar









3. Transfer MySQL into the virtual machine



Start RHEL7 We need to install the root user in order to be more direct we log in directly with root












4. Release the installation package: TAR-XVF Mysql-5.7.4-m14-0.2.m14.el7.x86_64.rpm-bundle.tar






5. Start the installation






Show conflict I should uninstall the original software mariadb-devel and MARIADB









RPM-E--nodeps mariadb-libs-5.5.33a-3.el7.x86_64



RPM-IVH mysql-community-common-5.7.4-0.2.m14.el7.x86_64.rpm



RPM-IVH mysql-community-libs-5.7.4-0.2.m14.el7.x86_64.rpm



RPM-IVH mysql-community-embedded-5.7.4-0.2.m14.el7.x86_64.rpm












Rpm-e Mariadb-devel–nodeps






Rpm-e Mariadb–nodeps



RPM-IVH mysql-community-devel-5.7.4-0.2.m14.el7.x86_64.rpm



RPM-IVH mysql-community-embedded-devel-5.7.4-0.2.m14.el7.x86_64.rpm



RPM-IVH mysql-community-client-5.7.4-0.2.m14.el7.x86_64.rpm









Mount your image on the CD drive of the virtual machine















Install several dependent packages into the ISO file



RPM-IVH perl-net-daemon-0.48-4.el7.noarch.rpm



RPM-IVH perl-plrpc-0.2020-12.el7.noarch.rpm



RPM-IVH perl-dbi-1.627-1.el7.x86_64.rpm









Work path back to the desktop and then continue to install our server



RPM-IVH mysql-community-server-5.7.4-0.2.m14.el7.x86_64.rpm






6. Change user Password



When the server is installed, we'll find the key file.



Find/-name. Mysql_secret












Login to MySQL with the root user was denied access, so we switch users






Login again






Replace password into a simple demo example of 123456






Well, the installation of MySQL for RHEL 7 ends. CentOS 7 was also released a few days ago, and this installation package is also for installation on CentOS7, after all, these two OS are binary compatible.



Unix/linux Environment C Programming Novice Tutorial (in) MySQL 5.7.4 for Red Hat Enterprise 7 (RHEL7) installation


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.