Database: MySQL database server installation and configuration

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!