Install MySQL 5.1 in Linux

　　1. Download MySQL installation-free/binary software(No compilation required)

File Format: MYSQL-VERSION-OS.tar.gz

　　2. Create a MySQL group, create a MySQL user, and add the user to the mysql group.

(In Unix of different versions, groupadd and useradd syntaxes may be slightly different .)

# Groupadd mysql

# Useradd-g mysql

　　3. Enter the/usr/local directory, decompress the installation-free version, and create a soft link named mysql in this directory.

# Cd/usr/local

# Gunzip </path/to/MYSQL-VERSION-OS.tar.gz | tar xvf-

(This command creates a new directory named MYSQL-VERSION-OS under this directory .)

(Gunzip is no longer needed when using GNU tar. You can directly use the following command to unpack and extract and distribute the package:

#> Tar zxvf/path/to/mysql-VERSION-OS.tar.gz)

# Ln-s MYSQL-VERSION-OS mysql

　　4. Add a MySQL configuration file

If you want to set an option file, use one of the support-files directories as the template. There are four template files in this directory, which are customized based on the memory of different machines.

# Cp support-files/my-medium.cnf/etc/my. cnf

(You may need to run these commands with the root user .)

　　5. Set Directory Access Permissions. Use mysql_install_db to create a MySQL authorization table for initialization, and set the access permissions for mysql and root accounts.

# Cd mysql

# Chown-R mysql.

# Chgrp-R mysql.

# Scripts/mysql_install_db-user = mysql

# Chown-R root.

# Chown-R mysql data

(Note that the "." symbol in the preceding command cannot be fewer .)

　　6. Run MySQL

# Bin/mysqld_safe-user = mysql &

(If there is no problem, a prompt like this should appear:

[1] 42264

# Starting mysqld daemon with databases from/usr/local/mysql/var

If a statement such as mysql ended is displayed, it indicates that Mysql is not started normally. You can find the problem in log. The Log file is usually configured in/etc/my. cnf.

Most problems are caused by incorrect permission settings. )

　　7. Set the root password. The default installation password is blank. To ensure security, you need to change the password.

#/Usr/local/mysql/bin/mysqladmin-uroot password yourpassword

　　8. Copy a script in the compilation directory and set automatic start upon startup.

# Cp support-files/mysql. server/etc/rc. d/init. d/mysqld

# Chmod 700/etc/init. d/mysqld

# Chkconfig-add mysqld

# Chkconfig-level 345 mysqld on

　　9. Start the mysqld service

# Service mysqld start

　　10. Check whether port 3306 is enabled. Make sure to open the port in the firewall.

# Netstat-atln

Installation-free/binary basic commands:

Shell> groupadd mysql

Shell> useradd-g mysql

Shell> cd/usr/local

Shell> gunzip </PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf-

Shell> ln-s FULL-PATH-TO-MYSQL-VERSION-OS mysql

Shell> cd mysql

Shell> chown-R mysql.

Shell> chgrp-R mysql.

Shell> scripts/mysql_install_db-user = mysql

Shell> chown-R root.

Shell> chown-R mysql data

Shell> bin/mysqld_safe-user = mysql &