How to enable mysql Query cache on linux server? Ans: You need to login to mysql by using root accesss. ========================== root@server#mysql -u root –pPASSWORD mysql> SET GLOBAL query_cache_size = 16777216; (If you want to set query_cache_size=16 MB) ========================== Then...
Category: mysql
reset mysql password in plesk
Error : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Solution : To find password for user admin, run # cat /etc/psa/.psa.shadow FfRBehWy # To login to MySQL mysql -u admin -pFfRBehWy For example # mysql -u...
mysqldump: Got error
Error : When you try to run the mysqldump command to make a backup of database then encounter the following error-exception:mysqldump databasename > databasename.sqlmysqldump: Got error: 1016: Can't open file: './databasename/wp_142_term_taxonomy.frm' (errno: 24) when using LOCK TABLESSolution: Open the file...
database not connected
Error : Your all database details is correct but the database is not connected in any application. Solution : The problem due the " sql.safe_mode" is "On" in php.ini file. You need to turn off the sql.safe_mode in server php.ini...