To reset WordPress admin password from MySQL database, follow the simple steps 1) Login to cPanel and open the database used by WordPress in phpMyAdmin. 2) Click on MySQL icon at the top of the navigation bar. 3) In the query field, execute the following query UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password_here’ ) WHERE `wp_users`.`user_login` = “admin_username”; “new_password_here” – [...]
If you are getting Mysql Error: #42000 Import error: The used command is not allowed with this MySQL version Such type of error generally occurs when you are trying to import data from a file into MySQL using LOAD DATA LOCAL INFILE. To solve this problem, you will have to make changes in the my.cnf file on the server. It [...]
Server optimization always include MYSQL optimization which plays an important role in the overall performance of the server. Optimization of my.cnf file which is located at /etc/my.cnf is very important to ensure good performance of MYSQL . I am putting forward a optimized my.cnf for a 2GHZ processor and 1GB RAM. Kindly do not copy and paste the codes blindly. [...]
