mysql安装部署文档

1、Mysql搭建手册 2015年10月9日目录（一）MySQL数据库服务器初始化2一、安装介质准备：2二、数据库服务器初始化范围：2三、使用root用户登录各个系统并初始化：2服务器为Linux系统：redhad6 64位（一）MySQL数据库服务器初始化一、安装介质准备：1.mysql5.5.372.cmake3.bison2.5二、数据库服务器初始化范围：注：数据库账户规划1. 删除匿名用户。2. root允许从任何地点访问数据库（由于导入的原图视需要），对所有数据库有所有权限。密码： 123456 3. 主库的sqlslave允许从库连接主库，可以执行replicate操作

2、。密码为:654321三、使用root用户登录各个系统并初始化：1. 查看服务器是否自带mysql，如果有就卸载#rpm -qa | grep mysql#rpm -e -allmatches -nodeps mysql通过rpm -qa | grep name验证以下软件包是否已安装以下依赖包。gcc.* gcc-c+* ncurses* ncurses-devel* zlib* libxml* libgcrypt* libtool*3.建立软件存放目录和备份目录、脚本目录#mkdir /data/TRS/soft#mkdir /data/TRS/backup#mkdir /data/TRS

3、/shell4. 安装MySQL上传MySql5.5.37、cmake、bison2.5软件及脚本到/data/TRS/softcd /data/TRS/softmkdir /data/TRS/mysql5mkdir /data/TRS/mysql5/DBdatamkdir /data/TRS/mysql5/logmkdir /data/TRS/mysql5/etcmkdir /data/TRS/mysql5/init.dtar zxvf cmake-.tar.gzcd cmake-./configuremake & make installcd

4、 .tar zxvf bison-2.5.tar.gzcd bison-2.5./configuremake & make install cd .tar zxvf mysql-5.5.37.tar.gzcd mysql-5.5.37cmake -DCMAKE_INSTALL_PREFIX=/data/TRS/mysql5 -DSYSCONFDIR=/data/TRS/mysql5/etc -DMYSQL_DATADIR=/data/TRS/mysql5/DBdata -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/data/TRS/mysql5/mysqld

5、.sock -DMYSQL_USER=系统账户名-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE

6、_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_EXAMPLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 make & make installcd /data/TRS/mysql5/cp support-files/my-f /data/TRS/mysql5/etc/fcp support-files/mysql.server /data/TRS/mysql5/init.d/mysqlln -s /data/TRS/

7、mysql5/init.d/mysql /etc/init.d/mysqld5chown -R 系统账户名:root /data/TRSchmod -R 775 /data/TRS/mysql5chkconfig -add mysqld5chkconfig mysqld5 offln -s /data/TRS/mysql5/include/mysql /usr/include/mysqlln -s /data/TRS/mysql5/lib/lib* /usr/lib64/修改自启动脚本：vi /data/TRS/mysql5/init.d/mysqlbasedir = /data/TRS/my

8、sql5datadir = /data/TRS/mysql5/DBdata修改配置文件：vi /data/TRS/mysql5/etc/fmysqlduser =系统账户名basedir = /data/TRS/mysql5datadir = /data/TRS/mysql5/DBdatalog-error = /data/TRS/mysql5/log/mysql5.errpid-file = /data/TRS/mysql5/mysql5.pid#优化内容slow_query_log=ONmax_connections=1000lower_case_table_names=1log_bin_

9、trust_function_creators=1event_scheduler =1wait_timeout=3000query_cache_type=1thread_concurrency=16innodb_file_per_table=1skip-name-resolveinnodb_buffer_pool_size = 2Ginnodb_log_file_size = 256Minnodb_log_buffer_size = 4Minnodb_flush_log_at_trx_commit = 2table_open_cache=800thread_cache_size = 64que

10、ry_cache_size = 256M修改mysqldmax_allowed_packet = 20Mmysqldumpquickmax_allowed_packet = 16MMysql初始化目标：1.删除匿名用户。2.设置root密码为：123456，root允许从所有地点访问数据库，对数据库有所有权限。chown -R系统账户名:root /datachmod -R 775 /datasu -系统账户名cd /data/TRS/mysql5scripts/mysql_install_db -user=系统账户名-basedir=/data/TRS/mysql5 -datadir=/da

11、ta/TRS/mysql5/DBdata service mysqld5 start/data/TRS/mysql5/bin/mysqluse mysql; select user,host,password from mysql.user;delete from mysql.user where user=;update user set password=password(123456) where user=root;grant all privileges on *.* to root% identified by 123456 with grant option;flush priv

12、ileges;select user,host,password from mysql.user;exit;登录到各个服务器配置主从复制注：确认已删除主库和从库的DBdata目录下的mysql-bin*、mysql-relay-bin*、、 主库操作步骤：vi etc/fmysqldserver-id = 1log-bin=mysql-bin log-bin-index=mysql-bin.indexbinlog_format=mixed重启数据库登陆主库grant replication slave on *.* to sqlslave从库I

13、P identified by 密码 with grant option;flush privileges; exit;从库操作步骤：vi etc/fmysqldserver-id = 11log-bin=mysql-binlog-bin-index=mysql-bin.indexbinlog_format=mixedrelay_log = slavel-relay-bin relay-log-index = slavel-relay-bin.indexreplicate-do-db = 要同步的数据库名1replicate-do-db = 要同步的数据库名2replicate-do-db =

14、 testlog_slave_updates=1read-only=1重启数据库登陆数据库mysql stop slave;mysqlchange master to master_host=主库IP,master_port=3301,master_user=sqlslave,master_password=密码;mysql start slave;mysql show slave statusG;验证主从同步效果：在主库上建库 create database 要同步的数据库名1;在从库上查看，是否存在新建数据库。show databases;在主库新建需要的数据库。 create datab

15、ase数据库名;show databases;mysqlgrant all privileges on 数据库名1.* to users% identified by 密码 with grant option;mysqlgrant all privileges on 数据库名2.* to users% identified by 密码 with grant option;mysqlflush privileges;mysql select user,host,password from mysql.user;mysqlexit;在从库：mysqlshow databases;mysqlgrant all privileges on 数据库名1.* t