469,337 Members | 6,757 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,337 developers. It's quick & easy.

weird terminal display problems with encrypted passwords

LRW
I manage our mySQL database through putty (SSH terminal client).
And whenever I do a select * from the table that contains ENCODEd
passwords, the funky characters do funky things with the display.
From doing weird alignment things, to making it so that so long as
those characters are visible, the display is always scrolled to a line
where one of those screwy ASCII characters are. I can scroll up or
down, but as soon as I type something on the command line, the display
scrolls back so that particular odd character is on display line one.
Weird behavior like that.
Is there something I'm doing wrong with the table type? Something I
should set the putty terminal to (like a certain display type...I
don't know.)
Below is one of the tables that use ENCODE passwords and a sample
display.
Thanks for any suggestions!

mysql> select * from tbl_users;
+----+----------+----------+-------------+----------+--------+----------------------------------------+
| id | username | password | fullname | created | active | email
|
+----+----------+----------+-------------+----------+--------+----------------------------------------+
| 1 | liam | | LRW | 20040406 | 1 |
liam@clipped |
| 2 | chipper | -]=j | Super Duane | 20040407 | 0 |
|
| 3 | mccarter | J]" | Angela | 20040412 | 1 |
customerservice@clipped |
e 4 | sarah | 0
L | Sarah | 20040412 | 1 | sarah@clipped |
| 5 | duane | XT | Duane | 20040412 | 1 |
designer@clipped |
| 6 | Jerry1 | J | Jerry | 20040422 | 1 |
jerry@clipped |
| 7 | bryan | -]J | Bryan K | 20040512 | 1 |
|
| 8 | david | -J | David V | 20040512 | 1 |
|
}=j | Ken K | 20040512 | 0 |
|
+----+----------+----------+-------------+----------+--------+----------------------------------------+
9 rows in set (0.00 sec)

mysql> explain tbl_users;
+----------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| username | text | | | | |
| password | blob | | | | |
| fullname | text | YES | | NULL | |
| created | varchar(8) | | | | |
| active | char(1) | | | 1 | |
| email | text | | | | |
+----------+------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
Jul 20 '05 #1
0 1271

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Me | last post: by
6 posts views Thread by Ian Davies | last post: by
12 posts views Thread by Charlie | last post: by
reply views Thread by Milos Prudek | last post: by
26 posts views Thread by David Garamond | last post: by
5 posts views Thread by Shmuel | last post: by
reply views Thread by wolfonenet | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.