How to install mysql 5.5 (detailed steps)

MySQL is a very popular open source relational database management system and is widely used in the development of Web applications. MySQL 5.5 is an important version of the MySQL database. In this version, performance, scalability and security have been improved, and many new features have been added. It has been widely used in the market. This article will introduce the features of MySQL 5.5. installation steps.

1. Download the MySQL 5.5 installation package

Visit the MySQL official website download page and choose the MySQL 5.5 version suitable for your server. Generally speaking, the Linux version is the most commonly used. For CentOS systems, you can download the RPM package. For Ubuntu systems, you can download the .deb package. Click the download button to start downloading.

2. Install MySQL 5.5

There are many ways to install MySQL 5.5. This article mainly introduces how to install the RPM package. Enter the following command on the command line to install:

# rpm -ivh mysql55-server-5.5.xxx.rpm

Note that xxx here is the version number, replace it according to the actual version you downloaded.

3. Start the MySQL service

After completing the installation, you need to start the MySQL service to use it. Enter the following command on the command line:

# service mysqld start

to start the MySQL service.

4. Modify MySQL password

The default root user of MySQL does not have a password. For security reasons, you need to set a password for the root user. The command is as follows:

# mysqladmin -u root password 'new_password'

Note that the new_password here is the password you set yourself and needs to be kept properly to avoid leakage.

5. Test MySQL connection

After completing the above steps, you can use the MySQL client to connect to MySQL locally for testing. Enter the following statement in the command line:

# mysql -h localhost -u root -p

Then enter the root user password you set.

6. MySQL configuration

If you need to configure more MySQL, you can open the MySQL configuration file /etc/my.cnf and modify the configuration items in it, for example Add a configuration item similar to the following:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

Here, datadir specifies the data storage path of MySQL, and socket specifies the socket file path used when MySQL is run. Of course, specific configuration items can be modified as needed.

7. Summary

Through the above steps, we successfully installed MySQL 5.5 and performed basic configuration. You can test it through the MySQL client to ensure that the MySQL service is running correctly. MySQL 5.5 meets the needs of most users by providing better performance, scalability and security, and is widely used in the development and deployment of web applications.

The above is the detailed content of How to install mysql 5.5 (detailed steps). For more information, please follow other related articles on the PHP Chinese website!