Koozali.org: home of the SME Server

Can't log in to mysql

Offline adrem

  • 1
  • +0/-0
    • personal
Can't log in to mysql
« on: July 04, 2009, 05:23:14 PM »
Hello,
I can't log in to mysql on sme server 7.4.
I get respond
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I have read that if logged in to the SME Server shell a special mechanism is in place to log  in with MySQL root privileges without prompting  for the password. What I did wrong?

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Can't log in to mysql
« Reply #1 on: July 04, 2009, 06:01:53 PM »
you posted here instead of raising a bug

go to bugzilla please

Stefano

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Can't log in to mysql
« Reply #2 on: July 05, 2009, 08:47:40 AM »
What I did wrong?
You probably did modify the special password, which breaks the auo-login magic. For this urpose we have the search function and the FAQ:

http://wiki.contribs.org/SME_Server:Documentation:FAQ#MySQL_root_password

I think you need to reset your root password for it all to make it work again. If that does not work then you need to raise a bug.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)