Evan’s posterous

Adventures in pomodoro and other such things 
Tags


Filed under

mysql

 
September 15, 2008

fix mythTv recording times after crash

Have you ever had mythTv crash on you and then show the length of recorded shows incorrectly? e.g. 37 hours for a CSI episode you know is only 1 hour long … running this on the console can fix it:

mysqlcheck -u mythtv -p --repair mythconverg recordedseek

Filed under  //   mysql   mythtv  

Comments [0]

May 3, 2008

change user password on mysql

mysql mysql
SELECT `Host`, `User`, `Password` FROM `user`;
set password for 'auser'@'%' = password('changeme');
flush privileges;

Filed under  //   mysql  

Comments [0]