Hi,
This is a dumb newbie question, so please bear with me:) I'm trying to
connect to an existing database called 'billblac_recovery'.
I want the username to be 'billblac_bill' and the password to be 'wgb'. I'm
having no luck with the CLI
or MySQLAdministrator. I'm using MySQL 4.1, upgraded from 3.
;
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
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 PRIVILEGES ON *.* TO rob
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
Hello
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 grant method but he can see all
the tables and
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
Hello
I am new to mysql. What I want to do is give a user a right to create
databases with all rights but I do not want them to see the mysql
database I have tried the following
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
DENTIFIED BY 'some_pass' WITH GRANT OPTION;
then tried to revoke
r
At 8:55 -0700 7/8/03, Michael Iatauro wrote:
I took once moe a sharp look now that you did a reply with another
sample. Actually I was wrong the SQL statement was NOT correct -
you forgot the semicolon in the first exapmple ;-)
To my knowledge, the semicolon is unnecessary when using mysql --ex
2003年 7月 9日 水曜日 00:55、Michael Iatauro さんは書きました:
> > I took once moe a sharp look now that you did a reply with another
> > sample. Actually I was wrong the SQL statement was NOT correct - you
> > forgot the semicolon in the first exapmple ;-)
>
> To my knowledge, the semicolon is unnecessary when u
I took once moe a sharp look now that you did a reply with another sample.
Actually I was wrong the SQL statement was NOT correct - you forgot the
semicolon in the first exapmple ;-)
To my knowledge, the semicolon is unnecessary when using mysql --execute.
~Michael Iatauro
--
MySQL General Ma
Hi Michael;
I took once moe a sharp look now that you did a reply with another sample.
Actually I was wrong the SQL statement was NOT correct - you forgot the
semicolon in the first exapmple ;-)
'Y', 'Y', 'Y');\""
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 09:38、Michael I
Thanks for your reply, Nils.
and then I would like you to take a sharp look at whats left, then there
should perhaps be something with this part above. Perhaps the " at the very
end is not escaped correctly (double) or something similar. The actual SQL
statement works perfectly fine.
I thought
thing with this part above. Perhaps the " at the very
end is not escaped correctly (double) or something similar. The actual SQL
statement works perfectly fine.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 08:28、Michael Iatauro さんは書きました:
> I've been having a little trouble
I've been having a little trouble creating users cross-platform. I have
a little script that works just fine on Solaris 8 using this command:
eval "/path/to/mysql --user=root --password=*
--socket=/path/to/socket --database=mysql --execute=\"INSERT INTO user
(Host,
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
--
> From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
> Sent: October 31, 2002 16:49
> To: [EMAIL PROTECTED]
> Subject: Creating users through SQL
>
>
> How do I create users for a specific database using SQL?
--
meyer_1978@;yahoo.com]
Sent: October 31, 2002 16:49
To: [EMAIL PROTECTED]
Subject: Creating users through SQL
How do I create users for a specific database using SQL?
-
Before posting, please check:
http://www.mysql.com/manual.php (
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 u
How do I create users for a specific database using SQL?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[E
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 mysq
Hi,
the manual referes to creating users using mysqladmin and mysqlaccess, I
have looked at these commands and cannot see how I can create mysql users.
Am I missing something that is staring me in the face ?
Thanks,
Matt.
(slowing getting the hang of what is going on now
29 matches
Mail list logo
