How can we hide any column in mysql table

Discussion in 'Website Development & Design' started by manishsqrt, Jun 7, 2015.

  1. manishsqrt

    manishsqrt
    uix_expand uix_collapse
    Member

    Joined:
    Apr 13, 2015
    Messages:
    120
    Likes Received:
    7
    I want to know is there any method to hide a column in mysql table.Such as password column.I don't want even admins to know what the password of any user is, so is there any menthod by which we can encrypt it.Only mysql systax should work with them but no human can read it.Please suggest such method.
     
  2. Sotaru

    Sotaru
    uix_expand uix_collapse
    Member

    Joined:
    Jun 5, 2015
    Messages:
    30
    Likes Received:
    1
    Depends on how you're viewing the tables. I don't believe theres a way to do it in PHPMyAdmin.

    A fix that I did for this in the past was to keep passwords on a seperate table only accessible by myself.
     

Share This Page