![]() |
| |||
| bradfordh@gmail.com wrote: > I just tried to execuete a Load Data Infile command to import data from > a .cvs file into a mysql table, but I get the following error. Any help > at all is greatly appreciated. Thanks > > > > #1045 - Access denied for user 'number11'@'localhost' (using password: > YES) > My guess would be that number11@localhost doesn't have 'file' authorization for this database. Alternatively, it could be if you're using a recent version of MySQL which has local infile support disabled by default. To change this, you must use: mysql --local-infile And BTW - did you try a google search? One on "LOAD DATA INFILE" mysql 1045 showed several possibilities. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ================== |
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
| |