Hi all,
I've just started using mysql and I'm sure that my all problems are
something todo with my oracle-ness, so please bear with me if I use
case-insensitive table names or somthing ;)
Ok. I've been using the mysql interactive command-line interface for a few
days now, and there's no problem there. I've made myself a ~/.my.cnf file
and it appears to work:
[client]
user=idries_wedding
password=******
Since creating it I no longer need to enter username or password details
when I run mysql :)
Now, I'm trying to use mysqlimport:
idries ~/src/wedding/database$ mysqlimport idries_Wedding GUEST.txt
mysqlimport: Error: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO), when using table: GUEST
The problem here seems to be that mysqlimport is not reading the password
from the .my.cnf file. I had a similar problem with it not liking the
database option to be specified in the .my.cnf file, so I removed that. I
have tried several combinations of removing the password from the .my.cnf
file and removing the .my.cnf file completly.
For example:
idries ~/src/wedding/database$ mv ~/.my.cnf ~/..my.cnf
idries ~/src/wedding/database$
mysqlimport --user=idries_wedding --password=**** idries_Wedding GUEST.txt
mysqlimport: Error: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO), when using table: GUEST
idries ~/src/wedding/database$
The only way in which I can stop (Using password:NO) from being displayed is
to tell mysqlimport to prompt me for the password *AND* not specify a
username:
idries ~/src/wedding/database$ mysqlimport -p idries_Wedding GUEST.txt
Enter password:
mysqlimport: Error: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
idries ~/src/wedding/database$
Here the username is not specified, and so it obviously doesn't work, but it
does say (Using password:YES)
However:
idries ~/src/wedding/database$ mysqlimport -uidries_wedding -p
idries_Wedding GUEST.txt
Enter password:
mysqlimport: Error: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO), when using table: GUEST
idries ~/src/wedding/database$
Can anyone tell me where I am going wrong? What is the correct syntax for
calling mysqlimport while specifying a username and password and why doesn't
it use the .my.cnf file in the same was a mysql? I've consulted the manual
and everything that I've done seems to be in keeping with what's required.
Please help!
Also:
idries ~/src/wedding/database$ mysqlimport -V
mysqlimport Ver 3.4 Distrib 4.0.13, for pc-linux (i686)
idries ~/src/wedding/database$ mysql -V
mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686)
idries ~/src/wedding/database$
Thanx in advance,
Idries
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
