3 Nov
2008
3 Nov
'08
10:03 a.m.
On Mon, Nov 03, 2008 at 07:58:14AM +0100, ludo1960(a)lycos.co.uk wrote:
There is a distinct lack of documentation so that
makes
configuration a real chore, specifically if I create a database
user, say dbuser and grant him privaledges to the database then when
I connect from my windows machine my user becomes
dbuser(a)cable25.uk.net or something similar so the connection would
be refused by the database.
I remember that in Cpanel there was an option for allow wildcard
ODBC access and this would eneble a connection for
dbuser@anywhere. I'm assuming this can be done from the command line
but again I can't find any documentation.
MySQL uses % as a wildcard for privileges, so a row in one of the
_PRIVEGES tables with 'foo'@'%' in the GRANTEE column gives whatever
privilege the row refers to to the user foo at any host. You can add
privileges from the command line tools using the GRANT command [1], or
using normal SQL commands (though you do have to run 'mysqladmin
flush-privileges' (plus whatever connection and user options you need)
to get those changes to take effect).
Can anybody suggest where I can find out more about
this?
MySQL has fairly comprehensive documentation, not sure about the ODBC
stuff though.
Robert
[1] http://dev.mysql.com/doc/refman/5.0/en/grant.html
Or whatever version of the docs refers to the version of MySQL you
have installed.
________________________________________________________________________
Robert McWilliam rmcw(a)allmail.net www.ormiret.com
Life is complex: it has real and imaginary parts.