Re: Login Problems
After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that the install of 4.0.6 would start fresh and create its defualt users and databases with no trace of the previous user entries. Schrodinger wrote: I have removed all localhost user entries and all users should now be able to connect from any host. But when a user attempts to connect with a password they get the usual ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) In an earlier message, you said you downgraded from mysql 4.1.? to 4.0.6 (Why not 4.0.16?). mysql 4.1 has a different password format in the user table than previous versions. Pre 4.1.x mysql uses 16 byte hashes to store passwords, 4.1.0 uses 45 byte hashes, and 4.1.1 (and up) uses 41 byte hashes. If you kept (or restored) the mysql user table you created in 4.1, you may now be comparing a 16 byte password hash to a 41 or 45 byte hash. As I understand it, the only way that could match is if both are blank. If this is the case for you, use GRANT to reset the passwords to new 16 byte hashes. See http://www.mysql.com/doc/en/Password_hashing.html for more. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
[snip] After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that the install of 4.0.6 would start fresh and create its defualt users and databases with no trace of the previous user entries. [/snip] Are you doing your grants from the command line or from a GUI? Have you done FLUSH PRIVILEGES? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
I created users using webmin and I have done FLUSH PRIVILEGES. [snip] After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that the install of 4.0.6 would start fresh and create its defualt users and databases with no trace of the previous user entries. [/snip] Are you doing your grants from the command line or from a GUI? Have you done FLUSH PRIVILEGES? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
[snip] I created users using webmin and I have done FLUSH PRIVILEGES. [/snip] Are you granting privileges based on 'localhost', '127.0.0.1', or somewhere else. Where are users logging in from? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
The users are being created with the privelages of being able to login from any host and they are logging in from the command line through their shell account. [snip] I created users using webmin and I have done FLUSH PRIVILEGES. [/snip] Are you granting privileges based on 'localhost', '127.0.0.1', or somewhere else. Where are users logging in from? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
[snip] The users are being created with the privelages of being able to login from any host and they are logging in from the command line through their shell account. [/snip] So they need to be '[EMAIL PROTECTED]' You gave this ... [snip] ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:YES) [/snip] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
Issue has been resolved. Thank you all. I dont know what went wrong but I think it was becuase when I was connecting as root I ran : mysql --user=root and not mysql --user=root mysql after I did this I created a user and now that user can connect with a password. Thank you all for your help and now a computer society's web site has been born. Regards, Conor. [snip] The users are being created with the privelages of being able to login from any host and they are logging in from the command line through their shell account. [/snip] So they need to be '[EMAIL PROTECTED]' You gave this ... [snip] ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:YES) [/snip] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
I am using the command line for grant operations, no flushing though Why are you using 4.0,6? any special reason? I am using a custom (i compiled myself) 4.0.16 Here is an example operation: TRY TO LOG WITHOUT PASS, ERROR [EMAIL PROTECTED] vmedina]$ mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) *** TRY TO LOG WITH PASSWORD, SUCCESS! [EMAIL PROTECTED] vmedina]$ mysql -u vmedina -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.16-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. ** CREATE A USER, NO FLUSH, LOGOUT mysql grant all privileges on *.* to test@'%' identified by '1234' with grant option; Query OK, 0 rows affected (0.00 sec) mysql exit Bye LOG INTO MYSQL USING THE NEW USER, PROVIDE PASS, SUCCESS [EMAIL PROTECTED] vmedina]$ mysql -u test -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 4.0.16-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql *** USE THE NEW USER TO CREATE *** A YET AGAIN A NEW USER, NO FLUSH [EMAIL PROTECTED] vmedina]$ mysql -u test -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 4.0.16-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql grant all privileges on *.* to test03@% identified by '1234' with grant option; Query OK, 0 rows affected (0.00 sec) mysql I've never used flush. I must say that the only user in that machine is a user called vmedina, that's me, 'cause it is my development workstation, as i told you i deleted ALL users after i created the vmedina user, simply because there is no need for others, vmedina user can handle all admin operations in a MySQL server, and create other users as needed. If you need anything else just let me know my friend :) Best Regards -- .. * _ _ __ __ .. * \ \ \ | | __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | || | / \|_| || www.superferreteria.com.ve * /_/_/ |__|_| /_/\_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Login Problems on 4.1
Hi guys! I am facing some problems trying to login user to the data base server using --any-- client(except the mysql cli) to the server. Users using no password does not seems to have any problems. It happens that when a client tries to log into the db server using passwords the server doesn't seems to authorize. Even the most recent MyCC client fails to autorize users using passwords. Do I need to compile the clients against the new server's library? The MyCC client was linked againts the 4.0.16 server. was there any change in the auth-protocol? Best Regards -- .. * _ _ __ __ .. * \ \ \ | | __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | || | / \|_| || www.superferreteria.com.ve * /_/_/ |__|_| /_/\_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Login Problems on 4.1
At 14:42 -0400 12/12/03, Victor Medina wrote: Hi guys! I am facing some problems trying to login user to the data base server using --any-- client(except the mysql cli) to the server. Users using no password does not seems to have any problems. It happens that when a client tries to log into the db server using passwords the server doesn't seems to authorize. Even the most recent MyCC client fails to autorize users using passwords. Do I need to compile the clients against the new server's library? The MyCC client was linked againts the 4.0.16 server. was there any change in the auth-protocol? Indeed there was. This is mentioned in the upgrading to 4.1 section in the manual. Some links you may want to check out: http://www.mysql.com/doc/en/Upgrading-from-4.0.html http://www.mysql.com/doc/en/Upgrading-grant-tables.html http://www.mysql.com/doc/en/Password_hashing.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Login Problems on 4.1
At 14:42 -0400 12/12/03, Victor Medina wrote: It happens that when a client tries to log into the db server using passwords the server doesn't seems to authorize. Even the most recent MyCC client fails to autorize users using passwords. Do I need to compile the clients against the new server's library? The MyCC client was linked againts the 4.0.16 server. was there any change in the auth-protocol? 4.1 changed the authentication code. You can tell mysqld to use the old authentication by starting it with the --old-passwords option (or add old-passwords to the [mysqld] group in my.cnf). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Login Problems
Does anyone know why MySQL would only be allowing users with null passwords to connect? It's a fresh install of the server after deinstalling 4.1-ALPHA and installing the production release of 4.0.6. Conor. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login Problems
By default mySQL comes with a set of users that are allowed to login locally without password. You should create a normal-superuser account, and delete all others, and use this user to administer the rest of the data base and use it to create all others accounts that you might need. To create a new full-blown account: grant all privileges on *.* to your_user@% identified by 'password' with grant option; Best Regards! -- .. * _ _ __ __ .. * \ \ \ | | __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | || | / \|_| || www.superferreteria.com.ve * /_/_/ |__|_| /_/\_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
I have already created extra user accounts and none of them can connect once a password has been set. -Original Message- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 18:45 To: Schrodinger Cc: 'MySQL General Lists' Subject: Re: Login Problems By default mySQL comes with a set of users that are allowed to login locally without password. You should create a normal-superuser account, and delete all others, and use this user to administer the rest of the data base and use it to create all others accounts that you might need. To create a new full-blown account: grant all privileges on *.* to your_user@% identified by 'password' with grant option; Best Regards! -- .. * _ _ __ __ .. * \ \ \ | | __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | || | / \|_| || www.superferreteria.com.ve * /_/_/ |__|_| /_/\_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
[snip] I have already created extra user accounts and none of them can connect once a password has been set. [/snip] Have you FLUSHED the privileges? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
Yes I have tried doing that but with no joy. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 18:59 To: Schrodinger; Victor Medina Cc: MySQL General Lists Subject: RE: Login Problems [snip] I have already created extra user accounts and none of them can connect once a password has been set. [/snip] Have you FLUSHED the privileges? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
I have removed all localhost user entries and all users should now be able to connect from any host. But when a user attempts to connect with a password they get the usual ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -Original Message- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 18:56 To: Schrodinger Subject: RE: Login Problems You should delete most others since there is one user identified by something like this [EMAIL PROTECTED] that won't let you connect using password. If you delete those users, you'll be able to connect without problem On Thu, 2003-12-11 at 14:55, Schrodinger wrote: I have already created extra user accounts and none of them can connect once a password has been set. -Original Message- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 18:45 To: Schrodinger Cc: 'MySQL General Lists' Subject: Re: Login Problems By default mySQL comes with a set of users that are allowed to login locally without password. You should create a normal-superuser account, and delete all others, and use this user to administer the rest of the data base and use it to create all others accounts that you might need. To create a new full-blown account: grant all privileges on *.* to your_user@% identified by 'password' with grant option; Best Regards! -- .. * _ _ __ __ .. * \ \ \ | | __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | || | / \|_| || www.superferreteria.com.ve * /_/_/ |__|_| /_/\_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice .. -- .. * _ _ __ __ .. * \ \ \ | | __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | || | / \|_| || www.superferreteria.com.ve * /_/_/ |__|_| /_/\_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login Problems
Schrodinger wrote: I have removed all localhost user entries and all users should now be able to connect from any host. But when a user attempts to connect with a password they get the usual ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) In an earlier message, you said you downgraded from mysql 4.1.? to 4.0.6 (Why not 4.0.16?). mysql 4.1 has a different password format in the user table than previous versions. Pre 4.1.x mysql uses 16 byte hashes to store passwords, 4.1.0 uses 45 byte hashes, and 4.1.1 (and up) uses 41 byte hashes. If you kept (or restored) the mysql user table you created in 4.1, you may now be comparing a 16 byte password hash to a 41 or 45 byte hash. As I understand it, the only way that could match is if both are blank. If this is the case for you, use GRANT to reset the passwords to new 16 byte hashes. See http://www.mysql.com/doc/en/Password_hashing.html for more. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Login Problems
Hello, I am experiencing a strange problem with a MySQL server on a FreeBSD machine here in college. The problem began after I de-installed the 4.1 ALPHA versions of both the client and the server, removed the /var/db/mysql/ directory so the install would start afresh and installed the 4.0.6 Production release, again of both the client and the server. But after I did that users can now only connect if their passwords are null. As soon as a user sets a password they receive he following message: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have tried reinstalling only to find the same problem. Can anyone please help with this as is it hindering the development of our new web site. Thank you in advance. Regards, Conor Quigley. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
Have you flushed priv's recently? -Original Message- From: Schrodinger [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: MySQL General Lists Subject: Login Problems Hello, I am experiencing a strange problem with a MySQL server on a FreeBSD machine here in college. The problem began after I de-installed the 4.1 ALPHA versions of both the client and the server, removed the /var/db/mysql/ directory so the install would start afresh and installed the 4.0.6 Production release, again of both the client and the server. But after I did that users can now only connect if their passwords are null. As soon as a user sets a password they receive he following message: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have tried reinstalling only to find the same problem. Can anyone please help with this as is it hindering the development of our new web site. Thank you in advance. Regards, Conor Quigley. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
No I haven't. How do I do that? -Original Message- From: Brian Duke [mailto:[EMAIL PROTECTED] Sent: 08 December 2003 20:07 To: 'Schrodinger'; 'MySQL General Lists' Subject: RE: Login Problems Have you flushed priv's recently? -Original Message- From: Schrodinger [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: MySQL General Lists Subject: Login Problems Hello, I am experiencing a strange problem with a MySQL server on a FreeBSD machine here in college. The problem began after I de-installed the 4.1 ALPHA versions of both the client and the server, removed the /var/db/mysql/ directory so the install would start afresh and installed the 4.0.6 Production release, again of both the client and the server. But after I did that users can now only connect if their passwords are null. As soon as a user sets a password they receive he following message: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have tried reinstalling only to find the same problem. Can anyone please help with this as is it hindering the development of our new web site. Thank you in advance. Regards, Conor Quigley. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [newbie] localhost login problems from MSW2k command line (solved)
Okay, I just found out what I was doing wrong. Having looked in the docs, but I'm sure this is documented behavior. MySQL 4.0.12, MSW2k. Here's what's puzzling me -- I set up a new user yesterday. I'm pretty sure I was able to connect as the user from the command line yesterday, before I shut my machine down and went home. I can't today. I have this user entry in my mysql.user table: | localhost | fromWeb | scrambled-password | N | ... ^^^ This was the evil beast. Apparently, user names can't have capitals in them and be accessed from the command line, even though they can be accessed that way from php's library. I'm assuming there's something in the command line interface which forces the user name to lower case. So I changed the user name to 'fromweb' in mysql.user and mysql.db, and now I have no problems. But I still wonder about this: It complains ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES). ... Second, why does it complain about the loopback when I said localhost on the command line? Could this have something to do with named pipes? Is localhost folded to the loopback? That seems it might be a little awkward. -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[newbie] localhost login problems from MSW2k command line
MySQL 4.0.12, MSW2k. Here's what's puzzling me -- I set up a new user yesterday. I'm pretty sure I was able to connect as the user from the command line yesterday, before I shut my machine down and went home. I can't today. I have this user entry in my mysql.user table: | localhost | fromWeb | scrambled-password | N | ... and this in mysql.db: | localhost | webtable | fromWeb | Y | Y | N | N | ... with all columns not listed set to 'N'. I can connect as fromWeb using the php MySQL functions and read the database without problems. (I can also connect as root from the MSW2k command line. Root has an entry for localhost and another for my TCP-IP numeric address, but I've disabled the password in the TCP-IP entry.) When I give mysql -h localhost -u fromWeb -p It complains ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES). I've tried copy/pasting the password from the php source, too, just to be sure. So I'm wondering a couple of things -- First, what should I be looking for as a cause of this behavior? Is it likely something I did while setting the user up, that I've forgotten about and just can't find in the manual today? Second, why does it complain about the loopback when I said localhost on the command line? Could this have something to do with named pipes? -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Login problems
Hi I'm Mere! I've just installed mysql for use of bugzilla.I was logging well all the time and suddenly my super user root can't access the databases especially mysql.In short root can't access mysql even if I'm using the password I use to login with.The surprise is that bugs as a user does login with password different from root's and too correctly can't access mysql. Hopw do I get the password restored and full access to mysql? Please help!! - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php