try restarting mysql service ..
Cheers
Binay
- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: "Duke, Brian" <[EMAIL PROTECTED]>; "Nitin"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 2:07 PM
S
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';
ble to 'abc' identified by 'abc';
>Query OK, 0 rows affected (0.00 sec)
-----Original Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 11:21 PM
To: Nitin; [EMAIL PROTECTED]
Subject: Re: How to create mysql user?
O K.
I accessed to my
did u do a
flush privilege
- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 1:00 PM
Subject: Re: How to create mysql user?
> O K. I have tried
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
t; <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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
:
>
>
&
inal Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 11:21 PM
To: Nitin; [EMAIL PROTECTED]
Subject: Re: How to create mysql user?
O K.
I accessed to mysql as root user and tried to created user 'abc' as folows :
[EMAIL PROTECTED] mysql]# mysql -u root
O K.
I accessed to mysql as root user and tried to created user 'abc' as folows :
[EMAIL PROTECTED] 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.
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 -
