Question
connecting for mysql
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
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
