List:General Discussion« Previous MessageNext Message »
From:ads mysql Date:December 16 2003 9:36am
Subject:RE: How to create mysql user?
View as plain text  
Yes, It worked with folllowing :
I have created new user 'abc1' with password 'abc1' for database 'abc'.
 
###########################
##########################
[root@allweb mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 83 to server version: 4.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> USE mysql
Database changed
mysql> INSERT INTO user (Host,User,Password)
> VALUES('localhost','abc1',PASSWORD('abc1'));         
Query OK, 1 row affected (0.00 sec)
mysql>CREATE DATABASE abc;
mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
> Create_priv,Drop_priv) VALUES ('localhost','abc','abc1','Y','Y','Y','Y','Y','Y');
Query OK, 1 row affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
[root@allweb mysql]# mysql -u abc1 -p abc
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 84 to server version: 4.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
##################
 
Thanks for great support.
 
 


ads mysql <adsmysql@stripped> wrote:
As advised I tried following :

###########
[root@allweb root]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 71 to server version: 4.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant ALL on abc.* to 'abc'@'localhost' identified by 'abc';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye

[root@allweb root]# mysql -u abc -p abc
Enter password:
ERROR 1045: Access denied for user: 'abc@localhost' (Using password: YES)

No luck.

Help appreciated.


"Duke, Brian" 
wrote:
try this:
grant ALL on abc.* to 'abc'@'localhost' identified by 'abc';

>I have created database 'abc' .

>mysql> grant ALL on abc.table to 'abc' identified by 'abc';
>Query OK, 0 rows affected (0.00 sec)


-----Original Message-----
From: ads mysql [mailto:adsmysql@stripped]
Sent: Monday, December 15, 2003 11:21 PM
To: Nitin; mysql@stripped
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

---------------------------------
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