motioneye
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//dat a"
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//dat
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.