Table names in MySQL are case sensitive.
update Only on Unix machines. Windows servers don't enforce this. Thanks to PodMaster for reminding me.

'Users' is different from 'users' or 'USERS'. Check the real name for that table before running your script.

That said, make sure that you can connect to that table using any other means, i.e. the standard MySQL command line client or the MySQL Control Center.

The database server tells you that a table does not exist in two cases: (1) when the table is not there and (2) when you are not authorized to see it. The error messages should be different, though. Check also if the return message is the one generated by the database server or it is coming from an intermediate wrapper.

You may try to access using the plain DBI
#!/usr/bin/perl -w
use strict;
use DBI;
my $database_name = "mydb";
my $user = 'I_am';
my $password = "smart";
my $url="db.strangehost.com";
my $dbh=DBI->connect("dbi:mysql:$database_name;host=$url",
$user,$password, {RaiseError=>1});

for ($dbh->tables) {
    print "$_\n";
}

$dbh->disconnect();

[download]
This script will give you the list of tables you are authorized to see in that database.
 _  _ _  _  
(_|| | |(_|><
 _|

[download]

In reply to Re: Connecting to mySQL using DBIx::Recordset - table name upper case problem by gmax
in thread Connecting to mySQL using DBIx::Recordset - table name upper case problem by Heidegger

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.