LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 08-11-2012, 02:22 PM   #1
ecataranciuc
LQ Newbie
 
Registered: Jul 2012
Posts: 12

Rep: Reputation: Disabled
Removing users from 'dhcppc0' host in mysql.user


Hello!
I have this in mysql.user:
mysql> select User, Host, Password from user;
+----------+-----------+------------+
| User | Host | Password |
+----------+-----------+------------+
| root | localhost | *Password |
| root | dhcppc0 | *Password |
| root | 127.0.0.1 | *Password |
| username | localhost | *Password |
+----------+-----------+------------+

But I don't understand what host is the dhcppc0 in the table. What is it its origin/use?
Also, can I safely remove username@localhost, root@dhcppc0 and root@localhost?
Thank you!
 
Old 08-12-2012, 07:41 AM   #2
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Ubuntu 12.04, Antix19.3
Posts: 3,794

Rep: Reputation: 282Reputation: 282Reputation: 282
It's your machine's name. You can revoke the permissions (using revoke) or simply delete the record in the user table.

//Edit
Keep root@localhost and username@localhost. Use root for maintenance (inserting / deleting / updating records is not maintenance) and use other users with finetuned permissions to use the database.

I once hosted a website somewhere and had three levels:
  • a user that could create / delete databases and tables; on my own server this is root that can also provide the grants on the cerated databases / tables
  • a user that could select / insert / update / delete records etc
  • a user that could only select

Last edited by Wim Sturkenboom; 08-12-2012 at 07:53 AM. Reason: Added the edit
 
Old 08-12-2012, 10:21 AM   #3
ecataranciuc
LQ Newbie
 
Registered: Jul 2012
Posts: 12

Original Poster
Rep: Reputation: Disabled
Thank you!
 
  


Reply



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
How do I copy user credentials from a MySQL table into SSH users Zoner Linux - Newbie 3 03-13-2011 08:25 PM
Installing MySQL 5 in Centos4.4 - removing old Mysql files Swakoo Linux - General 4 03-31-2007 07:47 AM
dhcppc0? davidhk Fedora 11 08-24-2005 12:49 AM
mysql drop revoke user from specific host ? RedHat123 Programming 0 04-21-2005 02:54 PM
How do I add a host user password to mysql server? cmisip Linux - Networking 3 12-16-2002 09:57 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 07:26 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
Open Source Consulting | Domain Registration