mysql unix 安装教程_MySQL 的安装步骤

FOR mysql5.0

# Install mysql

groupadd mysql

useradd -g mysql -s `which nologin` mysql

cd /infowarelab

tar zxf /infowarelab/src/mysql-standard-5.0.24a-linux-x86_64-glibc23.tar.gz

mv mysql-standard-5.0.24a-linux-x86_64-glibc23 mysql

cd mysql

scripts/mysql_install_db --user=mysql

chown -R root .

chown -R mysql data

chgrp -R mysql .

bin/mysqld_safe --user=mysql &

cd bin

./mysqladmin -u root password 'password'

# To verify mysql installation

./mysqladmin -u root -ppassword version

./mysqladmin -u root -ppassword variables

# To make sure the mysql server could be shutdown and startup normally

./mysqladmin -u root -ppassword shutdown

cd /infowarelab/mysql

bin/mysqld_safe --user=mysql &

# Post-Installation: Start mysql automatically

cd bin

./mysqladmin -u root -ppassword shutdown

ps -ef | grep mysql

cp /infowarelab/mysql/support-files/mysql.server /etc/init.d/mysql

chmod +x /etc/init.d/mysql

chkconfig --add mysql

chkconfig --level 345 mysql on

# Post-Installation: my.cnf configuration

# For <10.0.0.34>

cp /infowarelab/src/34.my.ini /etc/my.cnf

# For <10.0.0.35>

cp /infowarelab/src/35.my.ini /etc/my.cnf

# Restart the mysql instance

cd /infowarelab/mysql

bin/mysqld_safe --user=mysql &

ps -ef | grep mysql

FOR mysql5.5

创建用户组mysql和账号mysql

groupadd mysql

useradd –m –g mysql mysql

创建数据目录和日志目录

su – mysql

mkdir data   logs

解压缩二进制包

tar zxvf mysql-5.5.39-linux2.6-x86_64.tar.gz -C /usr/local

mv /usr/local/mysql-5.5.39-linux2.6-x86_64/ /usr/local/mysql

cd /usr/local/

chown -R mysql:mysql mysql

拷贝配置文件并配置相关选项

cp /usr/local/mysql/support-files/my-innodb-heavy-4G.cnf  /etc/my.cnf

增加配置选项：(和原有配置文件重复的，删除老的)

basedir=/usr/local/mysql

datadir=/home/mysql/data

character-set-server=utf8

log_bin=/home/mysql/logs/bin

binlog_format=ROW

innodb_data_home_dir=/home/mysql/data

innodb_data_file_path=ibdata1:2048M;ibdata2:2048M:autoextend

innodb_log_group_home_dir=/home/mysql/logs

innodb_log_file_size=1G

innodb_flush_method=O_DIRECT

innodb_file_per_table

删除innodb_log_file_in_group=3

初始化系统数据库

cd /usr/local

scripts/mysql_install_db  --user=mysql --datadir=/home/mysql/data

拷贝启动脚本到服务列表

cp support-files/mysql.server /etc/init.d/mysql

ln -snf /usr/local/mysql/bin/* /usr/local/bin

启动mysql

service mysql start