​If you would like to creating new user accounts in your MySQL server with password using the command below,

In Old version of MySQL doesn't have any built in function to count number of occurrences of word in a string, so so we have to bit of tweak in your query to make this done in MySQL.

REPLACE function in MySQL is used to replace specified string or char. Similarly we can replace a NEWLINE char '\n' in a string with any of our choice.

The MySQL PHP extension can helps to access the MySQL database on your PHP application, by default this extension is not installed in your instance, this post walk you through how to install extension on your Ubuntu and CentOS Operating Systems.

Some MySQL queries are executing more time than the normal and it might be efficiency issues affecting your server, if you want to identifying those queries that take a long time to execute and would helps optimisation the queries.

When you executes some queries if you may get an error:ER_ACCESS_DENIED_ERROR, errno:1045, sqlMessage:Access denied for user,

Most probably its happens forgetting password is one thing, in case if you forgot the MySQL root password we can reset it using the steps as below,