Mysql server in localhost does not work

Navigation
4

I tried to install a mysql server on my local machine but I can not get it to work.

I downloaded the zip from here: link

Then I followed these steps: link

But I get the following error:

  

ERROR 2003 (HY000): Can not connect to MySQL server on 'localhost' (10061)

I have looked for the error but the solutions that they give in those places to me have not helped 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.

Content of the ini 

[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/"
    
asked by Pavlo B. 27.07.2018 в 15:53
source

2 answers

1

Hello Pavlo I was doing tests on my computer (also with windows 10) and I think the problem is in the routes, in my case I have installed on the root of disk c, the routes are for example basedir = "c:/mysql-5.7.17" if change and I only leave the / in all configurations just as you do not start the server.

Usually I use the installer because it creates the services and such, for my part I recommend you try it.

    
answered by 31.07.2018 / 00:23
source
0

In the end the problem was that in the php.ini file of the php, not the symfony project, the pdo_mysql was not activated and that's why symfony did not detect the driver.

    
answered by 31.07.2018 в 20:19
Create a PDF and send it by email Laravel, create record if it does not exist