Why doesn't a new MySQL user have its own list of databases?

[avahi]

I have the user 'root', it has about 5 databases. I made a new user, and ran a 'show databases;' command on its account. Why can it see Root's databases? I want to make it so each user can only see and manage their own DBs. How can I accomplish this?

Thanks

[grantemsley]

You need to set the permissions appropriately. phpMyAdmin is the easiest way to manage the permissions.

[Kolipoki]

You need to set the permissions appropriately. phpMyAdmin is the easiest way to manage the permissions.
Avahi: Give PHPMyAdmin a try. Is webbase managed and you won't want to do anything without it after trying it.sudo apt-get install phpmyadminAfter installing it, just go to http://yourdomain.com/phpmyadmin and log in with you MySQL root (or privileged user) password. (Would be even better if you got SSL on that server so you can log in with HTTPS)

[NewbieNik]

or if you prefer maintainence from the ubuntu desktop:-

sudo apt-get install mysql-admin

It appears in your Application -> Programming Menu..
My sql admin tool of choice.(See what I did there? My sql..get it?)

[cariboo907]

You can also give a user the same privileges as root with the following command. Start the mysql console and at the prompt type:

grant all privileges on *.* to <user>@'localhost'
identified by '<password>' with grant option;
grant all privileges on *.* to <user>@'%'
identified by '<password>' with grant option;

The second line starting with grant also allows that user remote access.