Database: MySQL database server installation and configuration

Source: Internet
Author: User
Tags mysql query server installation and configuration centos mysql database

MySQL is a small relational database management system, the developer for the Swedish Mysqlab Company, was acquired by Sun on January 16, 2008. MySQL is widely used in small and medium Web sites on the Internet. Because of its small size, speed, the total cost of ownership is low, especially the characteristics of open source, many small and medium-sized Web sites in order to reduce the total cost of ownership of the site to choose MySQL as a Web site database.

it has the following characteristics:

1. Use C and C + + to write, and use a variety of compilers for testing, to ensure that the source code portability

2. Supports AIX, FreeBSD, HP-UX, Linux, Mac OS, Novell Netware, OpenBSD, Os/2 Wrap, Solaris, Windows, and many other operating systems

3. Provides APIs for a variety of programming languages. These programming languages include C, C + +, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl.

4. Support multiple threads, make full use of CPU resources

5. Optimized SQL query algorithm, effectively improve the query speed

6. Can be used as a separate application in the Client server network environment, but also as a library to embed in other software to provide multi-language support, common coding such as the Chinese GB 2312, BIG5, Japanese shift_jis and so on are available as data table names and data column names

7. Provide TCP/IP, ODBC and JDBC and other database connection channels

8. Provide management tools for managing, inspecting, and optimizing database operations

9. Can handle large databases with thousands records

First, the installation of MySQL

First, look at whether your computer has MySQL software installed rpm-qa grep MySQL

If it is not installed, place the disc: Rpm-ivh mysql-server-*.rpm (if not installed directly, prompts libmysqlclients.so.15 is needed error)

So, go to the Cenos directory under the CD:

[Root@localhost centos]# RPM-IVH mysql-server-5.0.45-7.el5.i386.rpm

error:failed dependencies:

Libmysqlclient.so.15 is needed by mysql-server-5.0.45-7.el5.i386

libmysqlclient.so.15 (LIBMYSQLCLIENT_15) is needed by mysql-server-5.0.45-7.el5.i386

Libmysqlclient_r.so.15 is needed by mysql-server-5.0.45-7.el5.i386

libmysqlclient_r.so.15 (LIBMYSQLCLIENT_15) is needed by mysql-server-5.0.45-7.el5.i386

MySQL = 5.0.45-7.el5 is needed by mysql-server-5.0.45-7.el5.i386

Perl-dbd-mysql is needed by mysql-server-5.0.45-7.el5.i386

[Root@localhost centos]# RPM-IVH mysql-5.0.45-7.el5.i386.rpm

Preparing ... ########################################### [100%]

1:mysql ########################################### [100%]

[Root@localhost centos]# RPM-IVH mysql-server-5.0.45-7.el5.i386.rpm

error:failed dependencies:

Perl-dbd-mysql is needed by mysql-server-5.0.45-7.el5.i386

[Root@localhost centos]# RPM-IVH perl-dbd-mysql-3.0007-1.fc6.i386.rpm

Preparing ... ########################################### [100%]

1:perl-dbd-mysql ########################################### [100%]

[Root@localhost centos]# RPM-IVH mysql-server-5.0.45-7.el5.i386.rpm

Preparing ... ########################################### [100%]

1:mysql-server ########################################### [100%]

[Root@localhost centos]#

1 2 Next page > full text reading tips: Try "←→" button, turn the page more convenient Oh!

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.