Don’t share root user password and mysql.user table acess with anyone till you have full trust on it. Because that encrypted password is real password in MySQL so if anyone knows that than he/she can easily login with any user if he has access to his host. Check with “mysql -uroot ” command, If you … Continue Reading
Monthly Archives: January 2012
some facts about MyISAM file handling and .MYI file In MySQL
Some facts about MyISAM File handling: • If a table is never updated, MySQL will never touch the table files, so it would never be marked as closed or corrupted. • If a table is marked readonly by the OS, it will only be opened in readonly mode. Any updates to it will fail. • … Continue Reading