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. Incoming search terms:create user permissions … Continue reading
[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. I … Continue reading
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 will show you how to created mysql log file for … Continue reading
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 data/db folder. so we need to create those folder using … Continue reading
You can use following commands for installing the Mysql workbench on Linux system. Mysql workbench is very nice tool for creating the ER diagram on mysql database. I personaly like that tool so much. [root@sonyk-pc sony]# rpm -Uvh remi-release-11.rpm warning: … Continue reading