phpmyadmin and mysql users (logging in) [solved]

[bunder]

got phpmyadmin installed and working, and i also created another db and user... using the mysql CLI, the user can access their db, but not via phpmyadmin... it won't even let them log in... i'm thinking it's some sort of permissions thing, any ideas?

thanks

edit: solved it, my own dumbass fault...

turns out that % as a hostmask doesn't include localhost.
_________________

[trossachs]

Bunder, that permissions should I enable (or disable) to ensure that each mysql user only has access to his/her databases when they log into phpmyadmin?

[bunder]

lets see here...

all but grant on their database... they'll be able to see information_schema, but only things relevant to their user.
_________________

[trossachs]

This is what I thought originally. They can see information_schema, but not the two databases that I have granted them access to.

[trossachs]

Have not granted them anything within 'global privileges.'

[bunder]

just usage.
_________________

[trossachs]

The only privilege he has is 'USAGE' he has not anything else.

What I am trying to do is to enable my users to each have access to their own databases. I want them to be able to create, drop and fully administer their OWN databases, but have nothing to do with anyone else.

Can this be done?

[trossachs]

Sorted!

The original user was created within Mysql prior to the installation of phpMyAdmin, so I deleted the user and created it within Php, all OK now. Have logged on into the account and the only database showing is the one to which I have assigned permissions to.