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. Continue reading
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, 8 out of 10 times you’ll need to more of … Continue reading
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 connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)’ Check … Continue reading
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.
[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 that the socket: ‘/var/lib/mysql/mysql.sock’ exists! Using following command I checked … Continue reading
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 on my machine. After trying so many things at the … Continue reading
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 size of file size of database files. If you want … Continue reading
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. Continue reading