https://launchpad.net/mysql-sandbox/

[yehlu]

下載
https://launchpad.net/mysql-sandbox/mys ... .26.tar.gz

安裝 mysql-sandbox
http://www.ttlsa.com/html/1107.html

代碼: 選擇全部

# tar zxvf MySQL-Sandbox-3.0.25.tar.gz -C ../software/
# perl Makefile.PL
# make
# make test
PERL_DL_NONLAZY=1 /usr/bin/perl “-MExtUtils::Command::MM” “-e” “test_harness(0, ‘blib/lib’, ‘blib/arch’)” t/*.t
t/01_modules.t …………………. ok
t/02_test_binaries.t ……………. ok
t/03_test_sandbox.t …………….. ok
t/04_test_sbtool.t ……………… ok
t/05_test_smoke.t ………………. ok
t/06_test_user_defined.t ………… ok
t/07_test_user_defined.t ………… ok
t/08_test_single_port_checking.t …. ok
t/09_test_multiple_port_checking.t .. ok
t/10_check_start_restart.t ………. ok
t/11_replication_parameters.t ……. ok
t/12_custom_user_pwd.t ………….. ok
t/13_innodb_plugin_install.t …….. ok
t/14_semi_synch_plugin_install.t …. ok
t/15_user_privileges.t ………….. ok
t/16_replication_options.t ………. ok
All tests successful.
Files=16, Tests=53, 2 wallclock secs ( 0.03 usr 0.20 sys + 1.26 cusr 0.68 csys = 2.17 CPU)
Result: PASS
# make install

下載 MySQL
http://www.mysql.com/get/Downloads/MySQ ... mysql.com/

使用 mysql-sandbox 安裝mysql

代碼: 選擇全部

make_sandbox mysql-5.0.96-linux-i686-glibc23.tar.gz

[yehlu]

http://fghjk.blog.51cto.com/4359709/771157
到这里可能会有报错
用export设置变量使ROOT用户可用
export SANDBOX_AS_ROOT=1
最好的做法是写到root用户的 .bash_prefile下
echo >> export SANDBOX_AS_ROOT=1 .bash_profile

[yehlu]

root@metroasis17:~# make_sandbox mysql-5.0.96-linux-i686-glibc23.tar.gz
Use of uninitialized value $ENV{"SANDBOX_BINARY"} in concatenation (.) or string at /usr/local/bin/make_sandbox line 125.
unpacking /root/mysql-5.0.96-linux-i686-glibc23.tar.gz
Executing low_level_make_sandbox --basedir=/root/5.0.96 \
--sandbox_directory=msb_5_0_96 \
--install_version=5.0 \
--sandbox_port=5096 \
--no_ver_after_name \
--my_clause=log-error=msandbox.err
>>/tmp
The MySQL Sandbox, version 3.0.26
(C) 2006-2012 Giuseppe Maxia
installing with the following parameters:
upper_directory = /root/sandboxes
sandbox_directory = msb_5_0_96
sandbox_port = 5096
check_port =
no_check_port =
datadir_from = script
install_version = 5.0
basedir = /root/5.0.96
tmpdir =
my_file =
operating_system_user = root
db_user = msandbox
remote_access = 127.%
ro_user = msandbox_ro
rw_user = msandbox_rw
repl_user = rsandbox
db_password = msandbox
repl_password = rsandbox
my_clause = log-error=msandbox.err
master =
slaveof =
high_performance =
prompt_prefix = mysql
prompt_body = [\h] {\u} (\d) >
force =
no_ver_after_name = 1
verbose =
load_grants = 1
no_load_grants =
no_run =
no_show =
do you agree? ([Y],n) Y
loading grants
.. sandbox server started
Your sandbox server was installed in $HOME/sandboxes/msb_5_0_96

[yehlu]

代碼: 選擇全部

./change_ports 3306
 ln -s /tmp/mysql_sandbox3306.sock /var/run/mysqld/mysqld.sock

[yehlu]

代碼: 選擇全部

mysql mysql -u msandbox -p