Joedilson, the syntax for specifying a password to mysqladmin is --password=my_password, or -p if you want it to prompt. (Notice that it says, "Using password: NO" .. thats because it doesn't realize you're trying to use a password).
You also need to specify the password when you're using mysql .. so.. /usr/local/mysql/bin/mysql --password=my_password < mysql_create.sql In general I suggest you take a look at mysqladmin --help | more and mysql --help | more Having the applications themselves answer your questions will be much faster than a mailing list. =) Eric Mayers Software Engineer I Captus Networks > -----Original Message----- > From: Joedilson B. Azevedo [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 3:08 PM > To: [EMAIL PROTECTED] > Subject: Bugs and more Bugs. > > > Hi, I installed the BD mysql and I am some problems. > > # /usr/local/mysql/bin/safe_mysqld & > It's ok. > > Here: > # mysqladmin password my_password > > /usr/local/mysql/bin/mysqladmin: connect to server at > 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > And when I try do tables in mysql > > /usr/local/mysql/bin/mysql < mysql_create.sql > ERROR 1045: Access denied for user: 'root@localhost' (Using > password: NO) > > What I do? > > > >Release: mysql-3.22.32 (Source distribution) > > >Environment: > > System: Linux <name_of_machine> 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT > 2000 i686 unknown > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake > /usr/bin/gcc /usr/bin/cc > GCC: Reading specs from > /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version > 2.96 20000731 (Red Hat Linux 7.0) > Compilation info: CC='gcc' CFLAGS='' CXX='c++' > CXXFLAGS='' LDFLAGS='' > Configure command: ./configure --prefix=/usr/local/mysql > > > Thank you for you help. > Joedilson > --------------------------------------------------------------------- > Um fracasso na vida nao representa o fim da utilidade > --------------------------------------------------------------------- > > > --------------------------------------------------------------------- > 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
