configure php to link to MySql in Suse 10.1

mikeotieno · 10-20-2006, 04:31 AM

Hi,
Pliz could someone help me please i have php configured and its doing good, while also i have mysql running i create databases and tables from the MySql CLI, but when i try connecting my php applications to the databases created in MySql i cant get any positive results, I have not changed anything in the php.ini file. And again is there any package i can use that comes with the Open Suse 10.1 that is MySqlAdmin for the GUI mysql. Thanx for help.

karpi · 10-21-2006, 04:46 AM

Hi,

are there any error-messages while connecting to MySQL?
(Maybe you have to enable displaying errors with the normal php output - Display_Errors in the PHP.INI)
--restart the Apache after saving any changes to the php.in

A (good) GUI for MySQL is phpMyAdmin. phpMyAdmin is part of OpenSuse. You can install it with YaST.
phpMyAdmin is Browserbased. To start it enter http://hostname/phpMyAdmin
But you have to provide the usernaem and password to access MySQL

HTH

mikeotieno · 10-25-2006, 09:29 AM

thanx alot for the reply but i cant see te MySqlAdmin in my yast software management, also when i load the script to connect to mysql i dont get any reply the page is just empty. Is there anything i need to change in the php.ini file?

karpi · 10-25-2006, 10:00 AM

Hi,

Mysqladmin is a commandline-tool. You have to look for phpMyAdmin.

Place a script in /srv/www/htdocs called phptest.php with

<?php
echo phpinfo();
?>

and check if the mysql extension is installed/activated.

phpinfo will give you also the path to the php.ini file.
Activate the error-reporting by

display_errors=On

Or you must look at /var/log/apache2/errors.log

HTH

mikeotieno · 10-25-2006, 10:09 AM

thanx for quic reply but i have alredy run the script of phpinfo.php and its responding positively its displaying the php page and showing me the modules included plus the mysql module but now when i connect it to any database i crete in mysql commandline interface its not showing anything on the page. Its blank. Any idea to this response?