Topic: MySQL Root Password?

[narvik]

Hello.
I used to run a very simple SME 8 server a while back, but it became unneeded. I used the same computer to install a fresh SME Server 9.
With some difficulties, I have been able to successfully install it, but am now having trouble accessing MySQL.

The wiki states:

"MySQL root password
There appears to be no password set for the MySQL root password, but this is not true. If you are logged in to the SME Server shell a special mechanism is in place to log you in with MySQL root privileges without prompting you for the password."

This does not seem to work for me, and I get following error:
ERROR 1045 (20000): access denied for user 'root'@'localhost' (using password: NO)

Obviously there is no password set, which would contradict the wiki.

Any help appreciated.

[janet]

narvik

Did you delete the sme8 install & delete partitions including resetting MBR's BEFORE installing sme9 ?
This tells you how:
http://wiki.contribs.org/Raid#Reusing_Hard_Drives

You mention "with some difficulty", what problems did you have, as these could be related to your current password issue.

The same article you quoted from tells you how to reset the mysql root password.
http://wiki.contribs.org/MySQL

Also this tells you how to reset the root & admin passwords.
http://wiki.contribs.org/SME_Server:Documentation:FAQ:Section01#Reset_the_root_and_admin_password

Normally on a correctly installed SME server, you should NOT need to reset any of those passwords, but maybe you have played with the system too much !

If I were you I would reinstall sme9 again on a clean (erased) drive

[narvik]

Thanks janet, for the fast reply and help.

I did delete sme8 install and partitions, but not MBR, as I can't seem to do that in Windows.

"with some difficulties", was actually nothing to do with SME install directly, but more with its setup afterward, namely navigation within the server console, and finding correct settings to access internet. Nothing wrong though, just my learning curve...

It turns out I was logging in as admin, NOT root: I couldn't find correct documentation as to what this meant EXACTLY:
"Get access to the SME Server shell"

I did this -erroneously- through the server control's OS Shell option (as admin).

Now that I figured out how to log in as root, I now get a different MySQL error, that reads:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I previously forgot to mention that I am using a SSD, which might have something to do with this. I will now try a spinning hard drive, and a new installation and see if that works.


UPDATE:
It appears my MAIN problem was logging in as 'admin' not 'root'.
I checked my old SME8 backup SSD hard drive and 'mysql' worked fine, once I logged in as 'root'.
I checked my earlier SME9 SSD hard drive and 'mysql' works fine, once I log in as 'root'.
I am unsure why 'mysql' returns an error on latest, new install of SME9, but since I have a working copy of SME9, I will not pursue it further.

To anyone as inexperienced as I, this might help:
If the command prompt reads something like this: bash-4.1# you are logged in as admin;
if the command prompt reads something like [root@servername ~]# you are logged in as root.
SME documentation mentioning "Get access to the SME Server shell" means logging in as 'root', this is done immediately after starting the server at the command prompt that reads:
servername login:
Cheers!