Activities

April 2010
M T W T F S S
« Mar   May »
 1234
567891011
12131415161718
19202122232425
2627282930  

MySQL : Forgot root password

Here is the steps to re-set the forgot password on MySQL

1.

mysqld_safe –skip-grant-tables &

This command will start the mysql service wihtout looking on the privileges assigned for DB/Users. So anyone can login to this server. But you can’t execute any command against the ‘mysql”database.

2. Log to Mysql console and use [...]

Remove first few lines from the Huge/GB file

Question.

I have a Mysql dump file which is 30GB size and I want to test integrity of the same file by restoring it with another database on the same server ( no other options). Since the size is big I can’t open it with any of the text editor.

Solution.

1. First I split [...]