Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what are the characteristics of MySQL database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

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

two。 Support AIX, FreeBSD, HP-UX, Linux, MacOS, NovellNetware, OpenBSD, OS/2Wrap, Solaris, Windows and other operating systems

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

4. Support for multithreading and make full use of CPU resources

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

6. It can be used not only as a separate application in the client server network environment, but also as a library embedded in other software to provide multilingual support. Common codes such as GB2312 and BIG5 in Chinese and Shift_JIS in Japanese can be used as data table names and data column names.

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

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

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

How to install MySQL database

First, check whether Mysql software rpm-qa is installed on your computer | grepmysql

If it is not installed, put it in the CD: rpm-ivhmysql-server-*.rpm (if it cannot be installed directly, prompt an error such as libmysqlclients.so.15isneeded)

So, go to the CenOS directory under the CD:

[chinastor.com-root@localhostCentOS] #

Rpm-ivhmysql-server-5.0.45-7.el5.i386.rpm

Error:Faileddependencies:

Libmysqlclient.so.15

Isneededbymysql-server-5.0.45-7.el5.i386

Libmysqlclient.so.15

(libmysqlclient_15) is

Neededbymysql-server-5.0.45-7.el5.i386

Libmysqlclient_r.so.

15isneededbymysql-server-5.0.45-7.el5.i386

Libmysqlclient_r.so.

15 (libmysqlclient_15) isneededbymysql-server-5.0.45-7.el5.i386

Mysql=5.0.45-7.el5

Isneededbymysql-server-5.0.45-7.el5.i386

Perl-DBD-MySQL

Isneededbymysql-server-5.0.45-7.el5.i386

[chinastor.com-root@localhostCentOS] #

Rpm-ivhmysql-5.0.45-7.el5.i386.rpm

Preparing...

# [100%]

1:mysql

# [100%]

[chinastor.com-root@localhostCentOS] #

Rpm-ivhmysql-server-5.0.45-7.el5.i386.rpm

Error:Faileddependencies:

Perl-DBD-MySQLis

Neededbymysql-server-5.0.45-7.el5.i386

[chinastor.com-root@localhostCentOS] #

Rpm-ivhperl-DBD-MySQL-3.0007-1.fc6.i386.rpm

Preparing...

# [100%]

1:perl-DBD-MySQL

# [100%]

[chinastor.com-root@localhostCentOS] #

Rpm-ivhmysql-server-5.0.45-7.el5.i386.rpm

Preparing...

# [100%]

1:mysql-server

# [100%]

[chinastor.com-root@localhostCentOS] #

Attention, please:

Resolve package dependency order: Perl-DBD= > mysql= > mysql-server

Or, if your Internet speed is fast, you can rise to the sky in one step: yuminstallmysql-server

Startup and automatic operation of Mysql service

Platitudes of the topic, omitted here, you can refer to the commands of other services.

Log in

Mysql default user name is "root", password is empty, login for the first time:

Mysqladmin-uroot-p original password New password

So you can change the password.

This is the end of the content of "what are the features of MySQL database". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.