"Mr. B.HARI" wrote:
>
> Dear Sir,
>
> We have access database.
> Now our objective is to load these tables as mysql tables in to
> MYSQL SERVER
> We have tried several methods but could not do it?
>
> In our local NTSERVER we could able to convert access to mysql table
> in the follwing ways.
>
> I) converted the access files into text files
>
> II) LOAD DATA INFILE ?c:\\textfile? INTO TABLE ?mysql table name? is
> command used
> for storing text files into mysql files.
> III) they were stored in the local NTSERVER/DATA directory.
>
> But same thing we could not do for mysql SERVER our ISP is
> Communitech, our server is mars
>
> I am facing an error ?access denied to username@localhost ?
>
> Please let us know how to store data?
>
> Bharadwaj
>
Your privilege system is not properly configured. Make sure to read the
sections of the manual (#6 I believe) on the privilege system.
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
