Summary of MySQL 5.1.31 installation in Linux

According to several documents on the Internet, finally successfully installed the mysql-5.1.31 in Linux. The Installation Process of Version 5.1 differs from that of the previous version in some details, resulting in installation failure several times. The following is a summary:
# Cd/home/data
# Tar zxvf mysql-5.1.31.tar.gz
# Cd/home/data/mysql-5.1.31
# Groupadd mysql
# Useradd mysql-g mysql
#./Configure -- prefix =/usr/local/mysql specified installation directory
-- With-extra-charsets = GBK added support for GBK Chinese characters, determined based on actual development needs or not
-- With-plugins = all if mysql is compiled and installed from the source code, no innodb engine is installed by default. therefore, in configure, add -- with-plugins = all (or max) to support innodb. in mysql, you can run the show engines command to view the storage engines supported by the current mysql server.
# Make
# Make install
# Cp support-files/my-medium.cnf/etc/my. the cnf copy configuration file is available in three environments: large, medium, and small. Depending on the machine performance, if the load is heavy, you can modify the memory usage values of some variables.
Note: this parameter is not required for the new version -- skip-federated in my. cnf. If you need to add -- with-plugins = federated to compile this engine, use the federated parameter in my. cnf.
Modify my. cnf first, and then modify the database. Otherwise, the database will not be able to pass through.
# Scripts/mysql_install_db generate mysql user database and table files
# Cp support-files/mysql. server/etc/init. d/mysqld copy mysqld file started
# Chmod 700/etc/init. d/mysqld
# Cd/web
# Chmod 750 mysql-R
# Chgrp mysql-R
# Chown mysql/var-R # var directory is the new directory
# Cd/web/mysql/libexec
# Cp mysqld. old
# Strip mysqld
# Chkconfig -- add mysqld
# Chkconfig -- level 345 mysqld on
# Service mysqld start
# Netstat-atln

1 2 Next Page