|
Posted by Bret Hughes on 02/18/05 09:57
On Fri, 2005-02-18 at 01:47, David Freedman wrote:
> I am trying my FIRST php file with an attempt to connect
> to my mySql server.
>
> <?php
> // Connecting, selecting database
> $link = mysql_connect('localhost', 'host', 'my_passqword')
> or die('Could not connect: ' . mysql_error());
> echo 'Connected successfully';
> mysql_select_db('eatc7402') or die('Could not select database');
>
> // Performing SQL query
> $query = 'SELECT * FROM my_table';
> $result = mysql_query($query) or die('Query failed: ' . mysql_error());
> ==============================
> more code to print results.
> ..
> ..
> ============================
> // Free resultset
> mysql_free_result($result);
>
> // Closing connection
> mysql_close($link);
> ?>
>
> The problem is it won't connect to the database. The server IS running. The
> host, username,
> and password are the exact same thing I use to connect the mySqlAdmin tool
> to the database.
> Doesn't seem like this should be that difficult. How can I discover why it
> doesn't
> seem to connect.
>
what is in the mysql log? chances are it is a db permission issue since
you are not running as the same user as the server is.
There was a thread like this earlier this week maybe even today?
look in the archives of this list.
Bret
Navigation:
[Reply to this message]
|