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

Mysql database=localhost?
[MySQL database] Password and username
Inserting PHP multidimensional arrays into a mySQL database
mysql database table structure
Connecting to 2 different Mysql database and tables?

PHP that creates subdomain, ftp account, and mysql database?
Maximum MYSQL database size
MySQL Database...unique usernames
Cron Job to Backup MySQL Database
Mysql database problem

PHPBB MYSQL Database Question.
MySQL database for a forum
Mysql database size?
Connect to MySql database
insert data to mySQL database problem