MYSQL8.0 The default is to install in C Off the shelf (C:\ProgramData\MySQL\MySQL Server
8.0) And the installation path cannot be changed during installation , This is where the database is data Data files need us to change the storage path , Next, I will tell you how to operate :

first : turn off MYSQL service
win+R

find MySQL80 service

second : Enter into C:\ProgramData\MySQL\MySQL Server 8.0 Under the path , find my.ini file open , find

Ctrl+F lookup

datadir=C:/ProgramData/MySQL/MySQL Server 8.0\Data Here it is MYSQL Database path

third : New under other disks mySQLData folder , Just leave out the default comment on the line above

fourth : hold C:/ProgramData/MySQL/MySQL Server 8.0\Data Copy all files under mySQLData Under the folder

fifth : restart MYSQL service

When I restart the service again, I have a problem

Right click ” My computer ” find “ Administration ”

click “ tool ” find “ computer management ” click , find ” Local users and groups “
be careful window Home version There are no local users or groups
Want to set Self installation Professional or higher

choice “ group ”–> double-click Administrators–> single click “ add to ”–> single click “ senior ”–> single click “ Find it now ”–> Select from the list below Network
Service user –> Two clicks “ determine ”–> join .

okay , And then restart it mysql The service will be fine ,MYSQL The database storage path will be modified , Create a new database in , It will be saved to our modified path

Technology
©2019-2020 Toolsou All rights reserved,
Huawei 2021 session Hardware Engineer Logical post (FPGA) Super detailed surface !!!Vue-element-admin upgrade ui edition virtual machine VMware Download and install the most detailed tutorial !C++ Move constructor and copy constructor sound of dripping water java Backstage interview pygame Realize full screen mode and adjustable window size mysql Database setting character set configuration modification my.ini file (windows)30 What's the experience of being a junior programmer at the age of 20 C++ Multithreading programming ( Summary of common functions and parameters )python_ cherry tree