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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
