Results 1 to 3 of 3

Thread: How do I fix this error?

  1. #1
    One skin, two skin......
    Join Date
    Jul 2003
    Location
    Durham
    Posts
    1,705
    Thanks
    0
    Thanked
    1 time in 1 post

    How do I fix this error?

    Quote Originally Posted by mysql server
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'
    Using the command:
    mysqladmin version

    from a command prompt gives me the above error. How do I sort it out?

  2. #2
    Large Member
    Join Date
    Apr 2004
    Posts
    3,720
    Thanks
    47
    Thanked
    99 times in 64 posts
    Are you sure the data link dosn't require a username and password?
    To err is human. To really foul things up ... you need a computer.

  3. #3
    Agent of the System ikonia's Avatar
    Join Date
    May 2004
    Location
    South West UK (Bath)
    Posts
    3,736
    Thanks
    39
    Thanked
    75 times in 56 posts
    1.) put detail in the post of the subject not stuff like "help" or "error" etc etc
    2.) read the warning message after you've done a "mysql_install_db" - whats mysql_install_db I hear you ask, perhaps read a few pages of the documentation before jumping in
    3.) specify what the host OS and mysql version is

    Now the answer

    what you need to do is verfiy mysql is running, which I assume it is

    my fist questiion is have you set the root users password with mysqladmin ? if the answer to that question is yes then

    mysql -h $hostname -u root -p

    replace hostname with either local host, or a network alias for your host

    you'll then be prompter for a password, enter the root users password input that

    then.....now that your in sql prompt

    update user
    set host ='%' where user !='root'
    ;
    commit
    ;

    flush privileges
    ;



    this will allow any user other than root to connect from any host


    or you can - as you suggested use mysqladmin -p password 'newpassword' replace 'newpassword' with password
    It is Inevitable.....


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hexus.net error messages
    By daveham in forum Help! Quick Relief From Tech Headaches
    Replies: 0
    Last Post: 08-12-2004, 11:53 AM
  2. bsod error
    By MuTTy_Hc in forum Software
    Replies: 3
    Last Post: 26-09-2004, 08:50 PM
  3. Forum Speed
    By DR in forum General Discussion
    Replies: 10
    Last Post: 04-01-2004, 11:58 AM
  4. cyclic redundancy error!
    By Ethos in forum PC Hardware and Components
    Replies: 4
    Last Post: 07-12-2003, 01:52 AM

Posting Permissions

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