[Gllug] [OT] MySQL experts?

[Jackson, Harry]

> -----Original Message-----
> From: Paul Brazier [mailto:pbrazier at cosmos-uk.co.uk]
> 
> Is there an entry in the password field for superuser in the 
> mysql.user
> table? It should be there in encrypted form.
> 
> I wonder if it's stopping you typing the password in plain text on the
> commandline or something?
> I vaguely remember having to do "mysql -u paul -p" and then 
> entering the
> password from a prompt.
> 

Doing the following after
mysql> CONNECT MYSQL;
mysql> SELECT * FROM USER;
+-----------+------------------------+------------------------------+
| Host      | User                 | Password                |
+-----------+------------------------+------------------------------+
| localhost | root                 | 703158de1de93c39  |
| %          | user                  | 66dfb2963aff059b    |
| localhost | COLT003600    | 703158de1de93c39  |
| localhost | user                 | 54d7a9f910bc4366  |
| localhost | hjackson          | 35cb0bd767c04fea  |
| localhost | god                  | 5c1fb21a20d15f82   |
+-----------+------------------------+------------------------------+


I normally connect like 

$> mysql -h localhost -u root -ppassword

with no spaces between -p and password

Harry


*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. 020 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug