Linux Mint 18.3 and MySQL 8.0

[cosmin1981]

hello everyone!

I have Linux Mint 18.3 x64, updated.
First, i removed any and all traces of the old 5.4.7 mysql server - i searched manually for all mysql files, hidden configs etc.

I need to install and run MySQL 8.0 and Workbench for it.
The Workbench part is easy to install and run with no problems.

But the server part is giving me nightmares !!!!

OFFICIAL LINK MYSQL 8.0: https://dev.mysql.com/doc/mysql-apt-rep ... components

If you open this link, the installation tutorial starts at the words "Steps for a Fresh Installation of MySQL"

Everything worked well until this part:
2. Installing MySQL with APT

Here, when i run the command the tutorial says i should run:
sudo apt-get install mysql-server

i see the mysql server refuses to run!
As you see, there is a part with blue background, which says "IMPORTANT" and speaks of a password etc.

Except, this doesnt happen to me ... to me, mysql server refuses to run!

So obv, i cannot finish the setup!

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

If i run the command "systemctl status mysql.service", i get this:

mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Wed 2018-06-20 00:48:46 EEST; 1min 4s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 5274 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 5234 ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 5274 (code=exited, status=1/FAILURE)
Status: "SERVER_BOOTING"
Error: 13 (Permission denied)

Jun 20 00:48:45 sith systemd[1]: Starting MySQL Community Server...
Jun 20 00:48:46 sith mysqld[5274]: 2018-06-19T21:48:46.228962Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
Jun 20 00:48:46 sith mysqld[5274]: 2018-06-19T21:48:46.229049Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 5274
Jun 20 00:48:46 sith mysqld[5274]: 2018-06-19T21:48:46.230658Z 0 [ERROR] [MY-010187] [Server] Could not open /var/log/mysql/error.log file for error logging: Permission denied.
Jun 20 00:48:46 sith mysqld[5274]: 2018-06-19T21:48:46.230701Z 0 [ERROR] [MY-010119] [Server] Aborting
Jun 20 00:48:46 sith mysqld[5274]: 2018-06-19T21:48:46.230844Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
Jun 20 00:48:46 sith systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 00:48:46 sith systemd[1]: Failed to start MySQL Community Server.
Jun 20 00:48:46 sith systemd[1]: mysql.service: Unit entered failed state.
Jun 20 00:48:46 sith systemd[1]: mysql.service: Failed with result 'exit-code'.


------------------------------------------------------------------------------------------------------------------------

All those folders and files, /usr/sbin/mysqld, /usr/share/mysql etc, have been give chmod 777 (yea yea i know its unsecure...well, no one uses the laptop but me!).

Yet, the error persists!
I cannot go back to 5.4.7, due to the massive differences!

Please help me install mysql server 8.0 properly!

Thanks