List:General Discussion« Previous MessageNext Message »
From:MySQL DBA Date:July 28 2002 9:49am
Subject:MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)
View as plain text  
Hi,

I have a Solaris 8 Server. I have just compiled MySql 3.23.51.
My Solaris servershas 2 NIC's - 1 with the name/ip of burns, the other with
the name/ip vader

I have done a

make all;

make install;

mysql_install_db

I have then copied the mysql.serverto /etc/init.d/mysql_server
I start mysql using this script and all looks good.

mysql_install_db advised me to set my root password, I have done this on
Linux before so I know not to use the -p option.

I do.......

./mysqladmin -u root password newpass

I get

$ ./mysqladmin -u root password newpass
./mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
$

I have had this before and learnt (thanks to the list) that I sometimes need
to use a hostname.

./mysqladmin -u root -h burns password newpass

./mysqladmin: connect to server at 'burns' failed
error: 'Host 'burns.e-net-lan.co.uk' is not allowed to connect to this MySQL
server'
$


ok so it must be the other hostname

./mysqladmin -u root-h vader password newpass

./mysqladmin: connect to server at 'vader' failed
error: 'Host 'vader.e-netcomm.co.uk' is not allowed to connect to this MySQL
server'
$


So.....I cannot connect/change the password from either of the 2 hostnames,
OR the local host.

Mysql is running


$ 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.

Any help would be interesting.

Thanks,

Matt.

Thread
MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)MySQL DBA28 Jul
  • Re: MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)Dicky Wahyu Purnomo28 Jul
    • RE: MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)MySQL DBA28 Jul
      • Re: MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)Dicky Wahyu Purnomo28 Jul
        • RE: MySQL Cannot Set Root Password on Solaris 8 (Not the usual - strange.)MySQL DBA28 Jul