Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall
Preparatory work
Set up MySQL installation directory
# mkdir-p/home/webuser/software/mysql
# Cd/home/webuser/software/mysql
Download MySQL installation source pack
# wgethttp://mysql.mirror.tw/downloads/mysql-5.1/mysql-5.1.37.tar.gz
# tar zxf mysql-5.1.37.tar.gz
# cd/home/webuser/software/mysql/mysql-5.1.37
Compiling the installation
Setting compilation parameters and compiling environment tests
#/configure \
--PREFIX=/OPT/MYSQL5 \
--with-mysqld-user=webuser \
--with-extra-charsets=all \
--SYSCONFDIR=/OPT/MYSQL5/ETC \
--with-unix-socket-path=/opt/mysql5/var/mysql.sock \
--with-tcp-port=33068 \
--with-big-tables
Start compiling
# make
Setup files
# make Install
Install default data Directory
#/opt/mysql5/bin/mysql_install_db
Modify Configuration
Create and modify a primary configuration file
# CP/OPT/MYSQL5/SHARE/MYSQL/MY-LARGE.CNF/OPT/MYSQL5/VAR/MY.CNF
# Cd/opt/mysql5/var
# VI MY.CNF
Note unknown option, look for "skip-federated" and modify it to the following (blue section)
#skip-federated
Check and save and exit
Start and stop services
To start the service, use a dedicated account (WebUser) operation
# sudo-u Webuser/opt/mysql5/share/mysql/mysql.server Start
Note: The start service command can be added to the/etc/rc.d/rc.local file to enable the service to start automatically with system startup
Stop service, use private account (WebUser) operation
# Sudo-u Webuser/opt/mysql5/share/mysql/mysql.server Stop
Set Administrator password
Confirm that the MySQL service starts running
#/opt/mysql5/bin/mysqladmin-u root password ' password '
This blog describes the reference software, software, 0day, keygen, registration machine can be found in http://www.beeplat.org/, there is a need to download it quickly!
Related reading:
Can the fragmented MySQL restructure the mountains and rivers
A5 security Group on Phpmysql account security
Iis+php+mysql Server Environment Tutorial
How to easily create a MySQL database
MySQL Security lecture live article record