Pada Sun, 28 Jul 2002 10:49:01 +0100
"MySQL DBA" <[EMAIL PROTECTED]> menulis :
> ./mysqladmin -u root password newpass
> $ ./mysqladmin -u root password newpass
> ./mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
:D
Did you have mysql running/installed before you install this one ?
It seems that your mysql privileges is already configured, so you don't have to set up
the root password anymore since it already has one.
You just use it like you always do : mysql -u root -p
..... and you will enter the existing root password ;-)
> $ ps -ef | grep mysql
> mysqldba 17585 17497 0 10:41:44 pts/1 0:00 -ksh
> mysqldba 17595 1 0 10:42:08 pts/1 0:00 /bin/sh
> /usr/local/mysql/bin/safe
> _mysqld --datadir=/usr/local/mysql/var --pid-f
> mysqldba 17607 17595 0 10:42:08 pts/1 0:00
> /usr/local/mysql/libexec/mysqld -
> -basedir=/usr/local/mysql --datadir=/usr/local
>
>
> The ONLY think I can see that is strange is mysql is installed in
> /usr/local/mysql so I would expect the --datadir to be /usr/local/mysql/var
> on BOTH the mysql daemons.
well, you should check your /etc/init.d/mysql_server or your my.cnf file or even you
/usr/local/mysql/bin/safe_mysqld ;-)
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 37 days, Queries : 353.656 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
---------------------------------------------------------------------
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
