How to create mysql logs for specific queries
Mysql tutorial, How to create mysql logs for specific queries. As a developers need to check the mysql logs. Many times for any request how many mysql queries are running or executed we need to know.
When we do the fresh installation of Mysql we got the root user without any password. Keeping and using the root user for application is not safe.
For creating new user use the following commands.
CREATE USER 'wordpressapi'@'localhost' IDENTIFIED BY 'Test@123456'; GRANT ALL ON *.* TO 'wordpressapi'@'localhost';