Category Archives: MYSql

Change or Set the MySQL Root password (Windows):

Change or Set the MySQL Root password (Windows): ================================================ 1. Stop your MySQL server completely. This can be done by accessing the Services window inside Windows XP and Windows Server 2003, where you can stop the MySQL service. 2. Open … Continue reading

Posted in MYSql | Tagged , | Leave a comment

How to Check and Repair MySQL Tables Using Mysqlcheck

How to Check and Repair MySQL Tables Using Mysqlcheck ===================================================== Database Name : sms Table Name: attend 1. Check a Specific Table in a Database mysqlcheck -c sms attend -u root -p 2. Analyze Tables using Mysqlcheck # mysqlcheck -a … Continue reading

Posted in MYSql | Tagged , , | Leave a comment

MySQL Bin Files Eating Lots of Disk Space

MySQL Bin Files Eating Lots of Disk Space ========================================== I get a large amount of bin files in the MySQL data directory called “server-bin.n” or mysql-bin.00000n, where n is a number that increments. [root@ENMDB1 mysql]# df -h . Filesystem Size … Continue reading

Posted in MYSql | Tagged , | Leave a comment