PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Mon Nov 24, 2014 3:03 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Thu Sep 23, 2010 7:10 pm 
Offline
Forum Contributor
User avatar

Joined: Wed Apr 14, 2010 4:45 pm
Posts: 372
Location: UK
Hi,

I hope this question isn't too dumb :)

My background is that I can do basic Linux stuff but I don't have much experience configuring the basic (L)AMP applications. I do understand what security measures I need to take but not necessarily the commands to carry them out.

I'm in the middle of administrating a client's server and now have to make sure MySQL is set-up and configured securely. I've created a root password and can log in locally to access MySQL, but when I did

Syntax: [ Download ] [ Hide ]
SELECT host, user, password FROM user;


to list the accounts in the mysql DB it returned five values:

localhost : root : PASSWORD
127.0.0.1 : root : PASSWORD
xx.xx.xx.xx.blah.blah.com : root : PASSWORD (this the address of the server from a reverse look-up)
localhost: :
127.0.0.1 : :

My questions are:

1. Do I need both the localhost and 127.0.0.1 entries for root?
2. When I update root's password, do the three entries all get updated?
3. What's the purpose of the two blank accounts? Can I delete them?

Any links to good info on securing MySQL would be appreciated as well.

Thanks in advance,

Mecha Godzilla


Top
 Profile  
 
PostPosted: Fri Sep 24, 2010 3:51 am 
Offline
DevNet Master
User avatar

Joined: Wed Jun 27, 2007 9:44 am
Posts: 4294
Location: Sofia, Bulgaria
http://dev.mysql.com/doc/refman/5.0/en/ ... leges.html

_________________
Image
http://openfmi.net/projects/flattc/ Linux is better :)


Top
 Profile  
 
PostPosted: Sat Sep 25, 2010 1:51 pm 
Offline
Forum Contributor
User avatar

Joined: Wed Apr 14, 2010 4:45 pm
Posts: 372
Location: UK
Thanks - that's just what I needed :)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group