MySQL 5 on Linux manual Installation

The following article describes how to manually install MySQL 5 on Linux. we divide it into 11 parts, we hope that you will gain some benefits in the manual installation of MySQL 5 on Linux after browsing. The following is the specific operation content of the article.

1. MySQL 5 on Linux manual installation method,

Download "mysql()and php )))))-standard-5.0.27-linux-i686-icc-glibc23.tar.gz". The ICC version is recommended, which is said to be 10-20% better than GCC.

2. Copy to/usr/local/and decompress:

Tar zxvf mysql(and PHP combination of character -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)

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. 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 during MySQL 5 on Linux manual installation. 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

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.