MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Hostname on a Shared Server??          MySQLTalk.org Forum Index -> MySQL ODBC View previous topic :: View next topic   Author Message Simon Sadler Guest Posted: Wed Jun 30, 1999 5:43 pm    Post subject: Hostname on a Shared Server?? Hi everyone, We have a some shared web space with Superb Internet (they're excellent BTW). PHP and mySQL are working fine. I can also connect to mySQL through Telnet. We're having trouble accessing our mySQL tables via ODBC in Access (Win NT). The problem is that I don't know what to use as a host name in the ODBC settings. The mySQL host name I use to connect in PHP is "localhost" but, obviously, I can't just use that. I've tried the domain of our server but that didn't work either. I normally get an error saying that it can't find mySQL at that hostname but, strangely, I just got this: ** "Access denied for user: 'simon (AT) usera801 (DOT) uk.uudial.com' (Using password: YES)(#1045)" ** Does that mean it found the server? I have no idea how that "usera801.uk.uudial.com" got in there. It must be getting it from my dial-up connection. I would expect that text to be the hostname I had entered. I've also tried connecting using WinMySQL but have the same trouble. This program doesn't use ODBC so I think I can safely rule out a ODBC fault. Looks like I'm in a right mess. Can anyone help? Thanks for your time, Simon. Back to top Michael Widenius Guest Posted: Wed Jun 30, 1999 7:08 pm    Post subject: Hostname on a Shared Server?? Quote: "Simon" == Simon Sadler <simon (AT) straight-edge (DOT) freeserve.co.uk> writes: Simon> Hi everyone, Simon> We have a some shared web space with Superb Internet (they're excellent Simon> BTW). PHP and mySQL are working fine. I can also connect to mySQL through Simon> Telnet. Simon> We're having trouble accessing our mySQL tables via ODBC in Access (Win NT). Simon> The problem is that I don't know what to use as a host name in the ODBC Simon> settings. The mySQL host name I use to connect in PHP is "localhost" but, Simon> obviously, I can't just use that. I've tried the domain of our server but Simon> that didn't work either. I normally get an error saying that it can't find Simon> mySQL at that hostname but, strangely, I just got this: Simon> ** Simon> "Access denied for user: 'simon (AT) usera801 (DOT) uk.uudial.com' (Using password: Simon> YES)(#1045)" Simon> ** Simon> Does that mean it found the server? Yes. Now you only have to get MySQL configured to give user=simon, host=usera801.uk.uudial.com access rights. Simon> I have no idea how that Simon> "usera801.uk.uudial.com" got in there. It must be getting it from my dial-up Simon> connection. I would expect that text to be the hostname I had entered. No. The hostname you entered is the host you try to access. The above host is your current machine (from which you try to access MySQL) Regards, Monty Back to top Simon Sadler Guest Posted: Fri Jul 02, 1999 10:11 am    Post subject: Re: Hostname on a Shared Server?? - Solved Thanks for all the suggestions. Monty was right (of course). Remote connections are now working. Thanks again, Simon. ----- Original Message ----- From: Michael Widenius <monty (AT) monty (DOT) pp.sci.fi> To: Simon Sadler <simon (AT) straight-edge (DOT) freeserve.co.uk> Cc: <myodbc (AT) lists (DOT) mysql.com> Sent: 30 June 1999 7:08 pm Subject: Hostname on a Shared Server?? Quote: "Simon" == Simon Sadler <simon (AT) straight-edge (DOT) freeserve.co.uk writes: Simon> Hi everyone, Simon> We have a some shared web space with Superb Internet (they're excellent Simon> BTW). PHP and mySQL are working fine. I can also connect to mySQL through Simon> Telnet. Simon> We're having trouble accessing our mySQL tables via ODBC in Access (Win NT). Simon> The problem is that I don't know what to use as a host name in the ODBC Simon> settings. The mySQL host name I use to connect in PHP is "localhost" but, Simon> obviously, I can't just use that. I've tried the domain of our server but Simon> that didn't work either. I normally get an error saying that it can't find Simon> mySQL at that hostname but, strangely, I just got this: Simon> ** Simon> "Access denied for user: 'simon (AT) usera801 (DOT) uk.uudial.com' (Using password: Simon> YES)(#1045)" Simon> ** Simon> Does that mean it found the server? Yes. Now you only have to get MySQL configured to give user=simon, host=usera801.uk.uudial.com access rights. Simon> I have no idea how that Simon> "usera801.uk.uudial.com" got in there. It must be getting it from my dial-up Simon> connection. I would expect that text to be the hostname I had entered. No. The hostname you entered is the host you try to access. The above host is your current machine (from which you try to access MySQL) Regards, Monty Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL ODBC All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.