mySQL connects to the root!

Hi, connecting to a single MySQL database with a unique password and db name seems to access all the databases on the server? Is this right? It seems that it would be a security risk.
1 person has
this question
  • Walter (Customer Support Representative) August 23, 2012 21:41
    This is a nuance of how MySQL operates: regardless of which database you connect to, you can always see a listing of the other databases in the installation. However, access permissions for your connected user will still be respected. That is, if you do not have permission to access a certain table or database, then you won't be able to open it from the app (this is enforced by the server itself).
  • (some HTML allowed)
    How does this make you feel?
    Add Image

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited