Weird problem

[Silver Fox]

I just got this problem...

bin/mysql -h localhost -u root
logs me into MySQL at the command line

However, the CGI script for Apache webserver gave me an error connecting to 
the database
$source = DBI:mysql:red:localhost;
$username = root;
$password = ;

Did any of you ever face this problem before??
BTW, I'm running Mandrake Linux...

Very puzzled Tony

_
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

JDBC Connection help

[Silver Fox]

Hi everyone,

I just installed MySQL on my linux box.  But when I tried to connect to my 
own box with jdbc (jdbc:mysql://localhost/red), it gave me SQLException: 
server configuration denies access to data source.  I have already added 
root in the mysql.user and mysql.db, why is this happening??  What 
additional configuration change do I need to do??

Please help

Tony

_
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

Re: Cannot change column type from varchar(32) to char(32)

[Silver Fox]

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