Posted by Frances on 12/18/54 11:50

R. Rajesh Jeba Anbiah wrote:
> Frances wrote:
> <snip>
>
>>now only thing I can think of is when was intalling got alert that said
>>something like "MySQL seems to be installed [or maybe it said 'running']
>>already -- Aborted.." now I have MySQL intalled already at C:\Program
>>Files\MySQL\MySQL Server 4.1, and I use it with Tomcat (and also connect
>>from stand-alone Java classes); so: can you not have two diff. intances
>>of MySQL servers intalled? is this the problem.. xampp is at
>>c:\xampp.. thank you very much..
>
>
> Yes, if the port is already in use, it cannot be get installed.
>
> --
> <?php echo 'Just another PHP saint'; ?>
> Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com/

oh my gosh, for MySQL it HAS to be port 3306, right?? hmmm..
I assume if I set it up right I should be able to use same MySQL server
for everything right? so: I think maybe what I need to do is for PHP
use MySQL that I'm already using with Tomcat... I think in that case it
would be a good idea for me to upgrade that installation to 5.0... but
THEN: 1) can I use the same db's I've been using w/4.1 with 5.0? 2)
how do I "transfer" the db's that come w/PHP to this installation? and
need to find out how to connect to this MySQL installation instead of
the one that comes w/XAMPP... (what driver does PHP use? I don't see
driver-connection in PHP code.. all code I see to connect to db is

mysql_connect("localhost","root",""); )

how come no password.... in Java I have to do all this to connect to db:

Class.forName("com.mysql.jdbc.Driver").newInstance();
DriverManager.getConnection("jdbc:mysql://localhost:3306/<dbName>?user=root&password=<password>");

need to connect to this same db-server w/PHP (can be a diff db, of
course..) I don't see a password in PHP code to connect, I don't see
mention of any driver.. ok, many thanks..

[Back to original message]