Some days before I enabled the my site registration as subscribers. In last seven days there are four thousand subscribers has been registered on my site. After reviewing the users and there server request logs I got to know about that was spam users which was registered to my site. Wordpress is always easy target for spammers and hackers. I tried to use some code for remove the wordpress users but then later I used following Mysql commands for removing he wordpress users.
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 →
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…Read more →
[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 the mysql root user. Then when checked mysql then mysql is not accessible to me from root user. I am using the fedora 14…Read more →
Optimizing tables is very necessary for database. That will improve the your website performance. Optimize command is helpful to manage database files in right manner. This command will optimize the…Read more →
I faced the sleep query issue sometimes. Many times that kills the server. When ever you are using dedicated virtual hosting server that time you need to me very careful how you are setting up the apache and mysql.
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. In this tutorial I…Read more →
Before installing the Mongodb on linux box you need to install following packages on box. For 32bit user use following command For 64bit use following command Mongo stores database in…Read more →