How do I set this up, So mysql users can only see and manage their own mysql databases, Im not concerned about who can access phpmyadmin I have set that up all I want is:
ablity to add users which can only see and add & run queries on their own databases.
You could try defining owners to databases. Then only owner can do something on that database. And user can only see the databases which he has privileged