Login question
Per the MySQL documentation I used the following commands to establish login both at the local host and remotely. mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd'); mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd'); When I attempt the following locally from the Command Prompt (with Win2K, SP4 administrator privileges), mysql -u root -p , I am prompted for the password. Yet, when I enter the password set above, I receive the following error message. ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Argh... your help is appreciated. Respectfully, ASP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login question
aspsa wrote: Per the MySQL documentation I used the following commands to establish login both at the local host and remotely. mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd'); mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd'); When I attempt the following locally from the Command Prompt (with Win2K, SP4 administrator privileges), mysql -u root -p , I am prompted for the password. Yet, when I enter the password set above, I receive the following error message. ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) because you are root, not '' Argh... your help is appreciated. Respectfully, ASP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login question
Try SET PASSWORD FOR 'root'@'localhost' = PASSWORD( 'newpwd' ); SET PASSWORD FOR 'root'@'%' = PASSWORD( 'newpwd' ); There was no username in your SET PASSWORD command. Wes On Jul 30, 2004, at 4:38 PM, aspsa wrote: Per the MySQL documentation I used the following commands to establish login both at the local host and remotely. mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd'); mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd'); When I attempt the following locally from the Command Prompt (with Win2K, SP4 administrator privileges), mysql -u root -p , I am prompted for the password. Yet, when I enter the password set above, I receive the following error message. ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Argh... your help is appreciated. Respectfully, ASP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login question
after you ran your command, did you: mysql flush privileges; ? Per the MySQL documentation I used the following commands to establish login both at the local host and remotely. mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd'); mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd'); When I attempt the following locally from the Command Prompt (with Win2K, SP4 administrator privileges), mysql -u root -p , I am prompted for the password. Yet, when I enter the password set above, I receive the following error message. ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Argh... your help is appreciated. Respectfully, ASP -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login question
aspsa wrote: Per the MySQL documentation I used the following commands to establish login both at the local host and remotely. mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd'); mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd'); Here, you set the password for the anonymous users, ''@localhost and ''@%. (You are probably better off deleting the anonymous user, by the way.) When I attempt the following locally from the Command Prompt (with Win2K, SP4 administrator privileges), mysql -u root -p And here, you try to log in as [EMAIL PROTECTED] See the problem? [EMAIL PROTECTED] is not ''@localhost. , I am prompted for the password. Yet, when I enter the password set above, I receive the following error message. ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED] doesn't have a password yet. You need to mysqladmin -u root password newpwd where newpwd is the password you want for root. After setting the password for [EMAIL PROTECTED], you can connect with mysql -u root -p I'd suggest that [EMAIL PROTECTED] is a bad idea, so I'd DELETE FROM mysql.user WHERE user='root' AND host='%'; FLUSH PRIVILEGES; but if you want it, you should definitely set a password for it as well. In that case, SET PASSWORD FOR [EMAIL PROTECTED] = PASSWORD('newpwd'); Argh... your help is appreciated. Respectfully, ASP Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login question
FLUSH PRIVILEGES is not necessary after SET PASSWORD or GRANT. You only need to FLUSH PRIVILEGES when you edit the mysql tables directly (INSERT, UPDATE, DELETE). Michael Michael Dykman wrote: after you ran your command, did you: mysql flush privileges; ? Per the MySQL documentation I used the following commands to establish login both at the local host and remotely. mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd'); mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd'); When I attempt the following locally from the Command Prompt (with Win2K, SP4 administrator privileges), mysql -u root -p , I am prompted for the password. Yet, when I enter the password set above, I receive the following error message. ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Argh... your help is appreciated. Respectfully, ASP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login question
[EMAIL PROTECTED] doesn't have a password yet. You need to mysqladmin -u root password newpwd where newpwd is the password you want for root. After setting the password for [EMAIL PROTECTED], you can connect with mysql -u root -p I'd suggest that [EMAIL PROTECTED] is a bad idea, so I'd DELETE FROM mysql.user WHERE user='root' AND host='%'; FLUSH PRIVILEGES; but if you want it, you should definitely set a password for it as well. In that case, Being new to MySQL admin stuff, it would seem to me that you would lose all sorts of valuable capabiltiies if you delete the root user from the MySQL table? -- Whil Moving to Linux: Freedom, Choice, Security, Opportunity http://www.hentzenwerke.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Login question
In mysql, a user is a combination of user and hostname. Initially, there are 2 superusers, [EMAIL PROTECTED] and [EMAIL PROTECTED] They have the same privileges, but they are different users. [EMAIL PROTECTED] is for connections via unix socket (from the same machine on which the mysql server is running). [EMAIL PROTECTED] is for tcp/ip connections. As % is a wildcard, [EMAIL PROTECTED] can log into mysql from any machine in the world. Not a good idea! If you must allow superuser connections from other machines, you are better off limiting the allowed hosts as much as possible. Replace [EMAIL PROTECTED] with [EMAIL PROTECTED], for example, where xxx.yy.zz is your subnet. See the manual for details: http://dev.mysql.com/doc/mysql/en/Privileges.html http://dev.mysql.com/doc/mysql/en/GRANT.html Michael Whil Hentzen wrote: [EMAIL PROTECTED] doesn't have a password yet. You need to mysqladmin -u root password newpwd where newpwd is the password you want for root. After setting the password for [EMAIL PROTECTED], you can connect with mysql -u root -p I'd suggest that [EMAIL PROTECTED] is a bad idea, so I'd DELETE FROM mysql.user WHERE user='root' AND host='%'; FLUSH PRIVILEGES; but if you want it, you should definitely set a password for it as well. In that case, Being new to MySQL admin stuff, it would seem to me that you would lose all sorts of valuable capabiltiies if you delete the root user from the MySQL table? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
command line login question
Hi, I am trying to create a script that automatically logs in to mysql and chooses a db then runs a query. I can login fine when doing it this way: mysql -u user -p it then asks for a pass and it works. but if I try this: mysql -u user -ppassword dbname I get an access error. any suggestions? Thanks, Chuck -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: command line login question
On Fri, Feb 06, 2004 at 05:06:08PM -0600, Chuck Barnett wrote: Hi, I am trying to create a script that automatically logs in to mysql and chooses a db then runs a query. I can login fine when doing it this way: mysql -u user -p it then asks for a pass and it works. but if I try this: mysql -u user -ppassword dbname I get an access error. any suggestions? I'd guess the user doesn't have permissions for that dbname. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 145 days, processed 1,515,422,676 queries (120/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
login question
I was wondering if anyone knows of a way to make a mysql server running on red hat linux authenticate using nt pass through (something like samba does it) or possibly ldap. I am new to mysql so this may be very easy to do I just don't know how. It also might be impossible. Just wondering if anyone had any ideas. Eddie __ This email transmission and any documents, files or previous email messages attached to it may contain information that is confidential or legally privileged. If you are not the intended recipient or a person responsible for delivering this transmission to the intended recipient, you are hereby notified that you must not read this transmission and that any disclosure, copying, printing, distribution or use of this transmission is strictly prohibited. If you have received this transmission in error, please immediately notify the sender by telephone or return email and delete the original transmission and its attachments without reading or saving in any manner. __ - 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
Re: mysql login question
Can you login to mysql from a perl script by passing it an encrypted password..? Taylor... Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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