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]
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]
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]