No access to the database server?

psubs -- on Nov. 26 2004

Tried to install yacs on my groups web-server.

Using: WIN XP, Apache/2.0.52, PHP/4.3.9, MySQL

Server works fine php scripts work fine MySQl appears to work but I am unsure. Admin allows the creation of 'yacs' database without tables.

Why dose yacs/setup.php end with:

No access to the database server

Impossible to connect to the database server mentioned in your configuration file. Please follow the link to check connection parameters.

Jump to the configuration page

Please help

?

paul

Bernard from nearby-an-airport Associate, 6696 posts	on Nov. 26 2004 Paul, Under Windows I am using EasyPHP, with a very straightforward support of MySQL that allows YACS to do everything on setup. But on other MySQL installations it may be not so easy. Maybe you could create a 'yacs' database manually, and relaunch the setup script to create and populate tables. Give me some feed-back on this
Psubs 2 posts	inspired from Bernard on Nov. 27 2004 In reply to Bernard: I am able to create the YACS database in MySQL. It does not appear that the php scripts are able to communicate with the MySQL server. Does anyone know of a simple php script that could verify wether or not the MySQL server is responding to php requests? I cannot find any other setup requirement on Apache, PHP or MySQL to allow them to talk to one another. I am considering the use of EasyPHP but while it sounds tempting, I would like to try to make this work first. Still looking for suggestions. Thanks, PAUL
Bernard from nearby-an-airport Associate, 6696 posts	on Nov. 27 2004 Paul, have to tried following parameters: server: the name or IP address of your MySQL server user: root password: <none> (I mean, leave this field empty) database: yacs Apparently MySQL accepts a default account to access the database, which is 'root' with no password. Therefore my suggestion. Does it help?
Psubs 2 posts	inspired from Bernard on Nov. 27 2004 In reply to Bernard: Thanks for the help. But alas, still no difference. Paul
Bernard from nearby-an-airport Associate, 6696 posts	on Nov. 27 2004 Paul, have you considered to install phpMyAdmin on your server as well? This one comes with EasyPHP, but it is also available separately. If you are not familiar with native MySQL, maybe a set of PHP forms would be more simple to handle...

5 comments

Rate this page
Posted by Psubs on Nov. 26 2004, commented by Bernard on Nov. 26 2004, (popular)