Working with Magento2.4.7 ,MySQL server gets shuts down automatically but after adding skip-grant-tables server get started but when I run the command
php bin/magento setup: upgrade
to upgrade Magento2 custom module then it shows
Database user does not have enough privileges. Please make sure SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER privileges are granted to database ‘magento’.
and after removing skip-grant-tables
server does not start.
I tried creating new data folder for MySQL but that affects my database any solution which do not affect the old database and MySQL server can work properly
Sandeep Jangra is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1