Login question

2004-07-30 Thread aspsa
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

Re: Login question

2004-07-30 Thread gerald_clark
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

Re: Login question

2004-07-30 Thread Wesley Furgiuele
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

Re: Login question

2004-07-30 Thread Michael Dykman
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');

Re: Login question

2004-07-30 Thread Michael Stassen
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,

Re: Login question

2004-07-30 Thread Michael Stassen
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

Re: Login question

2004-07-30 Thread Whil Hentzen
[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

Re: Login question

2004-07-30 Thread Michael Stassen
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

command line login question

2004-02-06 Thread Chuck Barnett
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

Re: command line login question

2004-02-06 Thread Jeremy Zawodny
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:

login question

2002-07-03 Thread Eddie Willett
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

Re: mysql login question

2002-05-16 Thread Taylor Lewick
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.