List:General Discussion« Previous MessageNext Message »
From:Nupur Jain Date:February 8 2005 6:26pm
Subject:Mysql permissions
View as plain text  
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
Thread
Mysql permissionsNupur Jain8 Feb
  • Re: Mysql permissionsSGreen8 Feb