Problems with phpMyAdmin and mySQL

[Michael Forster]

I have looked for other groups to assist but the only mysql group I could
find is a german one,

I am trying to set up a control user on mysql to allow different people
access to their and only their databases, I followed the instructions on the
installation instructions on creating the user but now I get a reply of
Server localhost
Error

MySQL said:


Access denied for user: 'phpadmin@localhost' (Using password: YES)
phpadmin is the control user which should be given the following rightsonly
SELECT privelige on mysql.user (except column password) mysql.db (All
columns) and mysql.tables (except Grantor and Timestamp)Can anyone help at
all?Mike.

[Timo Voipio]

Michael Forster wrote:

> I am trying to set up a control user on mysql to allow different people
> access to their and only their databases, I followed the instructions on the
> installation instructions on creating the user but now I get a reply of

If it is not absolutely mandatory to use phpmyadmin, how about trying out
MySQL AB's MySql Control Center? Works like a charm.
<http://www.mysql.com/downloads/mysqlcc.html>

-Timo

--
Timo Voipio | Helsinki, Finland | ICBM at: 60 11.800 N 024 52.760 E
GeekCode ver 3: GU>CC d s-: a--- C++ UL(+)$>+++$ P+>+++ L++(+) E- W++ N++
o? K? w O M- V- PS PE Y+ PGP+ t 5++ X R tv- b++(++++) DI+ D G e- h! r !y
Remove +newsharvested to e-mail me | Poista +newsharvested jos meilaat

[Michael Forster]

"Timo Voipio" <tvoipio+newsharvest@iki.fi> wrote in message
news:bi2mtj$4i86v$1@ID-106564.news.uni-berlin.de...

> Michael Forster wrote:
>

> > I am trying to set up a control user on mysql to allow different people
> > access to their and only their databases, I followed the instructions on

the

> > installation instructions on creating the user but now I get a reply of

>
> If it is not absolutely mandatory to use phpmyadmin, how about trying out
> MySQL AB's MySql Control Center? Works like a charm.
> <http://www.mysql.com/downloads/mysqlcc.html>
>

unfortunately I am providing a web based interface and the machine running
MySQL is just a webserver with mysql and php/perl/python/java installed.
So the idea is to use the http config of phpMyAdmin to provide the hosted
users to access their own databases independantly rather than having to ask
me to do things.

Mike.