본문 바로가기
SQL

mysql Unknown column 'password' in 'field list'

by 자바초보자 2016. 5. 10.
728x90

I am trying to change MySql root password.

What I have done is below.

  1. Install MySql-5.7.6 ~ .dmg(Community Server) and workbench.
  2. Turn off the server on OSX System preferences.
  3. Access MySql with console. The command was mysqld_safe --skip-grant
  4. Execute update user set password=password('1111') where user='root'; and got an error message --> ERROR 1054 (42S22): Unknown column 'password' in 'field list'.

FYI, I did use mysql;. So I did select query on user table and found password column actually does not exist.

It is very weird. Is it possible that original user table does not have password column?

How can I change password, which does not exist?

Thanks for your answer :D

 

 

 

 

 

==>update user set authentication_string=password('1111') where user='root';

 

 

 

728x90

'SQL' 카테고리의 다른 글

기간중복체크 쿼리  (0) 2019.08.27
MySQL DB 생성/삭제 및 사용자 추가/삭제, 권한 부여  (0) 2016.05.16
MySQL 외부 접속 허용 설정  (0) 2016.05.05
테이블 백업  (0) 2016.04.29
oracle 한글 데이터 입력  (0) 2016.04.29