linux安装多个mysql--

《linux安装多个mysql--》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Linux安装多个MySQL>>　　1、按照常规安装。[rootff_girlmysql5122]#choysql5122]#choysqldata[rootff_girlmysql5122]#chgrp-Rmysql.[rootff_girlmysql5122]#cpsupport-files/my-small.f/etc/my5122.f[rootff_girlmysql5122]#scripts/mysql_install_db--basedir=/usr/local/mysql5122/--datadir=/usr/loca

2、l/mysql5122/data/--user=mysqlInstallingMySQLsystemtables...OKFillinghelptables...OKTostartmysqldatboottimeyouhavetocopysupport-files/mysql.servertotherightplaceforyoursystem。。。　　首次启动MYSQL[rootff_girlmysql5122]#bin/mysqld_safe--defaults-file=/etc/my5122.f[1]13700[rootff

3、_girlmysql5122]#08012415:01:46mysqld_safeLoggingto'/usr/local/mysql5122/data/localhost.localdomain.err'.08012415:01:46mysqld_safeStartingmysqlddaemon/usr/local/mysql5122/data[rootff_girlmysql5122]#bin/mysql-uroot-p-S/tmp/mysql5122.sockEnterpassonitor.　mandsendu

4、nityServer(GPL)Type'help;'or'h'forhelp.Type'c'toclearthebuffer.mysql>shoation_schema

5、

6、mysql　　　　　　　

7、

8、test　　　　　　　

9、+--------------------+3roysql>grantshutdoulti_admin'localhost'identifiedby'123456';QueryOK,0roysql>flushpriv

10、ileges;QueryOK,0roysql>exitBye　　停掉MYSQL服务。[rootff_girl~]#/usr/local/mysql5122/bin/mysqladmin-uroot-p-S/tmp/mysql5122.sockshutdoysql5122]#cpdatadata2[rootff_girlmysql5122]#mvdatadata1[rootff_girlmysql5122]#choysqldata2[rootff_girlmysql5122]#chgrp-Rmysql.　　示例配置文件　　[ro

11、otff_girlmysql5122]#cat/etc/my5122.f[mysqld_multi]mysqld　　=/usr/local/mysql5122/bin/mysqld_safemysqladmin=/usr/local/mysql5122/bin/mysqladminuser　　　=multi_adminpassysqld1]socket　　=/tmp/mysql1.sockport　　　=3307pid-file　=/usr/local/mysql5122/data1/david_yeung.pid1datadir　

12、　=/usr/local/mysql5122/data1language　=/usr/local/mysql5122/share/mysql/englishuser　　　=mysql#TheMySQLserver[mysqld2]port　　　　　　=3308socke123下一页>>>>这篇文章来自..，。t　　　　　=/tmp/mysql2.sockpid-file　=/usr/local/mysql5122/data2/david_yeung.pid2datadir　　=/usr/local/mysql5122/data2la

13、nguage　=/usr/local/mysql5122/share/mysql/englishuser　　　=mysql。。。[isamchk]key_buffer=8Msort_buffer_size=8M[myisamchk]k