[SMS]

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

I can't login to mysql. Have not made any changes, new install.

Not from webmin>mysql or command line. Tried mysql -u root -p then toor for password. Tried to create new password but ofcourse it won't let me.

thanks

gerasimos_h · Posted: Wed Oct 03, 2007 3:39 pm Post subject:

That's because I have not put a mysql password.
Type mysql -u root mysql and set password with the command

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

I'm sorry but that does not work. I type 'mysql -u root mysql' returns Access denied for user root@localhost.

your thoughts?

gerasimos_h · Posted: Wed Oct 03, 2007 4:10 pm Post subject:

type mysql -u root -p and press enter ( blank password)...
Try to check Webmin if can see mysql server and if it requires password.
If you messed up mysql's password try this simply script to reset it.

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

I have not set a password. This is a new install and nothing has been done to it. When I tried to setup a password from command it gave me access denied.

I have a physical theray appointment now so I don't have the time to try the script. But will when I get back.

Its possible the install was corrupted but did not see any errors. I could try reinstalling native sms again.

thanks

gerasimos_h · Posted: Wed Oct 03, 2007 5:37 pm Post subject:

the "-p" argument is for connecting with password and not for creating a password and since mysql user root don't have a password may messed things up.
Maybe a simple mysql restart it's enough to fix the problem, or if you turn your PC on when you come back, try login without password.
If it requires password, try the script...
I don't believe that it's a corrupted installation, but you never know for sure.

gerasimos_h

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

turned out it was a bad install. Re-installed sms and now it works.

thanks