Sometimes you need to change the timezone used by MySQL on the server for some specific applications or globally. The below steps will help you to change the MySQL time zone. 1) Check time_zone* tables in mysql db. If it is empty then fill them using following command # mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql Zone Info database on [...]
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” – [...]
While restarting MySQL service, you may get a error “MySQL is running but PID file could not be found” Let us see how to fix this error: Login to the server as a root user with SSH Create the directory var/run/mysql #mkdir /var/run/mysql Find helpful? Spread it! Tweet
If you are using Plesk and MySQL you may get a error while adding a MySQL database user to a database as Error: Connection to the database server has failed: Table ‘mysql.servers’ doesn’t exist To fix this error, SSH the server as a root user. Execute the command [root@server ~]# mysql_fix_privilege_tables –user=admin –password=<admin password> –verbose On executing the [...]
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. [...]
