I have problems with access permissions on a Solaris 9 installtion of MySql-max 4.1. My
user table shows this
select * from user;
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv |
Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv |
Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer |
x509_subject | max_questions | max_updates | max_connections |
| localhost | racadmin | *01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | N | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | | |
| | 0 | 0 | 0 |
| % | racadmin | *01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | N | Y | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | | | | |
0 | 0 | 0 |
But while connecting I get this error
Shell>id
uid=0(root) gid=1(other)
groups=1(other),0(root),2(bin),3(sys),4(adm),5(uucp),6(mail),7(tty),8(lp),9(nuucp),12(daemon)
shell> mysql -D mysql -u racadmin
ERROR 1045 (28000): Access denied for user 'racadmin'@'localhost' (using password NO)
It's a multi-interface box.
ifconfig -a
lo0: flags=1000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4> mtu 8232 index 1
inet 127.0.0.1 netmask ff000000
eri0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 2
inet 10.3.30.162 netmask ffff0000 broadcast 10.3.255.255
ether 0:3:ba:14:6e:f7
eri1: flags=1000842<BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 3
inet 0.0.0.0 netmask 0
ether 0:3:ba:14:6e:f8
hdc0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 4
inet 172.16.1.2 netmask ffff0000 broadcast 172.16.255.255
ether 0:7:10:99:ec:3f
hdc1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 5
inet 192.168.1.2 netmask ffffff00 broadcast 192.168.1.255
ether 0:7:10:99:ec:40
Does anyone have any clue on what is happening?
Thanks,
Nupur
