-p password
Hi all, A novice question: How can I do away with having to use the -u user and -p password arguments every time I execute the mysql command? When I create a table with a script the only way I can get it to work is with the command: $ mysql samp_db -u root -p create_member.sql $ Enter password: What can I do to not have to enter a user and password each time? Can I use the script at the mysql prompt? This way I would only have to enter the user and password once. Thanks very much, Jim - 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
Re: -p password
Yes. Thank you. Just put a pair of around password and it works fine. I had thought this could be handled in mysql, but hey, this works. rc wrote: one way would bein bash - edit your .bashrc file to include the following: alias mysql='mysql -u username -p password' On Thu, 21 Feb 2002, James Austin wrote: Hi all, A novice question: How can I do away with having to use the -u user and -p password arguments every time I execute the mysql command? When I create a table with a script the only way I can get it to work is with the command: $ mysql samp_db -u root -p create_member.sql $ Enter password: What can I do to not have to enter a user and password each time? Can I use the script at the mysql prompt? This way I would only have to enter the user and password once. Thanks very much, Jim - 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
Re: -p password
I put this line (with no space after the -p) in the .bashrc file and sourced it; alias mysql='mysql -u root -pbig_secret' It gets me in ok. Van suggested the mysql way putting this in a .my.cnf file in my home directory. [client] user=username password=big_secret I know this is basic stuff, but I've got good help and a good book... thanks Paul DuBois wrote: At 14:30 -0800 2/21/02, James Austin wrote: Yes. Thank you. Just put a pair of around password and it works fine. I had thought this could be handled in mysql, but hey, this works. I don't see how it *could* work. When the password is given on the command line, it must follow the -p with no intervening space. rc wrote: one way would bein bash - edit your .bashrc file to include the following: alias mysql='mysql -u username -p password' On Thu, 21 Feb 2002, James Austin wrote: Hi all, A novice question: How can I do away with having to use the -u user and -p password arguments every time I execute the mysql command? When I create a table with a script the only way I can get it to work is with the command: $ mysql samp_db -u root -p create_member.sql $ Enter password: What can I do to not have to enter a user and password each time? Can I use the script at the mysql prompt? This way I would only have to enter the user and password once. Thanks very much, Jim - 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
mysql ended after rpm install
Hello, Can anyone help with an MySQL RPM installation that doesn't seem to be working on RedHat 7.1? First I did an `rpm -i mysql-max-4.0.1-alpha-win.rpm` install and it didn't seem to give me all the filesÂ… but it did put a .sock file in /var/run/mysql. Don't know how this rpm is different from the rpms below. I did an `rpm -e msql-max-4.0.1-alpha-win.rpm` to uninstall it and try again with different rpms. Next I did `rpm -i mysql-3.23.36-1.i386.rpm mysql-server-3.23.36-1.i386.rpm` and it seemed to give me more files, but can't run safe_mysqld. These rpms did not give me a .sock file. What am I missing here? /usr/bin/safe_mysqld starting mysqld daemon with databases from /var/lib/mysql 020206 11:59:29 mysqld ended rpm -qf /usr/lib/libmysql* error: file /usr/lib/libmysql* No such file or directory rpm -q mysql mysql-3.23.36-1 rpm -qa | grep -i mysql msql-3.23.36-1 mysql-server-3.23.36-1 uname -a linux version 2.4.2-2 Any help is much appreciated. Thank you, Jim - 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