MySQL service fails to start with the error “InnoDB: Failed to find tablespace for table `X` in the cache” – 2021-02-15 22:00:01 8 [ERROR] InnoDB: Failed to find tablespace for table `X`.`Y` in the cache. Attempting to load the tablespace
Archives
Create MySQL database & user from cli
The following script creates a MySQL database & a user who will be assigned as a privileged user to the db. We used the following credentials for this example – Database name: mysite_db Database user: mysite_user Database password: mypassword ##
Automated MySQL Installation
Here is a nice “Copy & Paste” script that you can use for installing MySQL. This script skips the “mysql_secure_installation” part, in which you need to answer questions, and simply inserts all the needed information directly into the database. This