|
|
Posted by Frances on 12/18/35 11:50
thank you very much for yr help.. just posted a question in MySQL ng to
find out more details about upgrading etc.. but also would like to ask
about something you mentioned: if from XAMPP I connect to MySQL server
outside XAMPP installation I need a driver, but otherwise I don't, is
this what you are saying? gosh, this is getting complicated.. ideally
I would like to connect to MySQL from Tomcat, XAMPP, IIS..
(also need to solve this port issue, so can use Tomcat, IIS, and XAMPP
all w/o having to turn servers off an on all the time.. when I installed
IIS I changed it to port 8080 so it wouldn't conflict w/Tomcat, but
still when I installed XAMPP Apache wouldn't start b/c of IIS.. now
had to turn IIS off to run Apache.. I don't get that (again b/c had set
up IIS to run on port 8080.. and indeed load IIS stuff in browser with
http:localhost:8080....)
many thanks...
Frances
R. Rajesh Jeba Anbiah wrote:
> Frances wrote:
> <snip>
>
>>THEN: 1) can I use the same db's I've been using w/4.1 with 5.0?
>
>
> I guess, yes. But, not sure. You try.
>
>
>> 2)
>>how do I "transfer" the db's that come w/PHP to this installation?
>
>
> You copy and paste mysql\data directory and then done (hopefully).
>
>
>> 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....
>
>
> If password is set, you need to use; otherwise no.
>
>
>>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..
>
>
> You may then need to go for ODBC <http://in.php.net/odbc>
>
> --
> <?php echo 'Just another PHP saint'; ?>
> Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com/
>
Navigation:
[Reply to this message]
|