Hi, I just installed MySQL from SLES repos, but during the installation MySQL didn’t asked me for root password to set.
The problem is that I cannot change root password.
I tried to launch the command mysql_secure_installation, but it asks me root password.
On the Internet I found a lot of people that suggest to launch mysqld_safe, but unfortunately I don’t find that command on my system.
And yes, I tried to use this command mysqladmin -u root passwrd , but it fails because I don’t provide him the actual root password.
The version of SUSE is SUSE Linux Enterprise Server 12 SP1, and the version of MySQL is 5.7.12.
On 18/04/16 11:44, mlazzarotto91 wrote:
[color=blue]
Hi, I just installed MySQL from SLES repos, but during the installation
MySQL didn’t asked me for root password to set.
The problem is that I cannot change root password.
I tried to launch the command mysql_secure_installation, but it asks me
root password.
On the Internet I found a lot of people that suggest to launch
mysqld_safe, but unfortunately I don’t find that command on my system.
And yes, I tried to use this command mysqladmin -u root passwrd , but it fails because I don’t provide him the actual root
password.
The version of SUSE is SUSE Linux Enterprise Server 12 SP1, and the
version of MySQL is 5.7.12.[/color]
With the release of SLES12 (and therefore also applies for SLES12 SP1)
SUSE replaced MySQL with MariaDB[1] so MySQL isn’t available to install
from SLES repos. Please can you therefore let us know where exactly you
installed MySQL from?
HTH.
Simon
SUSE Knowledge Partner
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below. Thanks.
[QUOTE=mlazzarotto91;32227]Hi, I just installed MySQL from SLES repos, but during the installation MySQL didn’t asked me for root password to set.
The problem is that I cannot change root password.
I tried to launch the command mysql_secure_installation, but it asks me root password.
On the Internet I found a lot of people that suggest to launch mysqld_safe, but unfortunately I don’t find that command on my system.
And yes, I tried to use this command mysqladmin -u root passwrd , but it fails because I don’t provide him the actual root password.
The version of SUSE is SUSE Linux Enterprise Server 12 SP1, and the version of MySQL is 5.7.12.[/QUOTE]
Ok, so I found that MySQL during the installation generated a temporary password in /var/log.
But now, when I try to connect with the commadn mysql -u root -p, it returns the following error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
but the file mysql.sock doesn’t exist.
[QUOTE=mlazzarotto91;32229]Ok, so I found that MySQL during the installation generated a temporary password in /var/log.
But now, when I try to connect with the commadn mysql -u root -p, it returns the following error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
but the file mysql.sock doesn’t exist.[/QUOTE]
Is mysql running?
Thomas
[QUOTE=smflood;32228]On 18/04/16 11:44, mlazzarotto91 wrote:
[color=blue]
Hi, I just installed MySQL from SLES repos, but during the installation
MySQL didn’t asked me for root password to set.
The problem is that I cannot change root password.
I tried to launch the command mysql_secure_installation, but it asks me
root password.
On the Internet I found a lot of people that suggest to launch
mysqld_safe, but unfortunately I don’t find that command on my system.
And yes, I tried to use this command mysqladmin -u root passwrd , but it fails because I don’t provide him the actual root
password.
The version of SUSE is SUSE Linux Enterprise Server 12 SP1, and the
version of MySQL is 5.7.12.[/color]
With the release of SLES12 (and therefore also applies for SLES12 SP1)
SUSE replaced MySQL with MariaDB[1] so MySQL isn’t available to install
from SLES repos. Please can you therefore let us know where exactly you
installed MySQL from?
HTH.
Simon
SUSE Knowledge Partner
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below. Thanks.
------------------------------------------------------------------------[/QUOTE]
I got MySQL repositories from here
[QUOTE=thsundel;32232]Is mysql running?
Thomas[/QUOTE]
I’ve just tried again, the service was “inactive (dead)”, after a restart of the service now I can login.