Hello Roland,
Basically users are defined with their 'hostname'. So if i dial in
from my isp it might be [EMAIL PROTECTED] so I have to define rights to
that user.
Along with the manual bit below .. you might want to get Paul DuBois's
great book on Mysql.
This bit is from the manual .. 7.35 Grand and Revoke Syntax
In order to accommodate granting rights to users from arbitrary hosts,
MySQL supports specifying the user_name value in the form user@host.
If you want to specify a user string containing special characters
(such as `-'), or a host string containing special characters or
wild-card characters (such as `%'), you can quote the user or host
name (for example, 'test-user'@'test-hostname').
You can specify wild cards in the hostname. For example,
user@"%.loc.gov" applies to user for any host in the loc.gov domain,
and user@"144.155.166.%" applies to user for any host in the
144.155.166 class C subnet.
The simple form user is a synonym for user@"%". NOTE: If you allow
anonymous users to connect to the MySQL server (which is the default),
you should also add all local users as user@localhost because
otherwise the anonymous user entry for the local host in the
mysql.user table will be used when the user tries to log into the
MySQL server from the local machine! Anonymous users are defined by
inserting entries with User='' into the mysql.user table. You can
verify if this applies to you by executing this query:
mysql> SELECT Host,User FROM mysql.user WHERE User='';
Wednesday, September 05, 2001, 3:38:10 AM, you wrote:
RT> Hi,
RT> I’ve just started playing about with MySQL. I created a database called
RT> ‘haworth’, no problem there, then created a table called ‘list’.
RT> I put 3 entries in it, and checked it using
RT> SELECT * FROM list;
RT> It showed all the records fine. The MySQL server is running on NT, and I can
RT> connect remotely by using the following statement.
RT> Mysql –h x –u root –p
RT> X being the IP address of my server. This works fine on any computer I tried
RT> it on.
RT> I then installed MyODBC on a Win2000 computer. All went well, then I setup
RT> the link to the database.
RT> But when I tried to access it, I got the following message.
RT> UNABLE TO CONNECT TO SOURCE “MYTEST” – “S1000” –“[TCX][MyODBC] Access Denied
RT> for user: ‘@MAILSERVER’ To database ‘roland’” – 00000414
RT> I then reset the link to the test database, and tried again, this worked
RT> fine.
RT> Do I need to setup something else on the server so I can access the
RT> database?
RT> Some help would be appreciated, as I’m about to throw the computer out of
RT> the window!!!
RT> Thanks
RT> Roland
RT> Manchester, England
RT> ---------------------------------------------------------------------
RT> Before posting, please check:
RT> http://www.mysql.com/manual.php (the manual)
RT> http://lists.mysql.com/ (the list archive)
RT> To request this thread, e-mail <[EMAIL PROTECTED]>
RT> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
RT> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Best regards,
Igbar mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
