mysqldatabasewindowsdatadirectory
Unable to restart mysql after changing the datadir
I am unable to restart the server after changing the default datadir from C:/ProgramData/MySQL/MySQL Server 5.7\Data to D:/Data.
- I changed
datadirtodatadir="D:/Data" - Then I stopped
mysql - Copied the
Datadirectory toD:/ - Attempted to restart the server
- Unable to start
What could be the reason for it?
Error snapshot:
However, it works fine if the original datadir path is restored.
Solution
Assign full permissions to the NETWORK SERVICE for D:/Data
- Where is MySQL's my.ini located on Windows?
- How to download Mysql jdbc jar file on centos
- pymysql.err.OperationalError: 1054. "Unknown column 'X' in 'where clause'
- What is the difference between utf8mb4 and utf8 charsets in MySQL?
- How to make a field NULL using MySQL GUI Tools?
- Renaming foreign-key columns in MySQL
- Fetch dates within the next 5 days from today, from a column of dates
- the MySQL service on local computer started and then stopped
- Using TABLE keyword to SELECT everything from vs SELECT * from table_name
- Importing CSV using MySQL Workbench. Not all records imported
- Mysql Pivot View
- unknown variable 'default-authentication-plugin=mysql_native_password'
- How to select a column with max value of other column, and all corresponding rows of column in another table?
- Trying to update a table using a trigger in mysql
- error column cannot be null, trying to upload file into sql
- Docker - mysqld: Table 'mysql.plugin' doesn't exist
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 54
- How can I check (My)SQL statements for syntactical correctness
- Automate mysql_secure_installation with echo command via a shell script
- need some explanation about MySQL where ... in ... subquery
- Show values from a MySQL database table inside a HTML table on a webpage
- UTF-8 all the way through
- How to load multiline csv feature into MySQL
- What are Visible INDEX and Invisible INDEX in MySQL? Which is better?
- MySQL Error Even Purging and Reinstalling does not fix it
- Problems using MySQL with AWS Lambda in Python
- How to know relations between tables
- How to increase MySQL connections(max_connections)?
- Mysqldump without triggers : ERROR 1359 (HY000) at line 1420: Trigger already exists
- PHP, mysql_query just NOT working