V
V
Vladimir Novitsky2015-10-31 21:50:38
MySQL
Vladimir Novitsky, 2015-10-31 21:50:38

Where did the data folder go in mysql 5.7.9?

Hello.
Where did the data folder go in MySQL 5.7.9?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
B
big_hasan, 2015-11-16
@big_hasan

I found the info on the subject on the English-language forum. Here is the link and below is the text of the post:

I ended up doing the following...
1) Stop MySQL Service
2) Initialize default mysql database ("data" folder) using command line
mysqld.exe --initialize --user=mysql
3) Run (start) MySQL with passwords disabled
mysqld.exe -u mysql --skip-grant-tables
4) Manually edit `mysql`.`user` table passwords

After executing command number 2, the data folder was indeed created.

R
Ruslan Fedoseev, 2015-10-31
@martin74ua

dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-9.html
For RPM-based packages, the permissions used to create the data directory (/var/lib/mysql) have been changed from 755 to 751. This tightens the data directory permissions while still permitting world access to the mysql.sock file in that directory. (Bug #21066592)
Judging by this, it hasn't gone anywhere. Sitting in place.
And if you look in my.cnf?

V
Vladimir Novitsky, 2015-11-02
@Novitsky

Solved a problem.
I downloaded MySQL 5.7.7 - this is the last version where the data folder was present - and copied it to the latest distribution. Everything works without problems.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question