mysqld: Can't change dir to data. Server doesn't start

Tags:

mysql

I installed a MySQL server with installer and it started. After reboot I tried to start it again and get the error:

D:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld -u root -p mysqld: Can't change dir to 'D:\Program Files\MySQL\MySQL Server 5.7\data\'     (Errcode: 2 - No such file or directory) 2015-11-17T08:30:18.822962Z 0 [Warning] TIMESTAMP with implicit DEFAULT     value is deprecated. Please use --explicit_defaults_for_timestamp server option     (see documentation for more details). 2015-11-17T08:30:18.822962Z 0 [Warning] Insecure configuration for --secure-    file    -priv: Current value does not restrict location of generated files.     Consider setting it to a valid, non-empty path. 2015-11-17T08:30:18.822962Z 0 [Note] mysqld (mysqld 5.7.9) starting as     process 1108 ... 2015-11-17T08:30:18.838586Z 0 [Warning] Can't create test file D:\Program     Files\MySQL\MySQL Server 5.7\data\DESKTOP-RNBR3E8.lower-test 2015-11-17T08:30:18.838586Z 0 [Warning] Can't create test file D:\Program     Files\MySQL\MySQL Server 5.7\data\DESKTOP-RNBR3E8.lower-test 2015-11-17T08:30:18.838586Z 0 [ERROR] failed to set datadir to D:\Program     Files\MySQL\MySQL Server 5.7\data\ 2015-11-17T08:30:18.838586Z 0 [ERROR] Aborting   2015-11-17T08:30:18.838586Z 0 [Note] Binlog end 2015-11-17T08:30:18.838586Z 0 [Note] mysqld: Shutdown complete

I tried to reinstall MySQL.
UPDATE:
When I run mysqld -u root -p as administrator, nothing happens.

427

asked Nov 17 '15 08:11

2 Answers

I have met same problem. In my case I had no ..\data dir in my C:\mysql\ so I just executed mysqld --initialize command from c:\mysql\bin\ directory and I got the data directory in c:\mysql\data. Afterwards I could use mysqld.exe --console command to test the server startup.

192

answered Oct 24 '22 20:10

keerthiprasath

Since you used the Windows installer, everything is set up for you to run MySQL 5.7 as a Windows service, which is a great option in most cases.

Instead of running mysqld.exe from the command line,

Win + R
Run services.msc
Right-click on MySQL57
Start the service.

answered Oct 24 '22 20:10

AaronDanielson

Related questions
                            
                                MySQL - UPDATE query with LIMIT
                            
                                Strip last two characters of a column in MySQL
                            
                                CAST DECIMAL to INT
                            
                                Check overlap of date ranges in MySQL
                            
                                ERROR 1148: The used command is not allowed with this MySQL version
                            
                                How can I get rid of these comments in a MySQL dump?
                            
                                Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on OSX
                            
                                SQL Query to get column values that correspond with MAX value of another column?
                            
                                SQL Server 2005 implementation of MySQL REPLACE INTO?
                            
                                Error importing SQL dump into MySQL: Unknown database / Can't create database
                            
                                Get total number of rows when using LIMIT? [duplicate]
                            
                                Connect to Docker MySQL container from localhost?
                            
                                MySQL: preferred column type for (product) prices?
                            
                                Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'
                            
                                How to make MySQL table primary key auto increment with some prefix
                            
                                mysql order by, null first, and DESC after
                            
                                Example of how to use bind_result vs get_result
                            
                                MySQL SELECT DISTINCT multiple columns
                            
                                How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
                            
                                Mysqldump only tables with certain prefix / Mysqldump wildcards?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With