Hands-on teaching you how to install MySQL 5.1.37

Source: Internet
Author: User
Keywords Installation

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.