Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) [2002]

Sometime get the following error on MySQL sites and also when trying to access MySQL from server: [wpfmb type=’error’ theme=2]Can’t connect to local MySQL server through socket‘/var/lib/mysql/mysql.sock’ (2) [2002][/wpfmb] Solution is very simple: /etc/my.cnf skip-innodb Try to restart MySQL and if it don’t start then use: killall -9 mysqld Assign appropriate permissions to your /tmp directory. # […]

Continue Reading…

How to reset MySQL root password in linux centos

To Reset your MySQL root password: /etc/init.d/mysqld stop mysql -u root Use mysql; update user set password=(“YOUR_ROOT_PW”) where User=’root’; or /usr/bin/mysqladmin -u root password ‘yourmysqlpassword’ Above command can be used to reset plesk admin password as well. flush privileges; quit /etc/init.d/mysqld stop /etc/init.d/mysqld start mysql -u root -p Done. If you want to reset MySQL […]

Continue Reading…

How to Import Blogger data into WordPress

Clients that originally designed their websites with Google Blogger (Blogspot) can have the blog details imported into their WordPress application by using the “Import” function in the WordPress dashboard. WordPress has a built in “Import” function that allows you to transfer different blogs like Blogspot,LiveJournal, and even WordPress. The transfer procedure is the same for […]

Continue Reading…

How to disable SSL for WordPress admin panel

Sometimes when try to login to your WordPress admin panel get the error message: [wpfmb type=’warning’ theme=2]SSL connection error Unable to make a secure connection to the server. This may be a problem with the server, or it may be requiring a client authentication certificate that you don’t have. Error 107 (net::ERR_SSL_PROTOCOL_ERROR): SSL protocol error.[/wpfmb] […]

Continue Reading…