Hi,
I am new to the forum and have little experience of using MYSQL, PHP and Apache.
I am using Red Hat Linux v 8.0, PHP 4.4.2 and MYSQL server 3.23.52.
I am wanting to create a database or try to get the example of the "Pet Shop Catalogue" in the PHP and MYSQL dummies book to work first before I try developing my own database. Each time it comes up with an error of "Cannot connect to the database." I have entered the SQL for the example in the program given in the book, made sure that PHP is working and Apache Web page is up and running and MYSQL server is running in the back ground.
Also I tried to enter the SQL directly into the server but to no avail. Below shows the status of the MYSQL server.
mysql Ver 11.18 Distrib 3.23.52 for pc-linux -gnu (i686)
connection id 1
current database
current user root@localhost
current pager stdout
using outfile ' '
server version 3.23.52
protocol version 10
connection Localhost via UNIX socket
client characterset latin1
server characterset latin1
Unix socket /var/lib/mysql/mysql.sock
Threads 1 Questions 2 Slow Queries 0 Opens 6 Flush Tables 1 Open Tables 0 Queries per second avg 0.009
Any help to solving my problem would be much appreciated.
Regards,
Andy M