mysql for linux 安装_mysql for linux 安装

1.如果安装linux时有预装的mysql版本不是5.6,卸载.

(卸载时用图形介面会更方便)

2.在root下安装mysql 5.6.

rpm -ivh  MySQL-client-advanced-5.6.14-1.rhel5.x86_64.rpm

rpm -ivh  MySQL-server-advanced-5.6.14-1.rhel5.x86_64.rpm

3.设置mysql下root密码

vi /root/.mysql_secret  查看密码

service mysql start

mysql -uroot -p    回车后输入/root/.mysql_secret中的密码

SET PASSWORD = PASSWORD('xxxx');

4.配置目录

cd /u02

mkdir mysqldata

chown -R mysql:mysql mysqldata

cd /u03

mkdir mysqldata mysqllog

cd mysqllog

mkdir binlog

chown -R mysql:mysql mysqldata mysqllog

cd /u03

mkdir mysqlbackup mysqldump

chown -R mysql:mysql mysqlbackup mysqldump

5.修改/usr/my.cnf参数

[mysqld]

datadir =/u02/mysqldata

innodb_buffer_pool_size=16G       ##目前松岗使用内存的一半

innodb_additional_mem_pool_size=20M

innodb_log_file_size=256M

innodb_log_files_in_group=3

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

6.複製数据库到新目录:

service mysql stop

cp  -r  /var/lib/mysql/  /u02/mysqldata/

service mysql start

7.新建mysql用户

GRANT all privileges ON *.* TO mysql@'localhost' IDENTIFIED BY 'xxxx';

这样mysql已经装完了,但为了能实现备份,还需安装以下文件:

MySQL-shared-advanced-5.6.14-1.rhel5.x86_64.rpm

MySQL-shared-compat-advanced-5.6.14-1.rhel5.x86_64.rpm

perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm

percona-toolkit-2.2.5-1.noarch.rpm

percona-xtrabackup-2.1.5-680.rhel5.x86_64.rpm

安装完成后,在crontab中加入以下备份脚本:

--crontab -l

00 00 * * * sh /exp/mysqlbk/fullbackup.sh

--cat /exp/mysqlbk/fullbackup.sh

#backup full

filedir="/u03/mysqlbackup/full/"

action_time=`date +%Y_%m_%d`

del_time=`date -d "15 day ago"  +%Y_%m_%d`

machine="zxfymysql01" ##备份标识

echo action time:$action_time

echo "backup full data"

innobackupex --defaults-file=/usr/my.cnf --user=mysql --password=xxxx --stream=tar $filedir 2>$filedir/$machine\_$action_time.log | gzip - > $filedir/$machine\_$action_time.tar.gz

#del backup data

echo "delete  dump data 15 day ago"

rm -rf $filedir/$machine\_$del_time.tar.gz

rm -rf $filedir/$machine\_$del_time.log

echo "delete 15 backup data OK!"

PS:

1.默认mysql数据库都放在一个目录.可以通过linux下的ln的方式改变数据库到不同目录.

如:数据目录为/u02/mysqldata ,

mv /u02/mysqldata/dbname /u03/mysqldata

cd /u02/mysqldata

ln -s  /u03/mysqldata/dbname dbname

2.默认只能进行本地连接mysql.通过以下更改:

mysql -uroot -p

use mysql;

update user set host='%' where host='localhost';

flush privileges;

3.mysql在linux下结构

/usr/bin   Client programs and scripts

/usr/sbin The mysqld server

/var/lib/mysql Log files, databases

/usr/my.cnf  profile **

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28539951/viewspace-1309652/，如需转载，请注明出处，否则将追究法律责任。