Hi, use this: mysql -u root -ppassword
It's important NOT to put a space between -p and the real password. Having a password in a script is unsafe at its best, though. I'm not sure if you have any other options than to put it that way or enter it manually each time you run the script. Regards, Iikka On Sat, 28 Sep 2002 [EMAIL PROTECTED] wrote: > Hi Carl, > > Thanks for your reply. > > I have created a shell script but I get stuck on the part where it asks to > input password. > > How do I get the script to input the password that I put in? > > So far my script looks like this: > > ./mysql -u 'root' -p > echo "abc" > > The script executes, but it just waits for the password after it executes > the line: > ./mysql -u 'root' -p > > Can anyone help with this? > > > Thanks. > > Peter > > > > > > > On Mon, 5 Aug 2002, Carl McNamee wrote: > > > I'm assuming that you are using some form of unix in this. From the system > > prompt type "mysql -u root -ppassword < import_test1". If this works just > > put it into a script (bash, perl, whatever) and run it either from the > > command line or via cron if you want it automated. > > > > Carl McNamee > > Systems Administrator > > Billing Concepts > > (210) 949-7282 > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, August 03, 2002 11:58 PM > > To: [EMAIL PROTECTED] > > Subject: automating import process > > > > > > Hi, > > > > I want to try to automate a phonebook list import process into MySQL > > database. The phonebook was originally created with MS Access and > > exported into a text file. I upload that text file onto my server and I > > proceed with the following import process. > > > > Using Telnet I type: > > # ./mysql -u 'root' -p > > > > It then asks > > Enter password: > > > > I then select the database to use > > mysql> use import_test1; > > > > I delete the previous phonebook list table because the import process does > > not know that it should replace the previous records even though there > > have been changes > > mysql> use import_test1; > > > > mysql> exit > > Bye > > > > > > I then import by doing the following: > > [root@ns2 bin]# ./mysqlimport --local -u "root" -p > > --fields-terminated-by=, import_test1 phone2.txt > > Enter password: > > import_test1.phone2: Records: 53 Deleted: 0 Skipped: 0 Warnings: 1 > > > > > > I was wondering is there anyway to automate this process in a script? > > > > I have never written a script in Linux before. If I can automate this > > process, what kind of script should I use? > > > > Thanks. > > > > Peter > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
