#1
  1. No Profile Picture
    anna
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi, all

    when I run mysql
    got the error message:
    ERROR 1045 Access denied for user "root@localhost" Using password NO"


    when I run mysqladmin
    I got the error message:
    mysqladmin connect to server at 'localhosts' faild
    ERROR Access denied for user "root@localhost" Using password NO"


    what's wrong? please help, thank a lot

  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Location
    Netherlands
    Posts
    77
    Rep Power
    15
    Did you set a password for root? If you did, you should provide it when logging in to MySQL: mysql -u root -p password

    Peter
  4. #3
  5. No Profile Picture
    freebsd
    Guest
    Devshed Newbie (0 - 499 posts)
    It's okay if you haven't specified a password for root in the beginning right after mysql is installed.
    But you need to run this:
    /usr/local/mysql/bin/mysql_install_db, then using root should have all privileges set to 'Y'.
    You _SHOULD_ set a root password later on once you are comfortable with everything.

Similar Threads

  1. WinXPHome Access Denied
    By martianplanet in forum Windows Help
    Replies: 3
    Last Post: December 29th, 2003, 09:47 PM
  2. access denied
    By spiderweb in forum MySQL Help
    Replies: 0
    Last Post: December 27th, 2003, 07:17 AM
  3. Need help! 1044 Access denied...
    By thoughtfulthor in forum Database Management
    Replies: 0
    Last Post: December 13th, 2003, 02:19 PM
  4. Replies: 3
    Last Post: December 3rd, 2003, 05:08 AM
  5. mysql user table & Access denied errors
    By mstembri in forum MySQL Help
    Replies: 1
    Last Post: May 17th, 2001, 04:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo