priveleges

I have a virtual dedicated server on GoDaddy which has Redhat, Apache,
PHP, MySQL, and Plesk Reloaded installed. Plesk runs MySQL-Admin to
administer databases.

I have not problem logging in and setting up new domains, and php runs
fine locally in each domains webspace, however, I have set up a
database for one domain and cannot access it via php. It appears to be
a problem with privileges.

I found some info about setting privileges using 'grant access on ...'
but cannot get these to work.

I am not very familiar with *nix, php, or mysql having come from a
Windows NT, MSSQL environment so I am kinda in the dark at this point.

Questions:

1. Where is the base installation of mysql located? I cannot seem to
find it on the server. I have found several mysql folders in various
locations but they do not seem to have the service files in them. Is
there an easy way to determine where the service is being run from?

2. Is it necessary to stop/restart the service before or after setting
privileges.


This might be enough help to get me going in the right direction.
Any other thoughts or suggestions would be appreciated.

Thanks in Advance,

Mike

  >>What error is PHP giving you? And can you login with the same
username &
  >>password using "mysql" - command line tool?

I cannot get command line to work...probably because I cannot locate to
mysql directory.

I can log in via Plesk / phpMyAdmin and execute the SQL to add table
and data to the database but when I try to run a query from web page, I
get "empty result set".

Query is: select * from LISTINGS

The table LISTINGS has 25 records in it. When I am in phpMyAdmin, I
can run the query SELECT * FROM `LISTINGS` WHERE 1 and it will return
the data, however, if I cut and paste this into the
mysql_queryhandler.php web form, it results in "empty result set".

Now, I was getting an error earlier about user@localhost not having
privileges but I deleted the domain and set it up again from scratch
and I no longer get the error.

Can I enter the GRANT command from phpMyAdmin to give the user all
access to the database? What is the correct syntax for that?

Thaks for the reply and help!