One user per mysql database

rvec

I have a mysql server but in a couple of months some people need some databases. I can host those but I don't want to give them access to my databases. So I need to find a way to give 5-10 users access to one database each. The shouldn't be able to even see any other database as the one they own.

I can connect with ssh, phpmyadmin, and navicat mysql.

johanfh

connect with ssh
start mysql (mysql -u [username] -p [password])
create the databases you need (or do that with navicat), for example 'mydata'
create a new user with all rights to this database (and to nothing else):
grant all privileges on mydata.* to 'newusername'@'localhost' identified by 'newpassword' ;
repeat this for each database.
reload the permissions: flush privileges
(use the instructions I wrote in italic)

Good luck!

rvec

lol thx
flush Brick wall