LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-10-2011, 01:44 AM   #1
moyorakkhi
Member
 
Registered: Jan 2011
Location: Dhaka
Posts: 80

Rep: Reputation: 1
MySQL Permission


Hi,

In our SQL server we have 200+ databases of different websites. Each database has it's own users. While granting privileges for a new database, I've found that each of the database user has permission like this:

Code:
"| GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'vector'@'192.168.0.%' IDENTIFIED BY PASSWORD '2ea812c979ef46a1'       |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `vector`.* TO 'vector'@'192.168.0.%' |".
Like database user 'vector', all database user has access to *.* and also to the specific database. Is this risky to have this kind of permission? The previous admin created those account. If I remove the first permission from all database user will there me any problem? Thanks for you help in advance.
 
Old 05-10-2011, 02:01 AM   #2
micxz
Senior Member
 
Registered: Oct 2002
Location: CA
Distribution: openSuSE, Cent OS, Slackware
Posts: 1,131

Rep: Reputation: 75
unless vector needs to access all dbs I think it's safe to remove the first permissions. Might be risky to have his password out on the forums
 
Old 05-10-2011, 04:03 AM   #3
moyorakkhi
Member
 
Registered: Jan 2011
Location: Dhaka
Posts: 80

Original Poster
Rep: Reputation: 1
Quote:
Originally Posted by micxz View Post
unless vector needs to access all dbs I think it's safe to remove the first permissions. Might be risky to have his password out on the forums
Thanks for the advice dude. BTW, it's not the actual password :P
 
Old 05-10-2011, 03:24 PM   #4
micxz
Senior Member
 
Registered: Oct 2002
Location: CA
Distribution: openSuSE, Cent OS, Slackware
Posts: 1,131

Rep: Reputation: 75
Quote:
Originally Posted by moyorakkhi View Post
it's not the actual password :P
I should have mentioned I have been know to crack stupid jokes.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Permission on MySql Directory ethereal1m Slackware 4 09-02-2010 03:28 AM
[SOLVED] Debian Etch, Wordpress+mysql: setup-mysql script = permission denied oznola Linux - Server 9 04-07-2010 09:08 PM
MySQL permission problem Lmax Linux - General 3 09-24-2004 02:12 PM
MySQL Permission Question chrisk5527 Linux - General 0 11-17-2003 06:20 PM
mysql permission vcheah Linux - Software 5 11-26-2002 04:35 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:04 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration