spam users which was registered. I used following Mysql commands for removing he wordpress users. query for Delete users by date wordpress Mysql
We mostly use the get_permalink(), get_the_title() methods in our wordpress theme. Do not pass the post ID as parameter. if you’re doing a get_permalink or get_title() call with Post id,…Read more →
One day I faced issue with mysql.sock file. I solved the issue with following commands. [root@localhost ~]# mysqladmin -u root shutdown mysqladmin: connect to server at 'localhost' failed error: 'Can't…Read more →
Mysql tutorial for, mysql create user and grant all privileges on database. When we do fresh installation of Mysql we got the root user without any password
[root@localhost ~]# mysqladmin -u root shutdown mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and…Read more →
Some time back I accidentally deleted mysql root user. Then when checked mysql then mysql is not accessible to me from root user. I have trick to restore db
PHP tutorial, How optimize all tables using php script. That will improve the your website performance. Optimize command is helpful to manage database files in right manner.
I faced the sleep query issue sometimes. you need to me very careful how you are setting up the apache and mysql. we solved mysql sleep processes issue solved