1) Check whether InnoDB is enabled on the server. To check login to shell as root and go to mysql prompt. i) root@server [~]#mysql ii) mysql> show engines; Search for InnoDB and check whether it is Enabled or Disabled. iii) mysql> quit 2) Now if it is disabled and to make it enabled on the […]
If you are getting error like Can’t create new tempfile: ‘tablesname.TMD file error while repairing corrupted database tables please try use following command to fix it.Solution : You need to just run below command on the shell.# myisamchk -r -f tables.MYIThats all.
Hello, 1. Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql database! This is critical! 2. Learn the MySQL access privilege system. The GRANT and REVOKE statements are used for controlling access to MySQL. Do not grant more privileges than necessary. Never grant privileges to all […]
