<html><div style='background-color:'><P><BR><BR></P>
<DIV>
<DIV class=RTE>To see the tables that exist:</DIV>
<DIV class=RTE>> show tables;</DIV>
<DIV class=RTE>If you get a message saying "no database selected" select a database with</DIV>
<DIV class=RTE>>use mysql; or >use ser;, depending on what database you want to use. </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>SER database doesn't have a user table, it has a subscriber table. MYSQL has a user table.</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>These are the tables :</DIV>
<DIV class=RTE>+---------------------------+<BR>| Tables_in_mysql |<BR>+---------------------------+<BR>| columns_priv |<BR>| db |<BR>| func |<BR>| help_category |<BR>| help_keyword |<BR>| help_relation |<BR>|
help_topic |<BR>| host |<BR>| tables_priv |<BR>| time_zone |<BR>| time_zone_leap_second |<BR>| time_zone_name |<BR>| time_zone_transition |<BR>| time_zone_transition_type |<BR>| user |<BR>+---------------------------+</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>And:</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>+-----------------------+<BR>| Tables_in_ser |<BR>+-----------------------+<BR>| acc |<BR>| active_sessions |<BR>| aliases |<BR>| config |<BR>| domain |<BR>| event |<BR>| grp |<BR>|
location |<BR>| missed_calls |<BR>| pending |<BR>| phonebook |<BR>| preferences |<BR>| reserved |<BR>| server_monitoring |<BR>| server_monitoring_agg |<BR>| silo |<BR>| subscriber |<BR>|
uri |<BR>| version |<BR>+-----------------------+</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE><BR>><BR>>After installing mysql 5.0.3 and running ser_mysql.sh<BR>><BR>>then<BR>><BR>>mysql> select * from user;<BR>><BR>>Returns:<BR>><BR>>ERROR 1146 (42S02): Table 'ser.user' doesn't exist<BR>><BR>>Any help is grealty appreciated<BR>><BR>>-kim<BR>><BR>>--<BR>>w8hdkim@gmail.com<BR>><BR>>_______________________________________________<BR>>Serusers mailing list<BR>>serusers@lists.iptel.org<BR>>http://lists.iptel.org/mailman/listinfo/serusers<BR></DIV></DIV></div></html>