Admin "ONE" MySQL database ? [SOLVED]

heinzg · Last edited by heinzg on Wed Apr 19, 2006 7:31 pm; edited 1 time in total

Hi there All,

Can someone give me a tip!

I have a MySQL server and numerous DBs on it....
I would like to give a mate of mine access to just one DB, via some PHP site.
He should have all rights to do what he wants on that one DB.

I.E. I have a DB Server, DB name, and DB passwd.

Yes i am a tit when it comes to MySQL.... I think i should try "phpmysql" but the config is so overwhelming!

Can some one help me out with a simple config example howto to give full access to one DB running on the MySQL server

Cheers
Heinzg

buzzin · Posted: Tue Dec 20, 2005 5:30 pm Post subject:

Hi,

There are many ways to admin a mysql database, here are just a few;

- install 'dev-db/mysql-administrator' and use this gui tool. (But this seems to be masked atm.)
- install 'webmin' (no config required) and use the mysql admin module to configure your server
- find a copy of 'mysqlcc' gui tool and use this to admin the database
- Use sql syntax to add a user(check mysql.org)

I'd say if you cant get mysql-administrator to run, then webmin is the easiest way to get what you want. It will let you do this and so much more and you'll prolly endup using it for more than just admin'ing your db

Hope that helps a little.

splooge · l33t Joined: 30 Aug 2002 Posts: 636

mysql -u root -p
grant all on database.* to 'username'@'localhost' identified by 'password';
_________________
http://get.a.clue.de

heinzg · Posted: Tue Dec 20, 2005 6:00 pm Post subject:

Thanx for the comments,

the problem I have here is that i am really limited to what I can install on this box. :-(

I know webmin... but can't install it ^^^

What is needed is some sort of web interface cgi or php, where I can give the mate of mine access via .htaccess to the "Web DB Admin GUI" of some sort...

Is there some sort of php script to do this with?

I only find scripts that can do everything, including the dishes! and more,
but not just a simple interface to admin one db.

I don't wana give my dodgie mate ssh & telnet to my box :-)

Heinzg

buzzin · Posted: Tue Dec 20, 2005 11:43 pm Post subject:

if you do what splooge said and then make your mate use mysql-administrator, then he will be able to connect and work ONLY on that db.

heinzg · Posted: Wed Dec 21, 2005 8:11 am Post subject:

thanx working now [SOLVED]