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.
