How to reinitialise /var/lib/mysql files?
You should be able to just run mysql_install_db
from the command line
mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they do not exist. It also initializes the system tablespace and related data structures needed to manage InnoDB tables. As of MySQL 5.6.8, mysql_install_db is a Perl script and can be used on any system with Perl installed. Before 5.6.8, it is a shell script and is available only on Unix platforms.
Please read the MySQL Documentation in full for mysql_install_db
, then ...
GIVE IT A TRY !!!
If it does not work on the first try, do this
mkdir /var/lib/mysql
mkdir /var/lib/mysql/mysql
chown -R mysql:mysql /var/lib/mysql
then run mysql_install_db
again
For MySQL 5.7 > just:
# Move or remove the original dir
mv /var/lib/mysql /tmp/mysql
# Create a new dir
mkdir /var/lib/mysql
# Change owner to mysql (user and group)
chown -R mysql:mysql /var/lib/mysql
# Create MySQL initial data
mysqld --initialize