Can't load data

[jpschwartz]

I've set up a mySQL database on a remote server and can manipulate it with phpmyadmin, but when execute the "Insert data from a textfile into table" routine (just as I did successfully when I was developing the db on my Mac), I get this error message (Any help?)?

Database topicalbiomedicsdb - Table tblStores running on localhost

Error

SQL-query:

LOAD DATA LOCAL INFILE '/tmp/php97Rphf' INTO TABLE tblStores FIELDS TERMINATED BY '\t' ESCAPED BY '\' LINES TERMINATED BY '\r'

MySQL said:

Access denied for user: 'topicalbiomedics@localhost' (Using password: YES)

[planetsim]

Password yes means you have a password there. Most likely you have no password set so leave it blank

[jpschwartz]

I tried removing the password, but then phpmyadmin wouldn't let me see my database.

Here are some of my settings (w/ dummy password) in config.inc.php:

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'topicalbiomedics';
$cfg['Servers'][$i]['password'] = 'password';
$cfg['Servers'][$i]['only_db'] = '';
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['pmadb'] = '';
$cfg['Servers'][$i]['bookmarktable'] = '';
$cfg['Servers'][$i]['relation'] = '';
$cfg['Servers'][$i]['table_info'] = '';
$cfg['Servers'][$i]['table_coords'] = '';
$cfg['Servers'][$i]['pdf_pages'] = '';
$cfg['Servers'][$i]['column_comments'] = '';
$cfg['Servers'][$i]['AllowDeny']['order'] = '';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array();

[jpschwartz]

Finally got it. I had to get "File" permissions set by the server administrator.