4.17 Installing many servers on the same machine
In some cases you may want to have many different mysqld deamons (servers)
running on the same machine. You may for example want to run a new version
of MySQL for testing together with an old version that is in production.
Another case is when you want to give different users access to different
mysqld servers that they manage themself.
One way to get a new server running is by starting it with a different
socket and port as follows:
shell MYSQL_UNIX_PORT=/tmp/mysqld-new.sock
shell MYSQL_TCP_PORT=3307
shell export MYSQL_UNIX_PORT MYSQL_TCP_PORT
shell scripts/mysql_install_db
shell bin/safe_mysqld
The environment variables appendix includes a list of other environment
variables you can use to affect mysqld. See section A Environment Variables.
The above is the quick and dirty way that one commonly use for testing. The
nice thing with this is that all connections you do in the above shell will
automaticly be directed to the new running server!
If you need to do this more permanently, you should create an own option
file for each server. See section 4.16.5 Option Files. In your startup
script that is executed at boot time (mysql.server?) you should specify for
both servers:
safe_mysqld --default-file=path-to-option-file
At least the following options should be different per server:
port=#
socket=path
pid-file=path
Sandeep
[EMAIL PROTECTED]
- Original Message -
From: "K.K" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 12:12 PM
Subject: Can't find mysqladmin
Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I
actually upgraded mysql to the newest version and everything went fine and
it verified after the installation was done.
The problem that I have is that I cannot log into mysql now. I have tried
to located mysqladmin anywhere on the server and it seems to be missing
and
I cannot log into MYSQL. However when I do a ps -ef I can see that
safe_mysqld is running along with the three other processes.
Any clues on how to log in would be appreciated
(It has just been one of those days)
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
