Mysql database server installation and configuration tutorial

[Introduction] MySQL is a small relational database management system. It was developed by the Swedish company MySQLAB and was acquired by Sun on January 16, 2008. MySQL is widely used in small and medium-sized websites on the Internet. Due to its small size, fast speed and low total cost of ownership, especially the open source code, MySQL is a small relational database management system. The developer is the Swedish MySQLAB company. It was acquired on January 16, 2008. Acquired by Sun Corporation. MySQL is widely used in small and medium-sized websites on the Internet. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, many small and medium-sized websites choose MySQL as their website database in order to reduce the total cost of website ownership.

It has the following characteristics:

1. Written in C and C++, and tested using a variety of compilers to ensure the portability of the source code

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

3. Program for a variety of The language provides an API. These programming languages ​​include C, C++, Eiffel, Java, Perl, PHP, Python, Ruby and Tcl, etc.

4. Support multi-threading, make full use of CPU resources

5. Optimized SQL query algorithm, effectively improve query speed

6. Can be used as a separate application The program is applied in a client-server network environment and can also be embedded into other software as a library to provide multi-language support. Common encodings such as Chinese GB 2312, BIG5, Japanese Shift_JIS, etc. can be used as data table names and data Column name

7. Provide multiple database connection channels such as TCP/IP, ODBC and JDBC

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

9. Can handle large databases with tens of millions of records

1. Mysql installation

First, check whether the Mysql software rpm is installed on your computer -qa | grep mysql

If it is not installed, insert the CD: rpm -ivh mysql-server-*.rpm (if it cannot be installed directly, an error such as libmysqlclients.so.15 is needed will be prompted)

Then, enter 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]#### ######Please note: #########Solution order of package dependencies: Perl-DBD=>mysql=>mysql-server######Or, your Internet speed is fast , you can achieve success in one step: yum install mysql-server######### 2. Starting and automatically running the Mysql service######### is a commonplace topic. I will omit it here. You can refer to other topics. service commands. ######### 3. Login#########Mysql default user name is "root", the password is empty, first login: ######mysqladmin -u root -p original Password New password ###### This way you can change your password. ######### IV. Set up phpMyAdmin #########1. Download phpMyAdmin-version number.tar.gz######2. Unzip it to /var/www/html , modify the permissions if necessary######3. Access it in the browser######If an error "Unable to load mysql extension, please check PHP settings" appears, under CenOS, it is missing Caused by php-mysql software, enter the DVD disc: ######[root@localhost CentOS]# rpm -ivh php-pdo-5.1.6-20.el5.i386.rpm######Preparing.. . ######################################### [100%]## ####1:php-pdo ######################################## ## [100%]######[root@localhost CentOS]# rpm -ivh php-mysql-5.1.6-20.el5.i386.rpm######Preparing... ### ###################################### [100%]###### 1:php-mysql #########################################[100 %]###### can be done! ###

The above is the detailed content of Mysql database server installation and configuration tutorial. For more information, please follow other related articles on the PHP Chinese website!