title: How to access ejabberd web console after connecting it to mysql?
body: <p>I am new to ejabberd. I have connected ejabberd to mysql. Users are registering successfully but i can't access the ejabberd web console. It is giving error on ejabberdctl live-</p>
  
  <pre><code>W(&lt;0.348.0&gt;:ejabberd_web_admin:224) : Access of "admin" from "127.0.0.1" failed with error:  "bad-password"
  </code></pre>
  
  <p>i have register admin with following command and it has successfully registered users in mysql. </p>
  
  <pre><code>ejabberdctl register admin localhost password
  </code></pre>
  
  <p>The lines of ejabberd.cfg file which i changed to connect to mysql are as follows- </p>
  
  <pre><code>{auth_method, odbc}.
  %% To use both anonymous and internal authentication:
  {host_config, "public.example.org", [{auth_method, [odbc, anonymous]}]}.
  {odbc_server, "DSN=testing;UID=root;PWD=india"}.
  {acl, admin, {user, "admin", "localhost"}}.
  
  {mod_last_odbc,     []},
  {mod_offline_odbc,  [{access_max_user_messages, max_user_offline_messages}]},
  {mod_privacy_odbc,  []},
  {mod_private_odbc,  []},
  {mod_pubsub_odbc,   [
                {access_createnode, pubsub_createnode},
                {ignore_pep_from_offline, true}, % reduces resource comsumption, but XEP incompliant
                %%{ignore_pep_from_offline, false},  % XEP compliant, but increases resource comsumption
                {last_item_cache, false},
                {plugins, ["flat", "hometree", "pep"]}  % pep requires mod_caps
               ]},
  {mod_roster_odbc,   []},
  {mod_vcard_odbc,    []},
  </code></pre>
  
  <p>Please response with the answer. I got stuck in this problem.</p>
  
  <p>On startup ejabberd using - ejabberdctl live, the following report is also shown-</p>
  
  <pre><code>=INFO REPORT==== 2013-12-29 16:48:05 ===
  I(&lt;0.40.0&gt;:cyrsasl_digest:44) : FQDN used to check DIGEST-MD5 SASL authentication:
  </code></pre>
  
  <p>Does it affect anything in authenticating? I am using ejabberd- 2.1.12 and mysql 5.5</p>