ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a
user "ODBC@localhost" fixed it.
all off a sudden i need a user named ODBC@localhost, and last i checked, i'm
the only one here that knows anything about how to use mysql here at the
office. so what might have been chang
mysql> select user();
+---+
| user()|
+---+
| [EMAIL PROTECTED] |
+---+
mysql> show grants for [EMAIL PROTECTED];
ERROR 1141: There is no such grant defined for user 'root' on host
'192.168.0.17'
mysql> show grants for user();
ERROR 106
is there a place to get the manual that is split a bit more then the current
manual_split.
these are the 2 pages i end up reading the most
even though its usually for just the grant, create, insert syntax (human in
need of memory upgrade)
416k Sep 26 2001 manual_MySQL_Database_Administration
manual_Reference.html#CREATE_TABLE
>create_definition:
> col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
>[PRIMARY KEY] [reference_definition]
create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20));
can't seem to find the ref right now, but
< i
is there a way or possibly a command line tool for querying a remote file and
having it dump the select into a local outfile.
it does exacly what i want from the server, but only to create a file on the
server. and just adding local doesn't/hasn't work.
and mysqldump outputs sql, which isn't wh
