LINUX上多MYSQL服务安装试验
作者 佚名技术
来源 Linux系统
浏览
发布时间 2012-05-13
| LISTEN [root@ff_girl mysql5122]# netstat -an | grep 3308 tcp 0 0 0.0.0.0:3308 0.0.0.0:* LISTEN 拥有帝国一切，皆有可能。欢迎访问phome.net [root@ff_girl mysql5122]# /usr/local/mysql/bin/mysql -uroot -p -S/tmp/mysql1.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.1.22-rc-log MySQL Community Server (GPL) Type ''help;'' or ''h'' for help. Type ''c'' to clear the buffer. mysql> q Bye [root@ff_girl mysql5122]# /usr/local/mysql/bin/mysql -uroot -p -S/tmp/mysql2.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.1.22-rc-log MySQL Community Server (GPL) Type ''help;'' or ''h'' for help. Type ''c'' to clear the buffer. mysql> q Bye [root@ff_girl mysql5122]# 2、另外一种. [root@ff_girl mysql512]# chown -R root . [root@ff_girl mysql512]# chown -R mysql data [root@ff_girl mysql512]# chgrp -R mysql . [root@ff_girl mysql512]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql512/ --datadir=/usr/local/mysql512/data/ [root@ff_girl mysql512]# cp support-files/my-huge.cnf /etc/my512.cnf 并且修改如下部分. [client] port = 3308 socket = /tmp/mysql512.sock # The MySQL server [mysqld] user=mysql basedir=/usr/local/mysql512 datadir=/usr/local/mysql512/data port = 3308 socket = /tmp/mysql512.sock [root@ff_girl mysql512]# /usr/local/mysql512/bin/mysqld_safe --defaults-file=/etc/my512.cnf & [root@ff_girl mysql512]# /usr/local/mysql/bin/mysql -uroot -p -S/tmp/mysql512.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.1.22-rc-log MySQL Community Server (GPL) Type ''help;'' or ''h'' for help. Type ''c'' to clear the buffer. 拥有帝国一切，皆有可能。欢迎访问phome.net mysql> show databases; -------------------- | Database | -------------------- | information_schema | | mysql | | test | -------------------- 3 rows in set (0.00 sec) mysql> q Bye 确定3308端口是否在运行. [root@ff_girl mysql512]# netstat -an |grep 3308 tcp 0 0 0.0.0.0:3308 0.0.0.0:* LISTEN 把脚本写到启动文件里： /usr/local/mysql512/bin/mysqld_safe --defaults-file=/etc/my512.cnf 拥有帝国一切，皆有可能。欢迎访问phome.net |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢! |
你可能对下面的文章感兴趣
上一篇: linux虚拟机使用小技巧下一篇: linux下DNS的配置
关于LINUX上多MYSQL服务安装试验的所有评论
