SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Member
    Join Date
    Jan 2003
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    my user table has these entries

    I have just noticed that my mysql.user table has a couple of entries I know nothing about....

    mysql> select host,user,password from user;
    +-----------+--------+------------------+
    | host | user | password |
    +-----------+--------+------------------+
    | localhost | root | 11be6ci654d6e88c |
    | % | root | |
    | localhost | | |
    | % | | |
    | localhost | danny | 1v35e0a780550b2a |
    | localhost | sid | 4fjcd72d7991ca33 |
    +-----------+--------+------------------+

    I followed Kevins tut to install MySQL and I thought I had done everything correctly, but there are 3 entries without passwords and two without a username. Should I delete these entries ?

    If I should delete them, how do I delete the entries with '%'

    DELETE FROM user WHERE Host='%';

    and

    DELETE FROM user WHERE User='';

    Will that do it, my OS is winXP

    Many thanks..jcd
    Last edited by jcd; Jul 2, 2004 at 15:28.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •