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
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.
./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)'
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
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
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
_mysqld --datadir=/usr/local/mysql/var --pid-f
mysqldba 17607 17595 0 10:42:08 pts/1 0:00
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.