Skip to main content
Participant
February 16, 2007
Question

connecting for mysql

  • February 16, 2007
  • 4 replies
  • 418 views
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
This topic is closed to new replies. Start a new post to keep the conversation going.

4 replies

Inspiring
February 16, 2007
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/
tefnutAuthor
Participant
February 19, 2007
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