Re: 5.0.51 on Solaris 10 SPARC 64 Installation issues

[shrikant nayak]

Hi Experts,

I have installed MySql-5.0.51, the ready-to-use from sunfreeware on Sol-10 (sparc) and it is up. But not allowing to create databases. Any idea how to avoid following errors!

mysql> CREATE database abc;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'abc'
mysql>

bash-3.2# mysqladmin -u root -h Test-Lab1 password 'new-password'
mysqladmin: connect to server at 'Test-Lab1' failed
error: 'Host 'www.Test-Lab1.test.com' is not allowed to connect to this MySQL server'

bash-3.2# mysqladmin -u root -h localhost password 'new-password'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
bash-3.2#

Thanks for your help!