Re: load data infile skips records

2003-10-11 Thread James Cradock
umn) and line delimiters in the LOAD DATA command if, for examples, values in the records you are trying to load contain tabs, new line and other "special" (to MySQL) characters. Different options, and good examples, are documented for MySQL 4.x here: http://www.mysql.com/doc/en/L

Re: what means "shell" ?

2003-10-12 Thread James Cradock
ich means you should just be able to start a terminal application and type "mysql" to begin. - Jim - James Cradock, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: what means "shell" ?

2003-10-12 Thread James Cradock
"shell" is the interactive terminal program, mysql. For Windows, if > MySQL was installed in C:\mysql, start the Command Prompt from > Accessories, change to C:\mysql, and type "mysql". > > In Unix, including Linux, BreeBSD and Mac OS X, mysql ought to be in your > p

Re: Error 1045

2003-10-13 Thread James Cradock
user datas ? Or how to resolve this problem ? - James Cradock, [EMAIL PROTECTED] me3 Technology Consultants, LLC 24 Preble Street Portland, Maine, USA 04101 207-772-3217 (office) 207-838-8678 (mobile) http://www.me3.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Error 1045

2003-10-13 Thread James Cradock
in. Run: mysql -u stw -p ...enter the password when prompted, and you're in. - Jim On Monday, October 13, 2003, at 11:20 AM, Stephan Wölfel wrote: thanks for the advise. What you tell all works. But even after this I still get the same error 1045 when typing "grant all on *.* to

Re: Error 1045

2003-10-13 Thread James Cradock
ise. >> >However I have some additional questions: >> >ad 2) How can I check the grant privileges ? >> >ad 3) How can I "run this as the mysql root user" ? >> > >> mysql -u root -p >> enter the root password you set when you installed mysql >> u