PHP 5.3.5-1 connect to MySQL DB on localhost, Ubuntu 11.04

Question

trying to get my first little PHP script to connect to a local mySql database and am having some trouble. I used a cookie cutter script from the net to get going and am having some issues. In order to debug so far all I've done is place echo statements before and after the line where I connect to the database and noticed that there is a problem with the connection statement.

Here is the code i'm using, taken verbatim from W3Schools:

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Persons");

while($row = mysql_fetch_array($result))
  {
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
  }

mysql_close($con);
?>

Naturally I changed the passwords and all that and verified that I can connect to the database from the mysql command line tool.

Any tips would be greatly appreciated.

Here is the log located at: /var/log/mysql/error.log

Version: '5.1.54-1ubuntu4'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
110727  1:38:22 [Note] /usr/sbin/mysqld: Normal shutdown

110727  1:38:22 [Note] Event Scheduler: Purging the queue. 0 events
110727  1:38:23  InnoDB: Starting shutdown...
110727  1:38:25  InnoDB: Shutdown completed; log sequence number 0 15895194
110727  1:38:25 [Note] /usr/sbin/mysqld: Shutdown complete

110727 14:08:56 [Note] Plugin 'FEDERATED' is disabled.
110727 14:08:56  InnoDB: Initializing buffer pool, size = 8.0M
110727 14:08:56  InnoDB: Completed initialization of buffer pool
110727 14:08:57  InnoDB: Started; log sequence number 0 15895194
110727 14:08:58 [Note] Event Scheduler: Loaded 0 events
110727 14:08:58 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.54-1ubuntu4'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

SO I learn't how to get some meaningful debug info from PHP thanks to @nix, add the following lines to the top of the php file:

ini_set('display_errors', 1);
ini_set('log_errors', 1);
ini_set('error_log', dirname(__FILE__) . '/error_log.txt');

No error message is displayed unfortunately... how can I force PHP to show me errors? — Bnjmn
– Bnjmn, Commented Jul 27, 2011 at 19:21
How did you notice there was a problem with the connection statement then? — Mat
– Mat, Commented Jul 27, 2011 at 19:23
by throwing in an echo statement before this line: $con = mysql_connect("localhost","peter","abc123"); and after that line I observed that only one of the outputs made it, thus the script must have been interrupted at that line. — Bnjmn
– Bnjmn, Commented Jul 27, 2011 at 19:32

ThatGuy · Accepted Answer · 2011-07-28 04:25:53Z

1

Well. try restarting mysql daemon:

sudo service mysqld restart

try connecting to mysql from command line using

-h localhost

and

-h 127.0.0.1

Also - check for exact error you're getting in:

/var/log/mysql.err

or

/var/log/mysql/mysql.log

P.S. your code works for me.

UPDATE: So - in the end as it turns out - mysqli was disabled in PHP. Problem solved.:)

edited Jul 28, 2011 at 4:25

answered Jul 27, 2011 at 19:08

ThatGuy

15.1k2 gold badges31 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

ThatGuy Over a year ago

as usual: this is just an advice on troubleshooting steps. OP clearly states: Any tips would be greatly appreciated. Downvoter - please explain your logic.

Chris Cunningham Over a year ago

+1; if there is an answer to this question then it looks something like this.

Bnjmn Over a year ago

Restarted the service, same unfortunate result.

ThatGuy Over a year ago

Try posting the content of your /etc/mysql/my.cnf file on pastie.org so we can take a look

ThatGuy Over a year ago

bind-address = 127.0.0.1 - means that mysql listens on 127.0.0.1 only. You have to use that in your mysql script or comment this line out. Don't forget to restart mysqld after any my.cnf changes. There! solved :)

|

Bnjmn · Accepted Answer · 2011-07-27 20:36:41Z

0

So it turns out that the php5-mysql library was not installed.

sudo apt-get install php5-mysql

that's it!

Thanks to @nix for taking care of this one.

answered Jul 27, 2011 at 20:36

Bnjmn

2,0091 gold badge21 silver badges34 bronze badges

1 Comment

ThatGuy Over a year ago

If you never used PHP before; create php file with this content: <?php echo phpinfo();?> When you open it in the browser - you'll see a lot of information about your PHP install. You'll be able to easily determine if required extensions are installed.

Collectives™ on Stack Overflow

PHP 5.3.5-1 connect to MySQL DB on localhost, Ubuntu 11.04

2 Answers 2

8 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related