MySQL 5 on Linux manual Installation

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.