On Mon, Oct 19, 2009 at 07:45:11PM -0400, Michael Dykman wrote:
> The type of password instability you are talking about is pretty much
> unheard of in MySQL..
Yeah, well, I can have a real black thumb for this sort of thing :-)
I'm sure I read about at least two different ways to add passwords.
Oct 2009 16:48:36 -0700
> From: listm...@websage.ca
> To: mysql@lists.mysql.com
> Subject: Re: Passwords not working
>
> On Mon, 19 Oct 2009 16:30:47 -0700
> John Oliver wrote:
>
> > I have a problem with MySQL passwords... I set them, write them
> > down
On Mon, 19 Oct 2009 16:30:47 -0700
John Oliver wrote:
> I have a problem with MySQL passwords... I set them, write them
> down... and they stop working. I have to go in and manually reset
> them.
>
> Right now, I have a database that, even after resetting the password,
> I still cannot access i
The type of password instability you are talking about is pretty much
unheard of in MySQL.. however, reverse DNS resolution is always
messing up depending on the network setup. From a console on your
database host, how easily can you resolve the hostnames that your
client is presenting? What is
[snip]
what type of password algorithum does mysql 5.x uses for encrypting
passwords? and how does these algorithum keeps the password in secure.
[/snip]
Here is some helpful info;
http://www.mysql.com/search/?q=password+security&charset=
--
MySQL General Mailing List
For list archives: http://
Hello,
Have you taken a look at the following sections in the manual?
http://dev.mysql.com/doc/refman/5.0/en/user-names.html
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
Thanks,
Jimmy Guerrero
Sr Product Manager
My
At 8:24 -0700 5/21/04, Ron Gilbert wrote:
When you connect to a MySQL server remotely (from the C API, in my
case), is your MySQL password sent in clear text?
No.
I've looked but I can find an answer to this question in the
docs...maybe I'm missing it.
http://dev.mysql.com/doc/mysql/en/Security_a
Got it thanks - "set-variable=old-passwords=1" in the ini file
-Original Message-
From: Randy Chrismon [mailto:[EMAIL PROTECTED]
Sent: 31 January 2004 21:11
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: Re: Passwords and ODBC - what am I missing
Oh, and one other thing, you have to create the passwords AFTER you use
the switch! That was probably obvious to you but it took me a while to
figure out.
Randy
Randy Chrismon wrote:
Ken Brown wrote:
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root and no
Ken Brown wrote:
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root and no password
But if I set a password on root or create a user with a password odbc fails
with
"Client does not support authentication protocol requested by the server -
consider upgrading M
I've did some more checking - I cannot set passwords anywhere (that is if I
want to connect with the account)
There are no logs as to why its not working.
I can only presume 4.1.1 is in the middle of a security overhaul and that's
why its now working here but perhaps someone could advise otherwis
these are definitely MySQL connection identities. Each with specific
(different) privileges. You can connect to the database directly with these.
- Original Message -
From: "Matthew Stuart" <[EMAIL PROTECTED]>
To: "MySQL email support" <[EMAIL PROTECTED]>
Sent: Monday, January 12, 2004 6:
These look like the security permissions for 3 MySQL user entries. The first one is
the administrator account which can do pretty much anything. The second looks like an
account used by a program. The third looks like it can be given to individual users as
it can only looks at records, not chan
On Wed, 3 Sep 2003 00:14:42 -0300
"Fernando (BOL)" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Can anyone tell me which function have more security/encryption?
> PASSWORD( ) ?
> ENCODE( ) ?
> MD5( ) ?
Please, read http://www.mysql.com/doc/en/Miscellaneous_functions.html
PASSWORD & MD5 are realizations
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LOL
You could skip the "make test" part...
;-P
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQE/GmBzmk7m2JX6ki4RArT8AJ0TIXkdJtdLnp8ZX1QX9dAyhrKVSACgo4Q3
BU5O9jhdfBp5nIh/zShajrI=
=zUaW
-END PGP SIGNATURE-
--
MySQL Ge
Jeremy Booker wrote:
>I installed the current stable release of MySQL from RPMs. I used the
client
>and server packages.
>
>After installing the server package, the RPM printed a note saying I
should
>run two commands. I only got the first one, which was
># ./mysqladmin -u root --password
>I ass
IL PROTECTED]>
To: "Jeremy Booker" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 20, 2003 1:31 AM
Subject: Re: passwords & DBI/DBD
> when you connect you connect to a running daemon
>
> try running
> mysqld beforehand
>
> -Martin
> ---
when you connect you connect to a running daemon
try running
mysqld beforehand
-Martin
- Original Message -
From: "Jeremy Booker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 19, 2003 7:12 PM
Subject: passwords & DBI/DBD
> I installed the current stable release of My
Renán,
> I installed the version 4.1.0-alpha of mysql in
> Windows XP. At the beginning and in general everything
> works very well. But I have a problem of
> incompatibility (I guess). When users are created with
> passwords, those users cannot be connected. Mysql
> says: "Client don't support th
Howdy All!
I encountered a 1045 error myself and in searching Google found this thread
from March 2003. I am not sure if it was solved, so, for the record, here is
what I did to solve it.
I tried logging into mysql as default with just this command:
mysql --local-infile -h localhost
I then trie
for windows. Is this a
myth
> >or is there WORKING source example out there somewhere?
> >Thanks,
> >Martin
> >- Original Message -
> >From: "Michael Shulman" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]&g
>- Original Message -
>From: "Michael Shulman" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Monday, March 31, 2003 9:24 AM
>Subject: RE: Passwords don't work in a WinME installation?
>
>
>Start reading here:
&g
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Helge Moulding wrote:
[snip]
|
| 10 further investigation shows that these users have all privileges
| mysql> select * from user;
|
+---+--+--+-+-+-+-+-+---+
ssage -
From: "Helge Moulding" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 01, 2003 1:02 PM
Subject: Re: Passwords don't work in a WinME installation?
Thanks to C. Reeve and Michael Shulman for their answers. However, if
the things that are doc
Thanks to C. Reeve and Michael Shulman for their answers. However, if
the things that are documented worked, then I might not be complaining.
I tried some of the stuff you suggested, and eventually managed to
solidly lock myself out of mysql, with no further access to anything!
Arghh!
Note that m
Original Message -
> From: "Martin Gainty" <[EMAIL PROTECTED]>
> To: "Michael Shulman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Monday, March 31, 2003 8:45 AM
> Subject: Re: Passwords don't work in a WinM
AIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 8:45 AM
Subject: Re: Passwords don't work in a WinME installation?
Michael et al-
I am trying to locate ONE working MySQL example for windows. Is this a myth
or is there WORKING source example out
PROTECTED]>
Sent: Monday, March 31, 2003 9:24 AM
Subject: RE: Passwords don't work in a WinME installation?
Start reading here:
http://www.mysql.com/doc/en/Privileges.html
and read to 4.2.10.
Two tips I found useful:
1. The current_user() function tells you what MySQL user name it thinks
Great!
any links to working examples would be greatly appreciated!
Thanks!
Martin
- Original Message -
From: "Michael Shulman" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, Ma
Start reading here:
http://www.mysql.com/doc/en/Privileges.html
and read to 4.2.10.
Two tips I found useful:
1. The current_user() function tells you what MySQL user name it thinks that
you are. This can be used to verify if you are an authenticated user.
mysql> SELECT current_user();
2. Remove
Amy,
Tuesday, May 21, 2002, 5:25:10 PM, you wrote:
>> I read the MySQL manual on how to set passwords but i'm a little confused.
>> How can i remove privileges so that you cant log on anonymously?
Anonymous user - a user that is defined as '' (empty string) in table
"user".
So, if you want to
> Hello~
>
> I read the MySQL manual on how to set passwords but i'm a little confused.
> How can i remove privileges so that you cant log on anonymously?
> Thanks.
> Amy
>
-
Before posting, please check:
http://www.mysql
32 matches
Mail list logo
