set up separate (non-cpanel) phpMyAdmin for limited access?

[JCinDE]

I want to set a user up with phpMyAdmin access to a database created just for him. I don't want him to have access to my other DBs. When I configure phpMyAdmin to use the db login created for this user, it reports "no privileges' even though cpanel says that user has ALL privileges.

Can anyone help me figure out what I'm doing wrong here?

Thanks,
-JC

[Jonathan]

I'm not sure if you can do that...
What about setting up his own sub-domain w/ cPanel?

[Dan]

Are you certain you're using the correct user name?

It would be: cpanelusername_username

[Skky]

You can set up your own install of phpMyAdmin (I did so myself). My guess is that you made a mistake in the config file or, as Dan suggested, you didn't write out the username correctly.

Without seeing a config file or anything, I can't really help you any further. I'm assuming you setup a new DB user and database in the mysql section of cPanel? After that you have to add the user to the database you just created for them to have access to it.

[JCinDE]

Turned out to be a botched install...reinstalled the scripts and it works fine now. Thanks!