MySQL 5 on Linux manual installation is simple

This article describes how to manually install MySQL 5 on Linux and how to perform the installation, if you are interested in the actual operation steps, you can use the following articles to understand them.

1. Download "mysql()and php )))))-standard-5.0.27-linux-i686-icc-glibc23.tar.gz", and recommend the ICC version, which is said to improve the GCC performance by 10-20%

2. Copy to/usr/local/and decompress the file: tar zxvf mysql(and php ))))-standard-5.x...tar.gz

3. Add users and groups of MySQL (the best combination with PHP ):

Groupadd MySQL (best combination with PHP)

Useradd-g MySQL (the best combination with PHP)

MySQL 5 on Linux manual Installation Method 4. create a symbolic connection:/usr/local # ln-s MySQL (best combination with PHP)-standard-5.x... mySQL (best combination with PHP)

5. cd MySQL (the best combination with PHP). Change the current directory to/usr/local/MySQL (the best combination with PHP )/

6. Run the script to initialize the database:./scripts/MySQL (the best combination with PHP) _ install_db -- user = MySQL (the best combination with PHP)

7. Set permissions:

/Usr/local/MySQL (the best combination with PHP) # chown-R root.

/Usr/local/MySQL (the best combination with PHP) # chown-R MySQL (the best combination with PHP) data

/Usr/local/MySQL (the best combination with PHP) # chgrp-R MySQL (the best combination with PHP)

8. Create and modify/etc/my. cnf as needed. Refer to the Configuration:

[MySQL (the best combination with PHP) d]

# Set the default value to the INNODB table and support transactions:

Default-storage-engine = INNODB

# Set the default character set:

Default-character-set = utf8

# Disable bdb:
Http://www.knowsky.com
Skip-bdb

MySQL 5 on Linux manual Installation Method 9. Start MySQL (the best combination with PHP ):

/Usr/local/MySQL (the best combination with PHP)/bin #. /MySQL (the best combination with PHP) d_safe -- user = MySQL (the best combination with PHP )&

10. initialize the root password:

/Usr/local/MySQL (the best combination with PHP)/bin #. /MySQL (the best combination with PHP) admin-u root-p password "password-of-root"

Enter password: <Enter the old password and press Enter>

11. log on to the root account to create a database:

/Usr/local/MySQL (the best combination with PHP) #./MySQL (the best combination with PHP)-u root-p

Enter password: password-of-root

Create a new user:

MySQL (best combination with PHP)> create user test identified by 'test-password ';

Create a new database:

MySQL (the best combination with PHP)> create database testdb;

Grant the test user the permission to access testdb from localhost:

MySQL (best combination with PHP)> grant all on testdb. * to test @ localhost;

Stop the MySQL (best combination with PHP) server:

/Usr/local/MySQL (the best combination with PHP)/bin #./MySQL (the best combination with PHP) admin-u root-p shutdown

Enter password: password-of-root

STOPPING server from pid file/usr/local/MySQL (best combination with PHP)/data/debian. pid

Xxx MySQL (best combination with PHP) d ended

The above content is an introduction to the manual Installation Method of MySQL 5 on Linux. I hope you will find some gains.