Dear Tony,
try this for a first strike:
GRANT ALL ON *.* TO ""@"%"
This will grant access to everything for everyone connecting from
everywhere. No user name and password are required.
If you manipulate the mysql.host and mysql.user tables directly with
update or insert statements, you will have to do a
FLUSH PRIVILEGES
afterwards. This will reload the grant tables and put the grants in
effect. You don't have to do this if you use grant (s. a.).
Regards,
--- Silver Fox <[EMAIL PROTECTED]> wrote:
> Hello, everyone,
>
> I'm Tony. I'm new to this mailing list and I have a question. I'm
> currently running MySQL and Apache webserver. My partner needs to
> connect
> to my MySQL database using JDBC to input data. But every time he
> tries to
> do that, it tells him "access denied for [EMAIL PROTECTED]" Does any
> of you
> know what may be causing this? Are there any setting I have to
> configure or
> my partner has to configure? I have already added an entry in
> mysql.user
> table for host '%' and user '' so everybody can connect to my
> database, but
> my partner still cannot connect. Please help.
>
> Tony
>
>
> >From: "j.urban" <[EMAIL PROTECTED]>
> >To: Lezz Giles <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: Cannot change column type from varchar(32) to char(32)
> >Date: Wed, 1 Aug 2001 17:08:06 -0500 (CDT)
> >
> >It might depend on the other columns in your table definition. Have
> you
> >looked at the Silent Column Specification Changes?
> >
> >http://www.mysql.com/doc/S/i/Silent_column_changes.html
> >
> >If you have ANY varchar() columns, all char columns greater than
> three
> >characters are changed to varchar(). Perhaps the 'little play
> table'
> >doesn't have any other varchars...
> >
> >On Wed, 1 Aug 2001, Lezz Giles wrote:
> >
> > > I'm running 3.21.33b (yes, I know it's old), and I run the
> command:
> > >
> > > alter table branch change codebase codebase char(32) not null
>
> >default
> > > "IPriori";
> > >
> > > where column codebase has type varchar(32) - but the type does
> not
> >change to
> > > char(32).
> > > There's no error message or other indication of what went wrong,
> and if
> >I create
> > >
> > > a little play table I can succesfully change the column type to
> char(32)
> >from
> > > varchar(32).
> > > The table "branch" has just 180 rows in it.
> > >
> > > I'd like to change the column types from varchar to char to speed
> up
> >queries &
> > > etc.
> > > Can anybody shed any light on what I'm doing wrong?
> > >
> > > Thanks,
> > > Lezz Giles
> >
> >
>
>---------------------------------------------------------------------
> >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
> >
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
=====
---
Stefan Hinz <[EMAIL PROTECTED]>
iConnect e-commerce solutions GmbH, 13355 Berlin
Office: +49 30 46307-382 Mobil: +49 177 7841069
Antwortadresse dieser E-Mail: <[EMAIL PROTECTED]>
BITTE NUR IN DRINGENDEN FÄLLEN AN DIESE ADRESSE ANTWORTEN!
---
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
---------------------------------------------------------------------
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
