;
To: "Lou Olsten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 9:34 PM
Subject: Re: Creating Users and Passwords
>
> Lou Olsten wrote:
>
> > I thought I had a handle on this, but now I'm all screwed up.
> >
> > My
Dan Nelson wrote:
In the last episode (Apr 29), Lou Olsten said:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access
to everything. Here's what happens:
- Sign in
Lou Olsten wrote:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access to everything. Here's what happens:
- Sign in as root on the local host.
- GRANT ALL PRIVILE
At 16:21 -0500 4/29/04, Dan Nelson wrote:
In the last episode (Apr 29), Lou Olsten said:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with
access to everything. Her
hmmmif you are on the same machine, does it work if you do not specify the '-h
localhost'?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is the version of your mysql client? If it is pre 4.1 then it is likely being
bitten by the password length change from 4.0.xx to 4.1 from 16bytes to 41bytes.
You'll need to read the note on passwords in the 4.1 docs.
Hope this helps.
--
MySQL General Mailing List
For list archives: ht
ing
unique to that box.
Lou
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 5:21 PM
Subject: Re: Creating Users and Passwords
> In the last
In the last episode (Apr 29), Lou Olsten said:
> I thought I had a handle on this, but now I'm all screwed up.
>
> MySQL 4.1.1a-alpha-max-debug-log
> Windows 2000 Server
>
> I'm trying to create a user roby with a password of 'foo' with access to everything.
> Here's what happens:
>
> - Sign i
Daniel Audette <[EMAIL PROTECTED]> wrote:
>
> I would like to create a user that can create databases and do all the
> necessary changes to it(select, insert, update, delete...), view all
> database that he has been granted to see by other users except the
> mysql.* I have created 1 user with the
Perhaps he really intended to revoke all privs, but he had a syntax
error. In that case, to revoke all rights for the mysql db from a
particular user ([EMAIL PROTECTED] for example), you would issue
REVOKE ALL ON mysql.* FROM [EMAIL PROTECTED]
Daniel was missing the '.*' after mysql, which c
Hello Daniel,
Try with: revoke show databases on mysql.* from [EMAIL PROTECTED];
If the user [EMAIL PROTECTED] issue "show databases" il will not see anymore
the databases "mysql".
The revoke you were trying was not only on showing the database mysql but
revoke all the privilege, is is really
John,
Thursday, October 31, 2002, 11:49:08 PM, you wrote:
JM> How do I create users for a specific database using SQL?
Take a look at GRANT statement:
http://www.mysql.com/doc/en/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsore
> Create the record for the user in the user table (do not forget to do
> password=PASSWORD('pastext'))
> Then insert a record in the db table with the db name you want them to
> access and the options.
Or you could use:
GRANT SELECT, UPDATE, INSERT, DELETE ON somedb.* TO someuser@localhost
IDENT
Create the record for the user in the user table (do not forget to do
password=PASSWORD('pastext'))
Then insert a record in the db table with the db name you want them to
access and the options.
HTH.
JFernand
** sql **
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com
It's all right here => http://www.mysql.com/manual.php
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Sent: Thursday, October 31, 2002 1:49 PM
To: [EMAIL PROTECTED]
Subject: Creating users through SQL
How do I create users for a specific database using SQL?
-
look for 'GRANT SYNTAX' in the manual.
Regards
M
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 13:16
To: MySql List
Subject: creating users ??? I must be blind.
Hi,
the manual referes to creating users using mysqladmin and mysqlaccess, I
have
16 matches
Mail list logo
