Install and deploy MySQL 5.1.40 for 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

#> 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-u root password yourpassword

8. Go to the mysql page:

Bin/mysql-u root-p

Prompt to enter the password, and then show databases to show that there are some databases, and then use the use mysql database;

9. 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

10. Start the mysqld service

# Service mysqld start

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

# Netstat-atln

12. log on to mysql

Bin/mysql-u root-p

Show databases

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 &

13. Start and Stop the service:

Support-files/mysql. server start

Support-files/mysql. server stop

14. Test after installation:

After the database is installed, the windows client cannot be connected. The general cause is that linux has a firewall and the client machine does not have access permissions. The modification is as follows:

1). chkconfig iptables on is enabled.

Chkconfig iptables off

The above takes effect permanently after restart

/Etc/init. d/iptables stop temporarily takes effect and becomes invalid after restart

2) mysql> use mysql;

Mysql> update user set host = '%' where user = 'root ';

Mysql> flush privileges;

Mysql> select 'host', 'user' from user where user = 'root ';

Mysql> quit