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 serv

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 id

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

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, ''@loc

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

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

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 Pro

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 Wi

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

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?

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 any

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