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