Introduction This is very simple article to set the mysql mode permanently inside your Mysql Server 5.7 or above versions. I tried some articles and finally found this to helpfull for someone who came with same issue. Usually some queries needs to change the sql mode permanently, Otherwise you need to write  set mode everytime. I got stressed to set sql_mode on every query. So ...

Resetting or Changing PHPMyAdmin Password On Linux. Sometimes you might have the problem of resetting your phpmyadmin password. Everytime it makes you to feel big to work.  And some tutorials are not nice to read and follow. because they may suggested the final step mainly. Let me elaborate you in detail. Just goto your Terminal. Just do the following steps. Stop the MySQL server to ...

Solution for phpmyadmin.pma_table_uiprefs doesn’t exist. the below image explains you the error message completely.The error is ” SELECT `prefs` FROM `phpmyadmin`.`pma_table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'kvcodes_test' AND `table_name` = 'kvc0005_users' MySQL reports: #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist The images tells you more .   If you faced any such a error.  just do the following steps, your problem will be solved. ...