priveleges

[mike]

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

[Aggro]

mi**@getresultz.com wrote:

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

No, if you use GRANT-syntax, you don't need to do anything. If you edit
the privileges by normal SQL queries, you need to run "FLUSH PRIVILEGES"
command for them to take effect. But just use the GRANT and you are fine.

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

mysql -u username -p databasename

[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!

[Fivestar]

Well, I tried entering the GRANT command in phpMyAdmin and I did get
the error message about the user@localhost not having privileges.
Seems that this command must be run using only the root account from
the command line?

Strange though how I can run a query from the admin screen but not from
the web form and the web form is not giving me the privilege error,
just empty set.

BTW, the web form I am using does work on another domain. It's just a
generic query handler I got out of one of my php books.

[Aggro]

mi**@getresultz.com wrote:

I cannot get command line to work...probably because I cannot locate to
mysql directory.
Try from your shell the whereis command, it might tell the location:
$ whereis mysql
Can I enter the GRANT command from phpMyAdmin to give the user all
access to the database? What is the correct syntax for that?

grant all on databasename.* identified by username@localhost identified
by 'password';