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
