connecting for mysql

[tefnut]

Hi
I've made a MySQL database on my local PC (xp) and I'm trying to connect to it in DW.

When I try to see the tables it says there are 'no tables found'
I'm quite new the MySQL and php, but i have found in the connections file it says this:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_phoneList = "localhost";
$database_phoneList = "phoneList";
$username_phoneList = "root";
$password_phoneList = "mysql";
$phoneList = mysql_pconnect($hostname_phoneList, $username_phoneList, $password_phoneList) or trigger_error(mysql_error(),E_USER_ERROR);
?>

can anyone help, do I need to create an odbc?

Thanks

[Newsgroup_User]

tefnut wrote:
> $hostname_phoneList = "localhost";
> $database_phoneList = "phoneList";
> $username_phoneList = "root";
> $password_phoneList = "mysql";

If you are connecting as the root user and the root password is mysql,
these settings are correct. If those values are correct and you are
still getting "no tables found", make sure that a software firewall
isn't blocking access to MySQL.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[tefnut]

Hi David

Do you mean a Windows Firewall? if so its turned off,
As far as I know these settings are correct apart form $hostname_phoneList = "localhost" is that the name of my computer which is something else?

Thanks

[Newsgroup_User]

tefnut wrote:
> Do you mean a Windows Firewall? if so its turned off

Not only Windows firewall, but any other one, such as ZoneAlarm, McAfee,
Norton...

> As far as I know these settings are correct apart form $hostname_phoneList =
> "localhost" is that the name of my computer which is something else?

localhost is how every computer refers to itself. In 90% of cases of
connecting to MySQL, it's the correct name. For connection on your own
computer, it's definitely the right name.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[tefnut]

I still cant see the tables, when i test the connection in DW it says it's ok