Problem with subselect and primary keys

2006-09-29 Thread Derek Fountain
Can someone tell me what's wrong with this test: create table t1 ( course_id int(10) signed not null, primary key (course_id) ); create table t2 ( course_id int(10) unsigned not null, primary key (course_id) ); insert into t1 values (1),(-1),(-2),(2),(3),(4),(5),(6),(7),(8),(65),(66),(67),(68

Permissions problem

2002-07-12 Thread Derek Fountain
Hi, I have a server running 3.23.41 on Redhat 7.1. The problem is that I can't access a database as a local user, but I can as a remote user. That is, on the local machine I get this: >/usr/bin/mysqladmin -u tpdb -p="" create fred /usr/bin/mysqladmin: connect to server at 'localhost' failed er