Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

Mysql5.6 not able to start up after change datadir

Hi,
Trying to move Mysql data  to new drive  which after changed the path  My.ini file, services won't be able to start up the services and found in the log and error as following

2018-04-09 07:54:47 1412 [Note] IPv6 is available.
2018-04-09 07:54:47 1412 [Note]   - '::' resolves to '::';
2018-04-09 07:54:47 1412 [Note] Server socket created on IP: '::'.
2018-04-09 07:54:47 1412 Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

 I also have given network services full rights in the location below.
What else that I missed here to start up again Mysql with new data directory ?

# Path to the database root
datadir = "F:/ProgramData/MySQL//data"
SOLUTION
Avatar of theGhost_k8
theGhost_k8
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial