Re: re: RE: password not working from command line

2003-04-04 Thread Egor Egorov
On Friday 04 April 2003 04:02, you wrote: > The logon now works after "DELETE FROM user WHERE user="" > > It's still crashing when a remote logon is attempted. The copy of the > modified my.cnf file is attached. What exactly OS do you use? What version of MySQL server do you use? Did oyu install

re: RE: password not working from command line

2003-04-03 Thread Egor Egorov
On Wednesday 02 April 2003 17:19, Eldon Ziegler wrote: > The contents of the user file are attached. The user name is testit and > there is no password. This is server version 3.23.52, the version that came > with the Red Hat 8 distribution. > > I entered mysql -utestit then USE mysql; and got > ER

RE: password not working from command line

2003-04-02 Thread Michael Shulman
--Original Message- From: Eldon Ziegler [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 3:56 AM To: Michael Shulman Subject: RE: password not working from command line Michael, The result of a SELECT * INTO OUTFILE FROM user is attached. Thanks Eldon At 02:53 pm 4/1/2003 -0800, you wr

RE: password not working from command line

2003-04-02 Thread Helge Moulding
Michael Shulman wrote, > Privilege changes (at least on Windows) don't seem to take effect until > either (a) the server is restarted, or (b) the server is instructed to > re-read its permissions tables. Fair enough. I did FLUSH PRIVILEGES whenever I changed the user table. It seemed to me that t

RE: password not working from command line

2003-04-02 Thread Eldon Ziegler
The contents of the user file are attached. The user name is testit and there is no password. This is server version 3.23.52, the version that came with the Red Hat 8 distribution. I entered mysql -utestit then USE mysql; and got ERROR 1044: Access denied for user: '@local host' to database 'mys

RE: password not working from command line

2003-04-01 Thread Michael Shulman
manipulate users or permissions. -ms -Original Message- From: Helge Moulding [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: password not working from command line Andy Eastham wrote: > Make sure you don't ente

RE: password not working from command line

2003-04-01 Thread Helge Moulding
Andy Eastham wrote: > Make sure you don't enter a space between -u and the username > and -p and the password ie mysql -uuser -ppassword Actually, that works for me, i.e. C:\Program Files\mysql40\bin>mysql -u root -p Enter password: * Welcome to the MySQL monitor. Commands end with ; or

Re: password not working from command line

2003-04-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eldon, et al -- ...and then Michael Shulman said... % % Or, you can use the alternate, more legible syntax: % % mysql --user=username --password=pass Or, better yet, you can use mysql -uusername -p [database] or mysql -user=username -p [dat

RE: password not working from command line

2003-04-01 Thread Michael Shulman
Or, you can use the alternate, more legible syntax: mysql --user=username --password=pass -ms -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:36 AM To: [EMAIL PROTECTED] Mysql. Com Subject: RE: password not working from command line

RE: password not working from command line

2003-04-01 Thread Andy Eastham
Eldon, Make sure you don't enter a space between -u and the username and -p and the password ie mysql -uuser -ppassword Andy > -Original Message- > From: Eldon Ziegler [mailto:[EMAIL PROTECTED] > Sent: 01 April 2003 16:15 > To: [EMAIL PROTECTED] > Subject: passw

password not working from command line

2003-04-01 Thread Eldon Ziegler
The password I entered in a GRANT statement isn't being accepted from the command line after entering mysql -u username -p and then entering the password from the GRANT statement. Is there something else I need to do? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Password not working.

2001-09-14 Thread Dave McNicholl
Yup. amazingly enough the password entry in the user table was empty. I have no idea how this was empty. I am the only admin on the machine and I didn't do it. mysqladmin Ver 7.11 Distrib 3.22.22, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.22.22 Protocol ve

Re: Password not working.

2001-09-14 Thread Adams, Bill TQO
Dave McNicholl wrote: > Hi, > I have had a mysql database for a few years now. It is used for auth > against apache using mod_auth_mysql. My apache conf has the username and > password in it. These have not changed for some time. > Now when I use mysqldump -u username -p mysql and

Password not working.

2001-09-14 Thread Dave McNicholl
Hi, I have had a mysql database for a few years now. It is used for auth against apache using mod_auth_mysql. My apache conf has the username and password in it. These have not changed for some time. Now when I use mysqldump -u username -p mysql and supply the correct password I