Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> Sharing Mysql?, With multiple users
Termina
post Mar 7 2004, 03:35 AM
Post #1


RMS is my Hero
******

Group: Support Specialist
Posts: 862
Joined: 18-February 04
From: Wisconsin
Member No.: 2,404



I am running php/mysql, and would like to be able to share access to mysql without having my tables and whatnot being open to that person.

I have mysql set up to accept only root (and then a password). Is there a way to allow other users access to mysql (and have them be seperate from each other)?

In short, I want Billy, Tim, and Hank to be able to use mysql, and not be able to see the others data. I also don't want them to be sharing the root-mysql account thing. happy.gif

I hope this is possible!

Thanks


--------------------
*Points finger at the author above him* They're a witch! Burn them!
---
Vist my website!
Join me in IRC! Server: st0rage.org Channel: #UnhandledExceptions
Go to the top of the page
 
+Quote Post
hughesjr
post Mar 7 2004, 06:52 AM
Post #2


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



Yep ... that is possible ... (ISPs use one copy of mysql for all their users on a server).

What version of mysql are you using ... issue the command:

mysql -V

Mine in my gentoo distro I am currently installing is:
mysql Ver 12.22 Distrib 4.0.17, for pc-linux-gnu (i686)

You have to set up multiple users and setup which databses they have access to ... go here and read to get a feel for the creation of other users and the assignment of permissions....then if you have any questions, I'll try to answer them. (I am a DBA in real life ... but I use oracle (mostly). I am using mysql on my MythTV box to hold program information)


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
Termina
post Mar 7 2004, 12:32 PM
Post #3


RMS is my Hero
******

Group: Support Specialist
Posts: 862
Joined: 18-February 04
From: Wisconsin
Member No.: 2,404



mysql Ver 12.22 Distrib 4.0.16, for pc-linux-gnu (i686) happy.gif

I've added some useres, but they all can access every database. happy.gif

What command would I use to limit them?
GRANT all privileges on * to will@localhost identified by 'pass';
is what I used to add will, and I tried
REVOKE all privileges on mysql.* to will@localhost identified by 'pass';
by that didn't work. XD


--------------------
*Points finger at the author above him* They're a witch! Burn them!
---
Vist my website!
Join me in IRC! Server: st0rage.org Channel: #UnhandledExceptions
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 19th October 2017 - 01:25 PM