List:General Discussion« Previous MessageNext Message »
From:Nitin Date:December 16 2003 8:31am
Subject:Re: How to create mysql user?
View as plain text  
did u do a
flush privilege


----- Original Message ----- 
From: "ads mysql" <adsmysql@stripped>
To: "Nitin" <nitinmehta@stripped>; <mysql@stripped>
Sent: Tuesday, December 16, 2003 1:00 PM
Subject: Re: How to create mysql user?


> O K. I have tried following as advised.
>
> #####
> [root@shastrihallweb mysql]# mysql -u abc -p abc
> Enter password:
> ERROR 1045: Access denied for user: 'abc@localhost' (Using password: YES)
> ######
>
> Then once again I accessed mysql as root user and Granted permission as
follows :
>
> [root@allweb mysql]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 69 to server version: 4.0.16-standard
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>
> mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON abc.* TO
abc@localhost IDENTIFIED BY 'abc';
> Query OK, 0 rows affected (0.01 sec)
> mysql> USE abc
> Database changed
> mysql> exit
> Bye
>
>
> [root@allweb mysql]# mysql -u abc -p abc
> Enter password:
> ERROR 1045: Access denied for user: 'abc@localhost' (Using password: YES)
>
> Don't know what is wrong.
> Thanks for support.
>
>
> Nitin <nitinmehta@stripped> wrote:
> dear buddy,
>
> when u specify permissions on a particular database, you need to give that
> database name to connect to db.
>
> user created fine, while connecting, try this:
>
> mysql -u abc -p abc
>
> where last abc is ur database name.
>
> Nitin
>
>
> ----- Original Message ----- 
> From: "ads mysql"
> To: "Nitin" ;
> Sent: Tuesday, December 16, 2003 11:51 AM
> Subject: Re: How to create mysql user?
>
>
> > O K.
> > I accessed to mysql as root user and tried to created user 'abc' as
folows
> :
> >
> >
> > [root@allweb mysql]# mysql -u root -p
> > Enter password:
> > Welcome to the MySQL monitor. Commands end with ; or \g.
> > Your MySQL connection id is 61 to server version: 4.0.16-standard
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > I have created database 'abc' .
> >
> > mysql> grant ALL on abc.table to 'abc' identified by 'abc';
> > Query OK, 0 rows affected (0.00 sec)
> >
> > I want to give all permission to user abc to handle database 'abc'.
> >
> > Then I tried to connect as user 'abc' to mysql as follows :
> > [root@allweb mysql]# mysql -u abc -p
> > Enter password:
> > ERROR 1045: Access denied for user: 'abc@localhost' (Using password:
YES)
> >
> > Some problem.
> >
> >
> > Help appreciated.
> >
> >
> >
> > Nitin wrote:
> > right now, u r trying to connect t omyql with uer abc, not creating it.
> >
> > to create user abc
> > grant
> > on dbname.tablename to 'abc' identified by 'abc';
> >
> > you can view the list of privileges available on myql website at
> > http://www.mysql.com/doc/en/GRANT.html
> >
> > Enjoy
> > Nitin
> >
> >
> > ----- Original Message ----- 
> > From: "ads mysql"
> > To:
> > Sent: Tuesday, December 16, 2003 11:09 AM
> > Subject: How to create mysql user?
> >
> >
> > >
> > > Hi,
> > > I have installed mysql. As per documentation with user as 'root'.
> > >
> > > I can create Database, table. I can enter data into table.
> > >
> > > I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server.
> > > by using command :
> > > adduser abc -p 'abc'
> > >
> > > Now I want to create mysql database user 'abc' with command :
> > >
> > > [root@xyz mysql]# mysql -u abc -p
> > > Enter password: (entered abc)
> > > ERROR 1045: Access denied for user: 'abc@localhost' (Using password:
> YES)
> > >
> > > Is it granting permission to abc. I refered documentation but could
not
> > get it clearly Neet sample code.
> > >
> > > Then I connected mysql as 'root' user. and tried.
> > >
> > > mysql> mysql -u abc -p;
> > > ERROR 1064: You have an error in your SQL syntax. Check the manual
that
> > corresonds to your MySQL server version for the right syntax to use near
> > 'mysql -u ab -p' at line 1.
> > >
> > >
> > > Syntax I got from Documentation for GRANT as follows:
> > >
> > > ###########
> > > 4.4.1 GRANT and REVOKE Syntax
> > >
> > >
> > > GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
> > > ON {tbl_name | * | *.* | db_name.*}
> > > TO user_name [IDENTIFIED BY [PASSWORD] 'password']
> > > [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...]
> > >
> > > #######
> > >
> > > Please guide me how to create users for mysql with password.
> > >
> > > Thanks for support.
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Do you Yahoo!?
> > > New Yahoo! Photos - easier uploading and sharing
> >
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > New Yahoo! Photos - easier uploading and sharing
>
>
>
> ---------------------------------
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing


Thread
How to create mysql user?ads mysql16 Dec
  • Re: How to create mysql user?Nitin16 Dec
    • Re: How to create mysql user?ads mysql16 Dec
      • Re: How to create mysql user?Nitin16 Dec
        • Re: How to create mysql user?ads mysql16 Dec
          • Re: How to create mysql user?Nitin16 Dec
RE: How to create mysql user?Brian Duke16 Dec
  • RE: How to create mysql user?ads mysql16 Dec
    • RE: How to create mysql user?ads mysql16 Dec
    • Re: How to create mysql user?Binay16 Dec