Re: mySql bat file
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 Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: Win32 Environment Variable Read-only?
At 04:18 AM 2/4/2006 -0700, [EMAIL PROTECTED] wrote: The original problem was that, after startup, the PATH contains duplicate pathnames. After debugging the startup sequence (IO.SYS-MSDOS.SYS-COMMAND.COM-CONFIG.SYS-AUTOEXEC.BAT), the problem seemed to originate with IO.SYS, which is a hard module to modify. So I The path variable is set solely, and exclusively, in autoexec.bat. There should be a line in there that says PATH=C:\ That and that alone will be the path value in any command prompt windows u open under 98 and indeed for all of Windows unless it is later modified by the starting shortcut that launches the command prompt. Do Start-Run-command.exe. Then type path at the prompt. The value returned should be identical to whatever was specified in autoexec.bat. io.sys, msdos.sys, and config.sys have nothing to do with the path. If ur command prompt shortcut has a different path than that, then it's the shortcut's fault. Keep in mind that in autoexec.bat there can be multiple cumulative path= statements. -- REMEMBER THE WORLD TRADE CENTER ---= WTC 911 =-- ...ne cede malis 0100 ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: Win32 Environment Variable Read-only?
Chris Wagner wrote: The path variable is set solely, and exclusively, in autoexec.bat. There should be a line in there that says PATH=C:\ That and that alone will be the path value in any command prompt windows u open under 98 and indeed for all of Windows unless it is later modified by the starting shortcut that ... than that, then it's the shortcut's fault. Keep in mind that in autoexec.bat there can be multiple cumulative path= statements. Although this is getting off-topic, let me add that, at least in MS DOS 6.22, you can also set the path in CONFIG.SYS, using a SET statement, and that PATH statements in AUTOEXEC.BAT aren't cumulative under MS DOS, they simply replace the old path with the new one. Don't know about Win 9x. Hans ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: mySql bat file
C:\Perl\MySqlmysql -u localhost -p c:\perl\mysql\perl.dbt Enter password: ** ERROR 1045 (28000): Access denied for user 'localhost'@'localhost' (using passwo rd: YES) I don't remember ever setting up a user name. How do I find out what it is? (Assuming that is the problem.) ** 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 Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: Win32 Environment Variable Read-only?
At 12:50 PM 2/5/2006 +0100, perl-win32-users@listserv.ActiveState.com wrote: and that PATH statements in AUTOEXEC.BAT aren't cumulative under MS DOS, they simply replace the old path with the new one. Don't know about Win 9x. The are cumulative if u include the variable itself in the new path= line C:\Documents and Settings\administratorpath=c:\windows;\c:\dos C:\Documents and Settings\administratorpath PATH=c:\windows;\c:\dos C:\Documents and Settings\administratorpath=%path%;c:\windows C:\Documents and Settings\administratorpath PATH=c:\windows;\c:\dos;c:\windows -- REMEMBER THE WORLD TRADE CENTER ---= WTC 911 =-- ...ne cede malis 0100 ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: mySql bat file
If u never set a user/pass then use root with no password. It is strongly recommented to create a user. And restrict the wide open root. At 07:16 PM 2/5/2006 -0600, Jerry Kassebaum wrote: C:\Perl\MySqlmysql -u localhost -p c:\perl\mysql\perl.dbt Enter password: ** ERROR 1045 (28000): Access denied for user 'localhost'@'localhost' (using passwo rd: YES) I don't remember ever setting up a user name. How do I find out what it is? (Assuming that is the problem.) -- REMEMBER THE WORLD TRADE CENTER ---= WTC 911 =-- ...ne cede malis 0100 ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs