I have tried to install a mysql server on my local machine but I can't get it to work.
I have downloaded the zip from here: https://dev.mysql.com/downloads/mysql/
Then I followed these steps: http://webdevzoom.com/install-mysql-zip-file-on-windows/
But it gives me the following error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
I have searched for the error but the solutions given on those sites have not worked for me.
When executing mysqld --console
I get the following:
2018-07-27T13:54:56.349166Z 0 [System] [MY-010116] [Server] c:\mysql-5.7.17\bin\mysqld.exe (mysqld 8.0.11) starting as process 5764
2018-07-27T13:54:56.373933Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2018-07-27T13:54:56.376442Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-07-27T13:54:56.379069Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-07-27T13:54:56.382633Z 0 [System] [MY-010910] [Server] c:\mysql-5.7.17\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL .
start content
[mysqld]
basedir = "/mysql-5.7.17"
datadir = "/mysql-5.7.17/data"
tmpdir = "/mysql-5.7.17/tmp"
port = 3306
server_id = 1
log_error = "mysql_error.log"
pid_file = "mysql.pid"
socket = "/mysql-5.7.17/mysql.sock"
# Optional - Default Configuration
max_allowed_packet = 8M
key_buffer_size=16M
# Where do all the plugins live
plugin_dir = "/mysql-5.7.17/lib/plugin/"