[opensuse] best practice with msysql and root password
Akonadi when starting up recalls: please remember to set a root password for the Mariadb root user! So what is best practice? Set it or not. That referred to usage local with kontact / kmail /akonadi. And if one should set it: why did I never hear of it or read of it. Just saw that bit on the terminal output of "akonadictl start". Thanks. _________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postf�cher sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 03/20/2019 04:53 PM, stakanov wrote:
Akonadi when starting up recalls: please remember to set a root password for the Mariadb root user!
So what is best practice? Set it or not. That referred to usage local with kontact / kmail /akonadi. And if one should set it: why did I never hear of it or read of it.
As root: # mysql_secure_installation -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
In data giovedì 21 marzo 2019 00:43:39 CET, David C. Rankin ha scritto:
On 03/20/2019 04:53 PM, stakanov wrote:
Akonadi when starting up recalls: please remember to set a root password for the Mariadb root user!
So what is best practice? Set it or not. That referred to usage local with kontact / kmail /akonadi. And if one should set it: why did I never hear of it or read of it.
As root:
# mysql_secure_installation This is weird. I did not set one but:
Enter current password for root (enter for none): ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/ mysql/mysql.sock' (2) with empty root password. With the root password of the machine the same. So, does this mean opensuse does set a random root password to mysql? _________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postfächer sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
stakanov wrote:
In data giovedì 21 marzo 2019 00:43:39 CET, David C. Rankin ha scritto:
On 03/20/2019 04:53 PM, stakanov wrote:
Akonadi when starting up recalls: please remember to set a root password for the Mariadb root user!
So what is best practice? Set it or not. That referred to usage local with kontact / kmail /akonadi. And if one should set it: why did I never hear of it or read of it.
As root:
# mysql_secure_installation This is weird. I did not set one but:
Enter current password for root (enter for none): ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/ mysql/mysql.sock' (2)
with empty root password. With the root password of the machine the same. So, does this mean opensuse does set a random root password to mysql?
No, it should be just empty. -- Per Jessen, Zürich (3.4°C) http://www.dns24.ch/ - your free DNS host, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
In data giovedì 21 marzo 2019 08:37:03 CET, Per Jessen ha scritto:
mysql_secure_installation you need to do the following to make it work: su - # service mysql start # mysql_secure_installation Follow the procedure done
_________________________________________________________________ ________________________________________________________ Ihre E-Mail-Postfächer sicher & zentral an einem Ort. Jetzt wechseln und alte E-Mail-Adresse mitnehmen! https://www.eclipso.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
stakanov wrote:
Akonadi when starting up recalls: please remember to set a root password for the Mariadb root user!
So what is best practice? Set it or not.
In general, always set a root password. In the specific case of akonadi+mysql on a personal PC or laptop - maybe it's not overly important.
That referred to usage local with kontact / kmail /akonadi. And if one should set it: why did I never hear of it or read of it.
Previously, when mysql was installed, it would alert you on the first startup. It was part of the script. I think you still get a suggestion to set the root password, I just can't remember where. -- Per Jessen, Zürich (1.3°C) http://www.dns24.ch/ - free dynamic DNS, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (3)
-
David C. Rankin -
Per Jessen -
stakanov