<html><head><style type='text/css'>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style></head><body><br><div>----- Original Message -----<br>From: "Damian Surr" <damian@gingermagic.co.uk><br>To: "Discussion about mythtv" <mythtv-users@mythtv.org><br>Sent: Friday, March 9, 2007 12:59:47 PM (GMT-0700) America/Denver<br>Subject: [mythtv-users] My MySql hell :-)<br><br><title></title><br><div><strong class="userinput"><code>> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'192.168.0.102'</code></strong> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;<strong class="userinput"><code><br>> flush privileges;<br><span style="font-weight: normal;"><br>ack! you want to limit the change to the mythconverg db, so the command becomes:</span><br><br></code></strong><strong class="userinput"><code>GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'192.168.0.102'</code></strong> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;<strong class="userinput"><code><br>flush privileges;<br></code></strong></div></div><br>sorry for the double post.<br><br>-- <br>Peter Abplanalp<br></body></html>