Application system is CentOS 6.x MySQL version 5.1
The SELinux and iptables can be closed in advance.
[Email protected] ~]# chkconfig iptables off
[Email protected] ~]# chkconfig ip6tables off
[[email protected] ~]# /etc/init.d/iptables Stop
[[email protected] ~]# /etc/init.d/ip6tables Stop
[Email protected] ~]# sed-i "s/linux=.*/linux=disabled/g"/etc/selinux/config
If you want to take effect after you change selinux, you need to restart the server, reboot or Shutdown-r now
Yum install make apr* autoconf automake gcc gcc-c++ OpenSSL openssl-devel pcre-devel gd kernel keyutils patch perl ker Nel-headers compat* MPFR cpp glibc libgomp libstdc++-devel ppl cloog-ppl keyutils-libs-devel libcom_err-devel libsepol-de Vel libselinux-devel krb5-devel zlib-devel libxpm* freetype libjpeg* libpng* php-common php-gd ncurses* libtool* libxml2 L Ibxml2-devel Patch
These are support packages in order to prevent the error ahead of Yum
1 Download MySQL database l to/usr/local/src/
[Email protected] tmp]# cd/usr/local/src/
[Email protected] src]# wget http://mirrors.sohu.com/mysql/MySQL-5.1/mysql-5.1.73-linux-i686-glibc23.tar.gz
Http://mirrors.sohu.com/mysql/MySQL-5.1/mysql-5.1.73-linux-x86_64-glibc23.tar.gz
There may be an error: You may not have installed the Wget tool, executed the Yum install-y wget installation wget This tool, this way also note that the version of your system has 32-bit and 64-bit, according to its own version of the download the corresponding MySQL. Below I installed is 32 bit, the step is the same.
[[email protected] src]# ls
Mysql-5.1.73-linux-i686-glibc23.tar.gz
Download completed, the process may be a bit slow, may have a connection with their own speed.
[Email protected] src]# Du-sh mysql-5.1.73-linux-i686-glibc23.tar.gz
124M mysql-5.1.73-linux-i686-glibc23.tar.gz
2 Decompression
[Email protected] src]# tar zxvf mysql-5.1.73-linux-i686-glibc23.tar.gz
[[email protected] src]# ls
Mysql-5.1.73-linux-i686-glibc23
Mysql-5.1.73-linux-i686-glibc23.tar.gz
[Email protected] src]# Du-sh mysql-5.1.73-linux-i686-glibc23
410M mysql-5.1.73-linux-i686-glibc23
3 Move the extracted data to the/usr/local/mysql
[Email protected] src]# MV Mysql-5.1.73-linux-i686-glibc23/usr/local/mysql
4 Build MySQL User
[[email protected] src]# useradd-s/sbin/nologin-m MySQL
Create a run MySQL user-s not login-M do not create home directory
5 Copy configuration file
[[email protected] mysql]# ls
Bin data include Lib Mysql-test scripts Sql-bench
COPYING docs install-binary man README share support-files
[Email protected] mysql]# CD support-files/
[[email protected] support-files]# ls
Binary-configure my-huge.cnf Mysqld_multi.server
Config.huge.ini my-innodb-heavy-4g.cnf Mysql-log-rotate
Config.medium.ini my-large.cnf mysql.server
Config.small.ini my-medium.cnf Ndb-config-2-node.ini
Magic MY-SMALL.CNF
[Email protected] support-files]# CAT/ETC/MY.CNF
(System created configuration file, not required, then directly overwrite on it)
[email protected] support-files]# CP my-large.cnf/etc/my.cnf
6 Copy the startup script file and modify its properties
[[email protected] support-files]# ls
Binary-configure my-huge.cnf Mysqld_multi.server
Config.huge.ini my-innodb-heavy-4g.cnf Mysql-log-rotate
Config.medium.ini my-large.cnf mysql.server
Config.small.ini my-medium.cnf Ndb-config-2-node.ini
Magic MY-SMALL.CNF
[Email protected] support-files]# ls/etc/init.d/
Abrt-ccpp cgred kdump nfslock restorecond SMARTD
ABRTD cpuspeed killall ntpd rngd sshd
Abrt-oops crond Lvm2-lvmetad ntpdate rpcbind SSSD
Acpid cups lvm2-monitor Numad rpcgssd Sysstat
ATD functions Mdmonitor ODDJOBD RPCIDMAPD Udev-post
AUDITD Haldaemon messagebus portreserve RPCSVCGSSD winbind
AutoFS Halt netconsole postfix rsyslog ypbind
Blk-availability ip6tables Netfs Psacct Sandbox
Certmonger iptables Network quota_nld SASLAUTHD
Cgconfig irqbalance NFS Rdisc Single
[Email protected] support-files]# CP mysql.server/etc/init.d/mysqld
[Email protected] support-files]# mkdir-p/data/mysql
(Create a separate/data/partition)
[Email protected] support-files]# chown-r mysql/data/mysql/
(change owner to MySQL)
[Email protected] support-files]# vi/etc/init.d/mysqld
# in THE/ETC/MY.CNF, ~/.my.cnf or other MySQL configuration files.
# If you change the base dir, you must also the change DataDir. These may get
# Overwritten by settings in the MySQL configuration files.
Basedir=/usr/local/mysql
datadir=/data/mysql/
[[email protected] support-files] #ll/etc/init.d/mysqld (View permissions)
-rwxr-xr-x. 1 root root 12511 April 8 17:00/etc/init.d/mysqld
7 Initializing the database
[Email protected] src]# cd/usr/local/mysql/
[[email protected] mysql]# ls
Bin data include Lib Mysql-test scripts Sql-bench
COPYING docs install-binary man README share Support-files
[Email protected] mysql]#/scripts/mysql_install_db--user=mysql --datadir=/data/mysql/
Initializing Libraries --user defines the owner of the database, the --datadir defines where the database is installed, and it is recommended to place the partition on a large space, which needs to be created on its own.
[[email protected] mysql]# echo $? (The result is 0, indicating that the running result is normal)
0
9 Add the startup script to the system service entry, and set the boot start, start MySQL
[Email protected] support-files]# chkconfig--add mysqld
[Email protected] support-files]# chkconfig mysqld on
[Email protected] support-files]# chkconfig--list |grep mysqld
Mysqld 0: Off 1: Off 2: Enable 3: Enable 4: Enable 5: Enable 6: Off
[[email protected] mysql]# /etc/init.d/mysqld start
Starting MySQL. success!
10 launch success Let's check it out.
[Email protected] profile.d]# NETSTAT-LNP
Active Internet connections (only servers)
Proto recv-q send-q Local address Foreign address State Pid/program Name
TCP 0 0 0.0.0.0:3306 0.0.0.0:*
Check the port 3306 OK
[Email protected] mysql]# /usr/local/mysql/bin/mysql
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 1
Server Version:5.1.73-log MySQL Community Server (GPL)
Copyright (c) and/or, Oracle, its affiliates. All rights reserved.
Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.
Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.
Mysql> quit
Login OK, because it is the source package installation, the path of the landing is too long, after the use of the time is very troublesome, here we change
11 Extended Knowledge
[Email protected] ~]# vim/etc/profile.d/path.sh
Create a new path file and add the following:
#!/bin/bash
Export path= $PATH:/usr/local/mysql/bin
Save, exit. OK direct input MySQL haha success
[[email protected] ~]# MySQL
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 1
Server Version:5.1.73-log MySQL Community Server (GPL)
Copyright (c) and/or, Oracle, its affiliates. All rights reserved.
Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.
Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.
Mysql>
Here, my MySQL installation is complete thank you
MySQL installation (for beginners)