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


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

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

I have this in mysql.user:
mysql> select User, Host, Password from user;
| User | Host | Password |
| root | localhost | *Password |
| root | dhcppc0 | *Password |
| root | | *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.

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
LQ Newbie
Registered: Jul 2012
Posts: 12

Original Poster
Rep: Reputation: Disabled
Thank you!


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
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 > Forums > Linux Forums > Linux - Server

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

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