I'm still not able to run a batch file from mysql. Here are my latest
attempts:
C:\Prog\Perl\MySql\mysqlDocs>mysql -u root < go.txt
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
C:\Prog\Perl\MySql\mysqlDocs>mysql -u localhost -p < go.txt
Enter password: *******
ERROR 1045 (28000): Access denied for user 'localhost'@'localhost' (using
password: YES)
Here is the contents of go.txt: select * from pet;
****************************
Jerry Kassebaum wrote:
I'm trying to learn mySql for use with cgi, so I hope y'all will consider
this close enough to a perl question.
I have a file called perl.dbt that contains a batch file to a database. (It
should list all the books I've read with Perl in the title.)
When I go to the command prompt and enter
mysql < c:\perl\mysql\perl.dbt
I get an error:
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using
password: NO)
Now what?
Supply a valid user name on the command line, like this:
mysql -u username -p < perl.dbt
This will prompt you for the password (the password must not be contained in
perl.dbt). To supply the password on the command line, write
mysql -u username -ppassword < perl.dbt
Note there is a space between -u and the username but none between -p and
the password.
Hans
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
