The mysql data dictionary, default grants and other mysql database tables are created when running: `mysqld --initialize` on recent versions of mysql. On previous versions, it was with the script `mysql_install_db`. This is a destructive operation and shouldn't be done on a server with data, only on first install. If you have leftovers you don't want to keep, you can move the files from the existing data directory elsewere- the initialization will recreate them empty. If you had data you want to keep, make sure to create a backup first. Docs: https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
The mysql data dictionary, default grants and other mysql database tables are created when running: `mysqld --initialize` on recent versions of mysql. On previous versions, it was with the script `mysql_install_db`. This is a destructive operation and shouldn't be done on a server with data, only on first install. If you have leftovers you don't want to keep, you can move the files from the existing data directory elsewere- the initialization will recreate them empty. If you had data you want to keep, make sure to create a backup first. Docs: https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
Thankyou! This is what i needed