MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap

English Applications
#1

Sorry for English…:frowning:

Having to upgrade my pc from the current OpenSuse 13.1 to 42.2 Leap should also install a LAMP server with MySql,

To do this, I would follow this howto guide:
https://www.howtoforge.com/installing-apache-with-php-and-mysql-support-on-opensuse-13.1-lamp

and here is the problem and present 'about a month I’m trying to install MySQL 5.7 first using Oracle / Sun repository duly downloaded on the official website, then in the meantime have appeared repositories software.opensuse.org also on site at this link with 1 click install
https://software.opensuse.org/ymp/server:database/openSUSE_Leap_42.2/mysql-community-server.ymp?base=openSUSE%3ALeap%3A42.2&query=mysql-community-server

The problem ‘that there’ towards to run MySql 'cause every time I try to start the service returns to me:


# systemctl start mysql.service
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

typing course journalctl as indicated


# journalctl -xe
dic 31 16:22:25 linux-2frc systemd[1]: Failed to start MySQL server.
dic 31 16:22:25 linux-2frc mysql-systemd-helper[9324]: MySQL didn't start, can't continue
dic 31 16:22:25 linux-2frc systemd[1]: Failed to start MySQL server.
-- Subject: L'unità mysql.service è fallita
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unità mysql.service è fallita.
-- 
-- Il risultato è failed.
dic 31 16:22:25 linux-2frc systemd[1]: mysql.service: Unit entered failed state.
dic 31 16:22:25 linux-2frc systemd[1]: mysql.service: Failed with result 'exit-code'.
dic 31 16:22:25 linux-2frc systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
dic 31 16:22:25 linux-2frc systemd[1]: Stopped MySQL server.
-- Subject: L'unità mysql.service termina la fase di spegnimento
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unità mysql.service ha terminato la fase di spegnimento.
dic 31 16:22:25 linux-2frc systemd[1]: Starting MySQL server...
-- Subject: L'unità mysql.service inizia la fase di avvio
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unità mysql.service ha iniziato la fase di avvio.
dic 31 16:22:25 linux-2frc mysql-systemd-helper[9582]: my_print_defaults: [ERROR] unknown option '--mysqld'
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: my_print_defaults: [ERROR] unknown option '--mysqld'
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Checking MySQL configuration for obsolete options...
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Trying to run upgrade of MySQL databases...
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Stale files from previous upgrade detected, cleaned them
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Running protected MySQL...
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Waiting for MySQL to start
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.720197Z 0 [Warning] TIMESTAMP with i
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.721016Z 0 [Warning] 'NO_AUTO_CREATE_
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.721789Z 0 [Warning] Failed to normal
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.721808Z 0 [ERROR] Aborting
dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.721841Z 0 [Note] Binlog end

then trying to launch the program secure_installation finding service starts

# mysql_secure_installation 

Securing the MySQL server deployment.

Error: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

looking I basically found the following directives in the network:

  1. stop MySql

  2. to generate a pwd (in this case creates a “/root/.mysql_secret” files that have do)

  3. to recharge the service with the clause mysqld_safe --skip-grant-tables & (but that ‘I have not been able to do so because’ the command is fine for debian or derivatives but not for OpenSuse)

  4. Assign is blessed PWD to MySQL even if provisionally, and subsequently

  5. mysql_secure_installation launch and continue the LAMP server installation

Given, however, 'I have many gaps MySql computer is part of these deficiencies, and if there was anyone able to help me I would be grateful, because I do not understand why you create this error in the installation of MySQL 5.7, inter alia, the same problem and 'present with LinuxMint, so it must be a setup problem in MySQL …

Thank you…

#2

Why not install from the normal repos??

#3

Because use MySql 5.6, and I need of MySql 5.7

#4

Add the database repo

****http://download.opensuse.org/repositories/server:/database/openSUSE_Leap_42.2/

#5

As of today,
MySQL 5.7 is in the special server repository.

Add the repository by running the following in an elevated console (eg root)

zypper ar -f http://download.opensuse.org/repositories/server:/database/openSUSE_Leap_42.2/ 42.2_Database_Servers

Then, refresh

zypper --gpg-auto-import-keys ref

And then install mysql server. You should automatically install the latest from the new repository.

As always, don’t forget to run the following script immediately after install to configure security

mysql_secure_installation

TSU

#6

This repository is the one that I posted the link
https://software.opensuse.org/ymp/server:database/openSUSE_Leap_42.2/mysql-community-server.ymp?base=openSUSE%3ALeap%3A42.2&query=mysql-community-server
and it does not work !!!

However I have tried to uninstall and reinstall mysql following your procedures @ TSU2 but we are always at the same point
when I start the service:

systemctl start mysql.service 
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

no progress for now…:\

#7

I found the solution, thanks to www.linux-magazine.it friends
http://www.linux-magazine.it/forum/index.php/topic,18802.msg65528/topicseen.html#msg65528