Re: MySQL refusing to accept passwords

"Shawn Green (MySQL)" pisze: (...) > You can be the correct > user, using the correct password but you may not be allowed (by the host > pattern) to login from the machine from which you are attempting to login. > It could be the case you got your account setup as username@localhost and it

Re: MySQL refusing to accept passwords

s well as MySQL 5.5.13. I've begun digging through bugs.mysql.com, but I'm not seeing any standing out. I should point out that this problem also breaks any sites running on this dev laptop as all passwords are no longer accepted. Any thoughts on what may be causing this? It seems to be happe

Re: MySQL refusing to accept passwords

- Original Message - > From: "Tim Thorburn" > > Before this, I did try to simply reset the root password by once > again stopping the MySQL service, starting it with --skip-grant-tables; > however regardless of what I changed the password to, I received the > same error. This error was p

Re: MySQL refusing to accept passwords

egun digging through bugs.mysql.com, but I'm not seeing any standing out. I should point out that this problem also breaks any sites running on this dev laptop as all passwords are no longer accepted. Any thoughts on what may be causing this? It seems to be happening every month or so at this point.

Re: MySQL refusing to accept passwords

Hi, I dont remember the details of the past 'experience' but, did you try a simple: mysql -uroot -p -h127.0.0.1 -P3306? and also an anomymous login: mysql also make sure you remove the anonymous account if present, sometimes it introduces strange behaviours as the one you described. and as su

Re: MySQL refusing to accept passwords

On 7/22/2011 17:02, Shawn Green (MySQL) wrote: ... quick correction ... * ...the account 'root' for a new installation is* created without a password. ... I originally said 'is not'. Sorry for the confusion -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware

Re: MySQL refusing to accept passwords

eeing any standing out. I should point out that this problem also breaks any sites running on this dev laptop as all passwords are no longer accepted. Any thoughts on what may be causing this? It seems to be happening every month or so at this point. Thanks in advance, -Tim Thorburn * Check your

Re: MySQL refusing to accept passwords

- Original Message - > From: "Tim Thorburn" > > For those keeping score, this will be the second time in the past few Yes, I remember that. You wouldn't happen to have a known-good backup around, to verify if the password has indeed changed in the authentication tables? -- Bier met gr

MySQL refusing to accept passwords

hould point out that this problem also breaks any sites running on this dev laptop as all passwords are no longer accepted. Any thoughts on what may be causing this? It seems to be happening every month or so at this point. Thanks in advance, -Tim Thorburn

Prevent user from changing passwords?

I have been looking high and low but am having trouble finding good info. I need to try to lock down mysql with strong passwords password expiry yadda yadda. I've looked at securich and am not sure I want to use it. All I really want is to prevent users from be able to change

Re: Record old passwords ?

ise changes own password if current user is not root. can change the password up to 11times in 1 day and stores the last 5 passwords which were not changed for at least 24hrs. Does not permit the new password to be the same as any of the old passwords. Resets update count if more than 24hrs passed fro

Re: Record old passwords ?

Hi Thanks for all the responses. In the end I opted for a separate UserPasswords table, which records all old passwords. When a user changes their password, this table is checked. NB All passwords are stored in SHA256. Thanks again for your advice. Regards Neil On Wed, Jan 20, 2010 at 12:08

RE: Record old passwords ?

As an auditor once told me, "If you can do your job, then I'm not doing my job." Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -- MySQL General Mailing List For list ar

Re: Record old passwords ?

, the user can manipulate this by changing the password four times and then resetting back to there original password. How would I overcome this problem ? Any thoughts or recommendations ? Store the date/time that the password was changed, and as well as not alllowing one within the past four pas

Re: Record old passwords ?

hange of passwords, and cannot see almost no real life application (unless perhaps one is a spy) which really require this degree of security ! The real life application most commonly encountered where this is necessary is where your organisation wishes to process credit card or other financial

Re: Record old passwords ?

uld I overcome this problem ? Any thoughts or recommendations ? Probably if your users do that, it means they (rightfully) consider A DAMN NUISANCE the fact to be compelled to change password. Abandon the idea. I share their feeling about forcing this change of passwords, and cannot see almo

Re: Record old passwords ?

On Wednesday 20 January 2010 01:10, Daevid Vincent wrote: > > -Original Message- > > From: John Meyer [mailto:john.l.me...@gmail.com] > > Sent: Monday, January 18, 2010 5:04 PM > > To: co...@obviouslymalicious.com; mysql@lists.mysql.com > > Sub

RE: Record old passwords ?

> -Original Message- > From: John Meyer [mailto:john.l.me...@gmail.com] > Sent: Monday, January 18, 2010 5:04 PM > To: co...@obviouslymalicious.com; mysql@lists.mysql.com > Subject: Re: Record old passwords ? > > Although, on an OT, forcing people to not use a pass

Re: Record old passwords ?

On 19/01/2010 09:14, Tompkins Neil wrote: I think I will go with the four additional column approach as I proposed (in the current table) - since this need is a PCI compliancy security requirement. Do you have a reference for that? Storing past passwords as additional fields like that is

Re: Record old passwords ?

anging the password four times and then resetting back to there original password. How would I overcome this problem ? Any thoughts or recommendations ? Store the date/time that the password was changed, and as well as not alllowing one within the past four passwords you can also disallow one that was

Re: Record old passwords ?

original >> password. How would I overcome this problem ? Any thoughts or >> recommendations ? >> >> Cheers >> Neil >> >> On Tue, Jan 19, 2010 at 9:14 AM, Tompkins Neil < >> neil.tompk...@googlemail.com >> > wrote: >> >> >

Re: Record old passwords ?

ng back to there original password. How would I overcome this problem ? Any thoughts or recommendations ? Cheers Neil On Tue, Jan 19, 2010 at 9:14 AM, Tompkins Neil wrote: > Hi > > Thanks for all the replies. For your information, we are going to store > passwords using SHA256. I th

Re: Record old passwords ?

Hi Thanks for all the replies. For your information, we are going to store passwords using SHA256. I think I will go with the four additional column approach as I proposed (in the current table) - since this need is a PCI compliancy security requirement. I can then pull all the data with one

Re: Record old passwords ?

f the last four passwords he/she has used. I was thinking of create four fields called Password1, Password2, Password3 and Password4 to record the old passwords. Is this a preferred method - or does anyone else have any recommendations ? Thanks, Neil I'm not an awesome database desi

Re: Record old passwords ?

last four passwords he/she has used. I was thinking of create four fields called Password1, Password2, Password3 and Password4 to record the old passwords. Is this a preferred method - or does anyone else have any recommendations ? Thanks, Neil I'm not an awesome database designer, most

Re: Record old passwords ?

On January 18, 2010 01:34:15 pm Tompkins Neil wrote: > Hi > > I'm in the process of designing a login system to a secure web page using > MySQL. One of the features is we need to record and ensure that the user > password is different from any of the last four passwords he/sh

Re: Record old passwords ?

/customer decides to up the requirement to six passwords, it will be a simple app change. / Carsten Tompkins Neil skrev: Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is diff

Re: Record old passwords ?

I'm still pretty new on the list, so take it easy on me if I'm way off base. But I think you'd be better off with a table just for old passwords. I think you could get by with four columns: id(primary key), user_id, old_pw, change_date. It should make your validation query a

Record old passwords ?

Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is different from any of the last four passwords he/she has used. I was thinking of create four fields called Password1, Pass

Re: Passwords not working

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 ad

RE: Passwords not working

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

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

Re: Passwords not working

em 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 it. > > /var/log/mysql.log doesn't give me any useful in

Passwords not working

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 it. /var/log/mysql.log doesn't give me any useful information.

Re: restoring mysql db doesn't restore user passwords

you're a genius! I had old_passwords=1 in my.cnf, changed it to 0, restarted mysql, and then the users worked like a charm. thanks! Little, Timothy wrote: My theory would be that it's an OLD-PASSWORDS issue. It would seem that you might have used the old_passwords=1 in you

RE: restoring mysql db doesn't restore user passwords

My theory would be that it's an OLD-PASSWORDS issue. It would seem that you might have used the old_passwords=1 in your original configuration my.cnf but it's not in your new configuration file. -Original Message- From: Adam Williams [mailto:awill...@mdah.state.ms.us] Se

restoring mysql db doesn't restore user passwords

have their password set from the dump file, but they can't log in with what their password was either. Any ideas on how to get the passwords restored? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: viewing passwords as root

At 12:49 PM -0400 4/17/08, Pam Astor wrote: Hi, Is there a way to view mysql user passwords once logged in as the MySQL root user in v 5.0.22? Or are they encrypted even from the MySQL toot user? It's one-way encryption. You cannot see them. http://dev.mysql.com/doc/refman/5

viewing passwords as root

Hi, Is there a way to view mysql user passwords once logged in as the MySQL root user in v 5.0.22? Or are they encrypted even from the MySQL toot user? _ More immediate than e-mail? Get instant access with Windows Live Messenger

Re: Blank users/passwords

To: Sent: Monday, December 10, 2007 4:51 PM Subject: Blank users/passwords I'm a new MySQL DBA taking over admin duties for an existing MySQL nonclustered 4.1 installation. It has 6 small user databases. So in the mysql database, I run the query Select host, user, password from user;

Re: Blank users/passwords

Garris, Nicole wrote: > I'm a new MySQL DBA taking over admin duties for an existing MySQL > nonclustered 4.1 installation. It has 6 small user databases. So in the > mysql database, I run the query > > Select host, user, password from user; > > Which returns the following: > > > > +-

Re: Blank users/passwords

to log in from localhost, but > a password has been specified? > > 4. Line 10 above: User "one-user" can be used to log in from IP address > y with a blank password? Blank password means "no password." Blank username means "anonymous user." I would get

Blank users/passwords

I'm a new MySQL DBA taking over admin duties for an existing MySQL nonclustered 4.1 installation. It has 6 small user databases. So in the mysql database, I run the query Select host, user, password from user; Which returns the following: +-+-+-

RE: Passwords in Mysql5.x

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

RE: Passwords in Mysql5.x

MySQL, Inc > -Original Message- > From: Shivaji S [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 06, 2006 1:30 PM > To: mysql@lists.mysql.com > Subject: Passwords in Mysql5.x > > > Hi, > > what type of password algorithum does mysql 5.x uses for > e

Passwords in Mysql5.x

Hi, what type of password algorithum does mysql 5.x uses for encrypting passwords? and how does these algorithum keeps the password in secure. Regards, Shivaji.

Re: Logging (wrong) passwords by mysqld

Manuel Schmitt (manitu) wrote: Hi, I'am searching for a way to have mysqld log all passwords which clients are using ("trying") while connecting. As to the documentation and to my trials neither the error log nor the general query log contain passwords, only the usernames. I a

Re: Logging (wrong) passwords by mysqld

I believe Daniel is correct. The passwords are hashed before leaving the client. You may be able to capture invalid hashes but they are already encrypted before they get to the server. I do not know of any event or callback function you can use to tie into the server to trigger a logging event

Re: Logging (wrong) passwords by mysqld

On 3/5/06, Manuel Schmitt (manitu) <[EMAIL PROTECTED]> wrote: > > is there a reason that the unknown passwords can't simply be reset? > > yes, because not all clients are currently known and resetting them > would possibly break the application(s) I am not pretty s

Re: Logging (wrong) passwords by mysqld

> is there a reason that the unknown passwords can't simply be reset? yes, because not all clients are currently known and resetting them would possibly break the application(s) -- Manuel Schmitt - Geschäf

Re: Logging (wrong) passwords by mysqld

> having an application log actual passwords (whether the login was > successful or not) is a major security risk, hence no self-respecting, > security-conscious application will do this. all that should be logged > is the username attempted, along with a login success/failure > in

Logging (wrong) passwords by mysqld

Hi, I'am searching for a way to have mysqld log all passwords which clients are using ("trying") while connecting. As to the documentation and to my trials neither the error log nor the general query log contain passwords, only the usernames. I already tried to get them via eth

Re: one user, multiple passwords

At 12:00 -0600 1/14/06, Fletcher Mattox wrote: Hi, Is it possible for one user to have more than one password; one for each database? My naive attempt at this was No. An "account" in MySQL is defined the by combination of username and hostname that you specify after the TO in the grant statem

one user, multiple passwords

Hi, Is it possible for one user to have more than one password; one for each database? My naive attempt at this was GRANT ALL ON db1.* TO 'fletcher'@'%' IDENTIFIED BY pass1 GRANT ALL ON db2.* TO 'fletcher'@'%' IDENTIFIED BY pass2 But I find that pass2 replaces pass1 on db1 when

Re: How to select on passwords?

Gobi wrote: I was using MySQL 4.1 and have a Users table where I store the UserID and the corresponding password using the following: Insert into Users (UserID, Password) values ('someid', password(somepw)); and when people login, I would query using: Select * from Users where UserID = 'some

How to select on passwords?

I was using MySQL 4.1 and have a Users table where I store the UserID and the corresponding password using the following: Insert into Users (UserID, Password) values ('someid', password(somepw)); and when people login, I would query using: Select * from Users where UserID = 'someid' and Passwo

Re: Merging two tables which contain passwords with different encryption methods [SOLVED]

u never saw the plain text password, it would have to get to that stage in order to be put through the MD5 algorithm). Okay, that makes the situation very clear. I now understand that MySQL can not manipulate encrypted passwords for the purpose of changing encryption methods. While this is not

Re: Merging two tables which contain passwords with different encryption methods

Dave wrote: [snip] I believe I will need to use the new password hashing algorithm, because using the old one would require me to reconfigure the PHP code for the forum, which would be a level of complexity beyond my capabilities. So I now understand that I can not decrypt the passwords

Re: Merging two tables which contain passwords with different encryption methods

It did change between MySQL 3.2 and 4.1. You need the old-passwords configuration directive, it is in the MySQL manual at dev.mysql.com. Thank you. I believe the old-passwords configuration has already been set by my web host. You can't decrypt the password fields. That's th

Re: Merging two tables which contain passwords with different encryption methods

the database was upgraded. I seem to remember at the time of upgrading that some setting was required in order for the passwords to continue to work. My web hosting service was kind enough to handle this issue for me, but unfortunately this means that I am not entirely clear on what kinds of

Merging two tables which contain passwords with different encryption methods

r data was created in an earlier version of MySQL, and later the database was upgraded. I seem to remember at the time of upgrading that some setting was required in order for the passwords to continue to work. My web hosting service was kind enough to handle this issue for me, but unfortunately

Re: Storing manually diggested Passwords with MD5

C.F. Scheidecker Antunes wrote: I will have the password stored in the database with MD5. What I actually need is a manual way to get the password back, that is decoding it. The whole point of MD5 is that you cannot decode it once encoded. When someone enters their password, just MD5 what th

Re: Storing manually diggested Passwords with MD5

C.F. Scheidecker Antunes wrote: I am sorry. I meant another thing and wrote something else. If I issue: INSERT INTO table1 values ('username',MD5('password')) I will have the password stored in the database with MD5. What I actually need is a manual way to get the password back, that is dec

Re: Storing manually diggested Passwords with MD5

I am sorry. I meant another thing and wrote something else. If I issue: INSERT INTO table1 values ('username',MD5('password')) I will have the password stored in the database with MD5. What I actually need is a manual way to get the password back, that is decoding it. By using a software th

RE: Storing manually diggested Passwords with MD5

@lists.mysql.com > Subject: Storing manually diggested Passwords with MD5 > > Hello all, > > Is there any function that I could use on a SQL statement to store a > password on a table manually using an algorithm like MD5? > > Thanks, > > C.F. > > -- > MySQL G

Storing manually diggested Passwords with MD5

Hello all, Is there any function that I could use on a SQL statement to store a password on a table manually using an algorithm like MD5? Thanks, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql "forgets" user passwords

Chris Fonnesbeck wrote: On 7/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote: Hmmm... In that case, I have more questions. Log in as root and run SHOW VARIABLES LIKE '%pass%'; DESC user password; and post the results. Also, was this a brand new installation, or an upgrade? If an up

Re: mysql "forgets" user passwords

On 7/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote: > > Hmmm... In that case, I have more questions. Log in as root and run > >SHOW VARIABLES LIKE '%pass%'; >DESC user password; > > and post the results. > > Also, was this a brand new installation, or an upgrade? If an upgrade, f

Re: mysql "forgets" user passwords

Please keep this on the list. Chris Fonnesbeck wrote: Something seems rather screwed up; I was starting from scratch by revoking all privileges from joe and deleting him. I got the following: mysql> REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'localhost'; Query OK, 0 rows affected (0.00 sec) mys

Re: mysql "forgets" user passwords

It's always a good idea to keep the thread on the list. That way, more people can help solve the problem, and others may benefit from the answers. Chris Fonnesbeck wrote: Here is what happens: mysql> GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY 'testing'; Query OK, 0 rows affected (

Re: mysql "forgets" user passwords

Chris Fonnesbeck wrote: Issuing the grant command yields an error: mysql> GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD 'testing'; ERROR 1105 (HY000): Password hash should be a 41-digit hexadecimal number That's my fault. That should have been GRANT ALL ON test.* TO [EM

Re: mysql "forgets" user passwords

Issuing the grant command yields an error: mysql> GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD 'testing'; ERROR 1105 (HY000): Password hash should be a 41-digit hexadecimal number Also, I tried deleting and re-creating the 'chris' user, and the same problems arose. However, I

Re: mysql "forgets" user passwords

Chris Fonnesbeck wrote: Sorry. While I am able to log in, I get the following: | GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY PASSWORD '*446CB892D3DFFDDC86BDDF26E4EB43158356DF64' WITH GRANT OPTION | This is a new, 4.1+, 41 byte password hash. after a restart, I get | GR

Re: mysql "forgets" user passwords

Sorry. While I am able to log in, I get the following: | GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY PASSWORD '*446CB892D3DFFDDC86BDDF26E4EB43158356DF64' WITH GRANT OPTION | after a restart, I get | GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY PASSWORD '3

Re: mysql "forgets" user passwords

Chris Fonnesbeck wrote: Here is the startup script: The grant command was: grant all on *.* to [EMAIL PROTECTED] identified by 'my_password'; Thanks for the help, C. Chris, You only answered one of my questions. I'm hoping to narrow the problem by determining whether the problem is on t

Re: mysql "forgets" user passwords

On 7/14/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > > > PASSWORD '3446cb892d3dffdd' WITH GRANT OPTION | > > > > You're using passwords in old format. Is it possible that problem > > somehow related to this. Are you connect

Re: mysql "forgets" user passwords

Hello. > PASSWORD '3446cb892d3dffdd' WITH GRANT OPTION | You're using passwords in old format. Is it possible that problem somehow related to this. Are you connecting using mysql command line client? What version it is? Chris Fonnesbeck <[EMAIL PROTECTED]> wr

Re: mysql "forgets" user passwords

Here is the startup script: #!/bin/sh # # /Library/StartupItems/MySQLCOM/MySQLCOM # # A script to automatically start up MySQL on system bootup # for Mac OS X. This is actually just a wrapper script around # the standard mysql.server init script, which is included in # the binary distribution. # #

Re: mysql "forgets" user passwords

Michael Stassen wrote: Danny Stolle wrote: Chris Fonnesbeck wrote: I have mysql 4.1.12 installed on OSX 10.4, and have run into the curious problem that mysql forgets my user password (but not my root password) when I restart the server. When I attempt to log in, I get: ERROR 1045 (28000): A

Re: mysql "forgets" user passwords

Tried that. I get the following: Oliver:~/Research/Right Whale chris$ mysql mysql -u root -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g.

Re: mysql "forgets" user passwords

On 7/14/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > > > > What does > > show grants for 'chris'@'localhost'; > > > reports when you're logged as root? > I get the following: | GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY PASSWORD '3446cb892d3dffdd' WIT

Re: mysql "forgets" user passwords

Hello. What does show grants for 'chris'@'localhost'; reports when you're logged as root? Chris Fonnesbeck <[EMAIL PROTECTED]> wrote: > I have mysql 4.1.12 installed on OSX 10.4, and have run into the > curious problem that mysql forgets my user password (but not my root > p

Re: mysql "forgets" user passwords

Danny Stolle wrote: Chris Fonnesbeck wrote: I have mysql 4.1.12 installed on OSX 10.4, and have run into the curious problem that mysql forgets my user password (but not my root password) when I restart the server. When I attempt to log in, I get: ERROR 1045 (28000): Access denied for user 'c

Re: mysql "forgets" user passwords

Chris Fonnesbeck wrote: I have mysql 4.1.12 installed on OSX 10.4, and have run into the curious problem that mysql forgets my user password (but not my root password) when I restart the server. When I attempt to log in, I get: ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (usin

mysql "forgets" user passwords

I have mysql 4.1.12 installed on OSX 10.4, and have run into the curious problem that mysql forgets my user password (but not my root password) when I restart the server. When I attempt to log in, I get: ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (using password: YES) Yet, whe

Re: Easy newbie question re: option file and passwords

On Fri, 28 Jan 2005 09:47:24 +0200, Gleb Paharenko wrote: > Hello. > > The mysql program uses user sebyte and password for user ddj. > When mysql starts it calls for load_defaults(), which put > the arguments from your config file before the command line options > that you specified. And than us

Re: Easy newbie question re: option file and passwords

-hlocalhost -uroot -px -hlocalhost -usebyte Sebastian Tennant <[EMAIL PROTECTED]> wrote: > Hi there, > > For some reason, despite entering my passwords in ~/.my.cnf, I still have > to enter a password on the command line to login to mysql. I have tried >

Easy newbie question re: option file and passwords

Hi there, For some reason, despite entering my passwords in ~/.my.cnf, I still have to enter a password on the command line to login to mysql. I have tried this with each of the accounts I have created and all return the same error: $ mysql -u sebyte ERROR 1045: Access denied for user: '[

Re: 4.1.7 has --old-passwords set but mysqladmin client still using new hash

Hello. I've reported a bug: http://bugs.mysql.com/7451 Jason Joines <[EMAIL PROTECTED]> wrote: >I've got a 4.1.7 server on Linux and I need to use the old-passwords > option. It has taken effect as 'show variables' confirms. Also, if I &g

4.1.7 has --old-passwords set but mysqladmin client still using new hash

I've got a 4.1.7 server on Linux and I need to use the old-passwords option. It has taken effect as 'show variables' confirms. Also, if I set a user's password using 'set password for user = password('apassword')' it honors the old-passwords op

Re: MySQL valid characters for passwords

the users in my database. My problem is what are valid characters for a password. I've tried using valid unix passwords and I can't log in. I'm trying a password like 'ab#CD*12'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

MySQL valid characters for passwords

I haven't been using MySQL very long, but I have managed to secure the users in my database. My problem is what are valid characters for a password. I've tried using valid unix passwords and I can't log in. I'm trying a password like 'ab#CD*12'. -- MySQL

mysql 4.1: how to use old-passwords in my.cnf

Hi, i'm testing 4.1.05, executed the mysql_fix_privilege_tables script but have to use "old clients (3.51.06)" to connect to mysql. For this reason I inserted the old-passwords parameter into my.cnf (I'm calling several mysql-daemons with different versions using a singl

Re: problems setting up the anonymous and root passwords

On Sep 20, 2004, at 00.06, FayeC SQL wrote: Hi, I have just finished installing MySQL, Apache and PHP on a Windows platform and have tested my Apache and PHP installations without problems. My issue now is that when I log in using just -u root I can get through but I just can't seem to be able to s

Re: problems setting up the anonymous and root passwords

Did you run mysql_install_db? Michael FayeC SQL wrote: Hi, I have just finished installing MySQL, Apache and PHP on a Windows platform and have tested my Apache and PHP installations without problems. My issue now is that when I log in us

problems setting up the anonymous and root passwords

Hi, I have just finished installing MySQL, Apache and PHP on a Windows platform and have tested my Apache and PHP installations without problems. My issue now is that when I log in using just -u root I can get through but I just can't seem to be able to set a password. It keeps giving me an error

MySQL user passwords and ColdFusion MX6.1

passwords. Killing these off, restarting with --old-passwords and redoing them as 16-char passwords allowed CF to register the DSNs. Hope this might help someone else who's going prematurely bald. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Auto Generation Of Passwords

aybe if they are all in the low range you can do (rand()*100+10) I bet someone says there is a function like randompassword() now :| -- Dave - Original Message - From: Michael Mason To: 'MySQL Mailing List' Sent: Tuesday, July 13, 2004 1:25 AM Subject: Auto Gen

Auto Generation Of Passwords

I was wondering if it's possible to create a field in a MySQL Databse that automatically creates unique field values for use as a password for example     Michael Mason Business Support Services Arras® People   Tel: 01706 342310 Mobile: 07793 782287 Fax: 01706 642754 Member of

Re: Short Passwords in 4.1.2

At 21:12 -0700 6/1/04, Greg Willits wrote: I'm trying to force 4.1.2 to use the old short passwords for now during some experimental stages. The discussion here (specifically the fourth set of bullets): http://dev.mysql.com/doc/mysql/en/Password_hashing.html and, this paragraph:

  1   2   3   >