FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


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 Brick wall
Related topics
Mysql database=localhost?
Cron Job to Backup MySQL Database
Mysql database problem
PHPBB MYSQL Database Question.
MySQL database for a forum
Mysql database size?
[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
Easy script to backup mysql database, and can attached to ow
Reply to topic    Frihost Forum Index -> Computers -> Computer Problems and Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.