Hi all,
I connect via ssh from a Linux RedHat 9 box to a remote FreeBSD
server. There I can run MySQL and successfully add/remove tables etc.
However, when I tried to upload a comma separated value file, I got an
access denied error, although all privileges are granted to my
account. What should I do/am I doing wrong?
[EMAIL PROTECTED] jeroen]$ uname -rs
Linux 2.4.21-4.EL
[EMAIL PROTECTED] jeroen]$ ssh [EMAIL PROTECTED]
Password:
[EMAIL PROTECTED] ~> uname -rs
FreeBSD 5.3-RELEASE
[EMAIL PROTECTED] ~> mysql -V
mysql Ver 14.7 Distrib 4.1.10, for portbld-freebsd5.3 (i386)
[EMAIL PROTECTED] ~> mysql -ubiogeek -p
Enter password:
mysql> use biogeek;
Database changed
mysql> LOAD DATA INFILE 'zipcode.data' INTO TABLE zipcodes FIELDS
TERMINATED BY ',';
ERROR 1045 (28000): Access denied for user 'biogeek'@'localhost'
(using password: YES)
mysql> show grants for 'biogeek'@'localhost';
+-----------------------------------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+-----------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'biogeek'@'localhost' IDENTIFIED BY PASSWORD '*66...' |
| GRANT ALL PRIVILEGES ON `biogeek`.* TO biogeek'@'localhost'
|
+-----------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
PS: I do not have root access.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
