[mythtv-users] problem changing mythtv mysql password

[Yianni Vidalis]

----------------------------------------
> Date: Wed, 11 Nov 2009 19:18:16 -0800
> From: 3gemail at gmail.com
> To: mythtv-users at mythtv.org
> Subject: [mythtv-users] problem changing mythtv mysql password
>
> I get the following error when I try to change the mythtv password in
> mysql can someone help? i am runnung .22 upgraded from .21
>
> ERROR 1146 (42S02): Table 'mythconverg.user' doesn't exist
>
> I logged in with mysql -u root -p mythconverg
>
> Show tables ; listst below
> +--------------------------------+
> | Tables_in_mythconverg |
> +--------------------------------+
> | archiveitems |
> | callsignnetworkmap |
> | capturecard |
> | cardinput |
> | channel |
> | channelgroup |
> | channelgroupnames |
> | channelscan |
> | channelscan_channel |
> | channelscan_dtv_multiplex |
> | codecparams |
> | credits |
> | customexample |
> | diseqc_config |
> | diseqc_tree |
> | displayprofilegroups |
> | displayprofiles |
> | dtv_multiplex |
> | dtv_privatetypes |
> | dvdbookmark |
> | dvdinput |
> | dvdtranscode |
> | eit_cache |
> | filemarkup |
> | gallerymetadata |
> | gamemetadata |
> | gameplayers |
> | housekeeping |
> | inputgroup |
> | inuseprograms |
> | jobqueue |
> | jumppoints |
> | keybindings |
> | keyword |
> | movies_movies |
> | movies_showtimes |
> | movies_theaters |
> | music_albumart |
> | music_albums |
> | music_artists |
> | music_directories |
> | music_genres |
> | music_playlists |
> | music_smartplaylist_categories |
> | music_smartplaylist_items |
> | music_smartplaylists |
> | music_songs |
> | music_stats |
> | mythlog |
> | mythweb_sessions |
> | netflix |
> | networkiconmap |
> | newssites |
> | oldfind |
> | oldprogram |
> | oldrecorded |
> | people |
> | phonecallhistory |
> | phonedirectory |
> | pidcache |
> | playgroup |
> | powerpriority |
> | profilegroups |
> | program |
> | programgenres |
> | programrating |
> | recgrouppassword |
> | record |
> | recorded |
> | recordedcredits |
> | recordedfile |
> | recordedmarkup |
> | recordedprogram |
> | recordedrating |
> | recordedseek |
> | recordingprofiles |
> | recordmatch |
> | romdb |
> | schemalock |
> | settings |
> | storagegroup |
> | streams |
> | tvchain |
> | tvosdmenu |
> | upnpmedia |
> | videocast |
> | videocategory |
> | videocountry |
> | videogenre |
> | videometadata |
> | videometadatacast |
> | videometadatacountry |
> | videometadatagenre |
> | videosource |
> | videotypes |
> | weatherdatalayout |
> | weatherscreens |
> | weathersourcesettings |
> | websites |
> +--------------------------------+
> 99 rows in set (0.00 sec)
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

 
Yes, the message you are getting is correct. To change any password you don't use a particular database. the mythtv user is not part of the mythconverg database. Just log in using mysql -u root -p and you'll change it.
  		 	   		  
_________________________________________________________________
Νέα Windows 7: Βρείτε τον κατάλληλο υπολογιστή για εσάς. Μάθετε περισσότερα.
http://windows.microsoft.com/shop