setting up two instances of mySQL
I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't see the point. Why not just have both databases running under the same instance of mySQL? Which brings me to my question. What are the pros and cons of setting up multiple instances of mySQL on the same machine? Thanks so much, CS - 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
changing the root password
I can't remember my root password. I know that there is a way to set it by starting mysql with certain parameters, but I can't remember what those parameters are. Can you help me out? Thanks! - 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
setting ip addresses
How do you tell mysql what ip to listen on for connections? I'm remember seeing a configuration file for this sort of thing somewhere, but the exact file escapes me at the moment. Any help you could give would be great! Thanks, Chris Stefanick - 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
startup error
I just installed mysql-3.23.43-sun-solaris2.7-sparc, but I can not get it to start up. Here's the error I'm getting: ./bin/safe_mysqld --log --log-update Starting mysqld daemon with databases from /koz/mysql-3.23.43-sun-solaris2.7-sparc/data ./bin/safe_mysqld: /koz/mysql-3.23.43-sun-solaris2.7-sparc/data/devnfs.err: cannot create Any help you could give me would be great! Thanks, Cstyle - 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
instillation problems
I've been trying to install mysql-3.23.43 on a SunOS 5.7 machine. I grabbed mysql-3.23.43-sun-solaris2.7-sparc.tar.gz from the ftp site. I've unzipped and untarred the file, but I don't see a configure file or a Makefile for that matter. What gives? When I issue the tar xvf I get the following error: i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error Any help you could give would be great! Thanks, Chris Stefanick - 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