SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Aug 2008
    Location
    Shropshire, UK
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Can't set root password

    Hi all,

    Newcomer here, just started reading 3rd edition of Kevins book, but having problems in setting the root password. (Running on Win XP box).

    I have read other threads here, and tried what has been suggested, but am getting nowhere.

    I tried:
    UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
    FLUSH PRIVILEGES;

    but all I got was the error:
    error 1142 (42000): UPDATE command denied to user ''@'localhost for table 'user'

    Can anyone assist please?

  2. #2
    SitePoint Zealot Ken Sharpe's Avatar
    Join Date
    Apr 2008
    Posts
    160
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Are you running as "root"? It looks like you're not.

  3. #3
    SitePoint Evangelist kooshin.com's Avatar
    Join Date
    Dec 2003
    Location
    http://kooshin.com
    Posts
    505
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    have you tried accesing the phpmyadmin directly then changing the password from there?

  4. #4
    SitePoint Enthusiast
    Join Date
    Feb 2007
    Location
    Los Angeles
    Posts
    97
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try mysqladmin -uroot password yourpassword


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
  •