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
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
--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
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
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
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
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
-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
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
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
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
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
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
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
14 matches
Mail list logo