This is why I am confused, this is a CLEAN mysql install.
I have only done a make make install and mysql_install_db I have not yet set a root password. To double check this I deleted ALL /usr/local/mysql and re-did this. Same thing again. Matt. -----Original Message----- From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]] Sent: 28 July 2002 11:01 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.) 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
