I have six different sites set up with their respective databases on my server all linking to one localhost ip. Three of those users I set up from root have access only to the one database associated but the other three when show databases command reveal all databases. Not sure how that happened.
How do I make it so each user has only access to respective database? Must have set them up differently but cannot remember how.
It's a drupal multi-site and ultimately I'd like to have just one user and password to access all databases which I do have with root but for drupal settings each database has a necessary set user and pass and before I created individual ones I was making changes to one database which was affecting all else. So until I learn how to prefix them I am trying to keep all separate. Does it matter, what is the best practice - I don't know. The question here remains in the middle.