"Nupur Jain" <[EMAIL PROTECTED]> wrote on 02/08/2005 01:26:06 PM:
> 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) > <snip> > Does anyone have any clue on what is happening? > > > Thanks, > Nupur > You are attempting to login with an ID that has a password on it but you aren't giving the password. add the -p option to your startup line like this: mysql -D mysql -u racadmin -p and you will be prompted to provide the password. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
