mysql多实例my.cnf_mysql多实例，my.cnf 4G conf配置安装配置

errorhttp://www.phperz.com/article/14/1208/39937.html一.准备测试软件 mysql-5.5.36系统版本 CentOS release 6.5 (Final) 64bit———————————————————————————-|实例     |端口 |data位置        |配置文件         |启动文件                     |———————————————————————————-|mysql3306|3306 |/data/mysql_3306| /etc/my3306.cnf |/etc/init.d/mysql.server3306 |———————————————————————————-|mysql3307|3307 |/data/mysql_3307| /etc/my3307.cnf |/etc/init.d/mysql.server3307 |———————————————————————————-下载软件包一般放在 /opt/mysql里wget http://downloads.mysql.com/archives/get/file/mysql-5.5.36.tar.gztar -zxvf mysql-5.5.36.tar.gzyum -y install cmake yum -y install gcc gcc-c++  autoconf  automake  zlib*  fiex* libxml*  ncurses-devel libmcrypt* libtool-ltdl-devel*  cmake cmake-gui libaio-devel  bision (诺出现Error: Missing Dependency: kernel-headers glibc装不上)http://vault.centos.org/5.8/os/x86_64/CentOS/kernel-headers-2.6.18-308.el5.x86_64.rpm下载wget http://vault.centos.org/5.7/os/x86_64/CentOS/kernel-headers-2.6.18-274.el5.x86_64.rpm安装rpm -ivh kernel-headers-2.6.18-274.el5.x86_64.rpmhttp://blog.sina.com.cn/s/blog_8f27abe50101204l.html创建用户groupadd mysqluseradd -g mysql -s /sbin/nologin -M mysql创建安装目录，授权用户mkdir -p /data/mysql5536chown -R mysql:mysql /data/二.安装解压安装(设定安装默认位置为/data/mysql5536)cd /opt/mysql/mysql-5.5.36cmake . -DCMAKE_INSTALL_PREFIX=/data/mysql5536 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1  -DWITH_INNOBASE_STORAGE_ENGINE=1  -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1make && make install 如果这里编译失败，请删除CMakeCache.txt。再安装晚依赖在重新cmake。否则会一直提示错误。三.数据库文件(创建实例)初始化数据库/data/mysql5536/scripts/mysql_install_db –basedir=/data/mysql5536/ –datadir=/data/mysql_3306 –user=mysql创建my.cnf文件cp my.cnf my3306.cnfvi /data/mysql_3306/my.cnf[client]port        = 3306           #默认3306socket        = /data/mysql_3306/mysql.sock  [mysqld]port        = 3306socket        = /data/mysql_3306/mysql.sockdatadir=/data/mysql_3306user=mysqlwait_timeout=1814400 interactive_timeout=1814400lower_case_table_names=1expire-logs-days = 1skip-name-resolve[mysqld_safe]log-error=/data/mysql_3306/mysqld.logpid-file=/data/mysqld_3306/mysqld.pid记得这里将实例的路径拥有者修改为mysqlchown -R mysql:mysql /data/mysql_3306四.启动数据库启动该数据库实例cp /data/mysql5536/support-files/mysql.server /etc/init.d/mysql.server3306vi /etc/init.d/mysql.server3306将默认的conf=/etc/my.cnf修改为 conf=/etc/my3306.cnf打开数据库/etc/init.d/mysql.server3306 start|stop|restart                 #/data/mysql5536/bin/mysqld_safe  –defaults-extra-file=/data/mysql_3306/my.cnf  –datadir=/data/mysql_3306  –user=mysql &关闭数据库实例五.多实例的安装使用第三步在创建另外一个实例 假如另外一个实例是监听3307端口1)初始化这个实例数据库/data/mysql5536/scripts/mysql_install_db –basedir=/data/mysql5536/ –datadir=/data/mysql_3307 –user=mysql2)创建该实例的my.cnf文件vi /etc/my3307.cnf[client]port        = 3307           #默认3306socket        = /data/mysql_3307/mysql.sock  [mysqld]port        = 3307socket        = /data/mysql_3307/mysql.sockport        = 3306socket        = /data/mysql_3307/mysql.sockdatadir=/data/mysql_3306wait_timeout=1814400 interactive_timeout=1814400lower_case_table_names=1expire-logs-days = 1skip-name-resolve记得这里将实例的路径拥有者修改为mysqlchown -R mysql:mysql /data/mysql_33073)启动该实例 同上面第四步cp /data/mysql5536/support-files/mysql.server /etc/init.d/mysql.server3307vi /etc/init.d/mysql.server3307将默认的conf=/etc/my.cnf修改为 conf=/etc/my3307.cnf打开数据库/etc/init.d/mysql.server3307 start|stop|restart进入指定数据库mysql -uroot -p -S /data/mysql_3306/mysql.sock grant all privileges on *.* to ‘admin’@’%’ identified by ‘123456’;grant all privileges on *.* to ‘admin’@’locatehost’ identified by ‘123456’;参考文档http://blog.chinaunix.net/uid-25760152-id-3472603.html

文章知识点与官方知识档案匹配，可进一步学习相关知识MySQL入门技能树安装和登录安装32345 人正在系统学习中 相关资源：经典刻录软件尼禄Nero6.6.1.4中文安装版及序列 -其它工具类资源…