|
|
Posted by M. Sokolewicz on 02/18/05 10:37
M. Sokolewicz wrote:
> Bret Hughes wrote:
>
>> 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
>
> actually, I'd suggest he first take another look at his mysql_connect()
> call... I can't recall mysql_connect taking the hostname argument
> *twice*! as in mysql_connect('localhost', 'host', 'password'); I'd bet
> "host" should be replaced with "password"
of course I mean username, not password [stupid me]
Navigation:
[Reply to this message]
|