Reply to thread

Message

MediaPortal Version: 1.1 RC4
MediaPortal Skin: StreamedMP
Windows Version: Windows 7 64 Bit
CPU Type: Intel Core i3 530
HDD: Seagate 500gb, Hitachi 1TB, WD 1TB
Memory: 4gb
Motherboard: MSI H55M-E33
Video Card: INtel Clarkdale
Video Card Driver: Intel 8.15.10.2119
Sound Card: Intel Clarkdale
Sound Card AC3:
Sound Card Driver:
1. TV Card: HDhomerun
1. TV Card Type: ATSC
1. TV Card Driver:
2. TV Card: HDhomerun
2. TV Card Type: ATSC
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: MS DTV
MPEG2 Audio Codec: ffdshow (Latest SAF)
h.264 Video Codec: ffdshow (Latest SAF)
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote: MCE 2005
TV: LG 47LH30
TV - HTPC Connection: HDMI through Onkyo 605

Last night I was forced to re-install MP on my HTPC due to a corrupt database (information_schema). I'm definitley not a noob when it comes to working with SQL so I figured I could just repair the database tables and that would be it and I'd be back in business. Errr! Wrong.

When I try to check the tables and repair them I always get the same error:

Error - Table `information_schema`.`CHARACTER_SETS` could not be optimized.
MySQL Error Nr.1044
Access denied for user 'root'@'localhost' to database 'information_schema'

So what's the deal here, why can't the root user make changes to this database? Is there another user I can log in with? The MPTVDB database repairs perfectly fine, it's just information_schema.

Thanks in advance!

<blockquote data-quote="kkozma" data-source="post: 631708" data-attributes="member: 88686">MediaPortal Version: 1.1 RC4MediaPortal Skin: StreamedMPWindows Version: Windows 7 64 BitCPU Type: Intel Core i3 530HDD: Seagate 500gb, Hitachi 1TB, WD 1TBMemory: 4gbMotherboard: MSI H55M-E33Video Card: INtel ClarkdaleVideo Card Driver: Intel 8.15.10.2119Sound Card: Intel ClarkdaleSound Card AC3: Sound Card Driver: 1. TV Card: HDhomerun1. TV Card Type: ATSC1. TV Card Driver: 2. TV Card: HDhomerun2. TV Card Type: ATSC2. TV Card Driver: 3. TV Card: 3. TV Card Type: 3. TV Card Driver: 4. TV Card: 4. TV Card Type: 4. TV Card Driver: MPEG2 Video Codec: MS DTVMPEG2 Audio Codec: ffdshow (Latest SAF)h.264 Video Codec: ffdshow (Latest SAF)Satelite/CableTV Provider: HTPC Case: Cooling: Power Supply: Remote: MCE 2005TV: LG 47LH30TV - HTPC Connection: HDMI through Onkyo 605Last night I was forced to re-install MP on my HTPC due to a corrupt database (information_schema).&nbsp; I'm definitley not a noob when it comes to working with SQL so I figured I could just repair the database tables and that would be it and I'd be back in business.&nbsp; Errr!&nbsp; Wrong.When I try to check the tables and repair them I always get the same error:Error - Table `information_schema`.`CHARACTER_SETS` could not be optimized.MySQL Error Nr.1044Access denied for user 'root'@'localhost' to database 'information_schema'So what's the deal here, why can't the root user make changes to this database?&nbsp; Is there another user I can log in with?&nbsp; The MPTVDB database repairs perfectly fine, it's just information_schema.Thanks in advance!</blockquote>

[QUOTE="kkozma, post: 631708, member: 88686"] [b]MediaPortal Version[/b]: 1.1 RC4 [b]MediaPortal Skin[/b]: StreamedMP [b]Windows Version[/b]: Windows 7 64 Bit [b]CPU Type[/b]: Intel Core i3 530 [b]HDD[/b]: Seagate 500gb, Hitachi 1TB, WD 1TB [b]Memory[/b]: 4gb [b]Motherboard[/b]: MSI H55M-E33 [b]Video Card[/b]: INtel Clarkdale [b]Video Card Driver[/b]: Intel 8.15.10.2119 [b]Sound Card[/b]: Intel Clarkdale [b]Sound Card AC3[/b]: [b]Sound Card Driver[/b]: [b]1. TV Card[/b]: HDhomerun [b]1. TV Card Type[/b]: ATSC [b]1. TV Card Driver[/b]: [b]2. TV Card[/b]: HDhomerun [b]2. TV Card Type[/b]: ATSC [b]2. TV Card Driver[/b]: [b]3. TV Card[/b]: [b]3. TV Card Type[/b]: [b]3. TV Card Driver[/b]: [b]4. TV Card[/b]: [b]4. TV Card Type[/b]: [b]4. TV Card Driver[/b]: [b]MPEG2 Video Codec[/b]: MS DTV [b]MPEG2 Audio Codec[/b]: ffdshow (Latest SAF) [b]h.264 Video Codec[/b]: ffdshow (Latest SAF) [b]Satelite/CableTV Provider[/b]: [b]HTPC Case[/b]: [b]Cooling[/b]: [b]Power Supply[/b]: [b]Remote[/b]: MCE 2005 [b]TV[/b]: LG 47LH30 [b]TV - HTPC Connection[/b]: HDMI through Onkyo 605 Last night I was forced to re-install MP on my HTPC due to a corrupt database (information_schema). I'm definitley not a noob when it comes to working with SQL so I figured I could just repair the database tables and that would be it and I'd be back in business. Errr! Wrong. When I try to check the tables and repair them I always get the same error: Error - Table `information_schema`.`CHARACTER_SETS` could not be optimized. MySQL Error Nr.1044 Access denied for user 'root'@'localhost' to database 'information_schema' So what's the deal here, why can't the root user make changes to this database? Is there another user I can log in with? The MPTVDB database repairs perfectly fine, it's just information_schema. Thanks in advance! [/QUOTE]