|
|
Posted by Virginner on 06/07/06 16:25
"Frances" <fdr58@yahoo.com> wrote in message
news:44859872$0$15789$14726298@news.sunsite.dk...
| 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..
Hi Frances,
Don't get confused about XAMPP. It's just an installer that does the job of
setting everything up for you. It also has a couple of extras like the
control panel thing. You are NOT running XAMPP - you are running Apache,
MySQL etc...
XAMPP installs a MySQL server which can be used by *anything* from
*anywhere* in the world (given global access to your PC).
It sounds a bit like you had all sorts of cr*p (MS stuff!) on your PC before
you started. So, get rid of IIS, SQL Server, any old MySQL etc, and start
with a clean setup. It might even be worth killing your firewall
Run the XAMPP installer, start Apache, start MySQL Click on Admin next to
the Apache button. (You don't have to run stuff as services until you know
it all works).
Go to the security section.
It'll whinge about MySQL having no password. Scroll down to
http://localhost/security/xamppsecurity.php
Click on it, and put in a password.
Restart the MySQL server with the control applet.
Now try the phpMyAdmin
Now try a script, eg:
<?php
$dbok = mysql_connect('127.0.0.1', 'root',
'this_is_my_root_password_cause_i_just_changed_it');
?>
by-the-way #1, you can get MySQL to run on any port (not just 3306)
by-the-way #2 No, you do not need drivers for anything that natively
understands MySQL. For things that don't, eg. Microsoft Access, you use a
common "interface" which is ODBC - go to mysql.com and download the Windows
version, install it, then you can query your MySQL using, say, Excel!!!
D.
[Back to original message]
|