Strange looking mysql.user table

From: Bruce A. Julseth (bruceaj_at_attglobal.net)
Date: 06/30/04 

Date: Tue, 29 Jun 2004 22:22:14 -0400

My MySQL.user table (user, host, password) looks like the following:

+---------+-----------+---------------------+
| user | host | password |
+---------+-----------+---------------------+
| root | localhost | |
| root | % | |
| | localhost | 3823a5ee1f831626 |
| | % | |
| jim | % | 426d920b373a5e5b |
+---------+-----------+---------------------+

This looks strange to me.
1) two entries for root
2) two blank entries.
3) is jim's host correct?

This is on a private, standalone system for MySQL/PHP learning purposes.

If this is strange, should I remove any of these entries using SQL "Delete
From"

Thank you...

Bruce

Relevant Pages

  • Re: Strange looking mysql.user table
    ... > This looks strange to me. ... > 2) two blank entries. ... > 3) is jim's host correct? ... the "%"-sign says to allow a user named root to access the database from ...
    (comp.lang.php)
  • [2.6 patch] SCSI qlogicisp.c: some cleanups
    ... every queue slot can hold a SCSI ... * command with up to 4 scatter/gather entries. ... +static int isp1020_detect ... -int isp1020_release(struct Scsi_Host *host) ...
    (Linux-Kernel)
  • Re: Attacks on ssh port
    ... > directly in the garbage and kill the host where these are coming from ... > with a records in my firewall. ... I do think you're being overly concerned about your log entries since ... from the logfiles or enable some ports NIDs, or 3rd party NIDS to do ...
    (FreeBSD-Security)
  • need help using DNS instead of host files
    ... We have a few 3rd party integrations that want entries written to host ... master and all the computers use it. ... accessible to us because we have a b2b VPN. ...
    (microsoft.public.windows.server.dns)
  • Re: [PATCH 5/6] firewire: SBP-2 highlevel driver
    ... block layer doesn't build sg entries too big for you. ... I have now changed the code to just allocate the host up front and use the hostdata mechanism for the sbp2_device struct, which also addresses the host life cycle comments below. ... scsi_scan_target instead and let the core scsi code handle the ...
    (Linux-Kernel)