0

I'll say hello to the senior developers first.

Excuse my poor English.

Development Environment : ubuntu 16.04.1 - MYSQL 5.7.21

I used the following query.

SELECT COUNT(*) 
from user_info 
where user_id= 'myid' and user_pw=PASSWORD('mypassword');

There is no problem with operation, but the following warnings are given.

I checked the warning and it said it was a syntax error.

I think it is a query that is not problematic at all, but I wonder why it sends a warning.

Please remind me if you know any senior developers.

p.s I attach a picture just in case.

enter image description here

Improve this question
2
  • stackoverflow.com/a/1751262/3179169. It says don't use PASSWORD function. Commented Apr 20, 2018 at 17:39
  • 1
    See PASSWORD() :: 5.7: This function is deprecated as of MySQL 5.7.6 and will be removed in a future MySQL release. and PASSWORD() :: 8.0: This function was removed in MySQL 8.0.11., that causes the warning. The error is caused by the syntax problem (show warning\g), not by the PASSWORD function. Commented Apr 20, 2018 at 18:04
Related questions
17
MySQL password function
0
can't pull info form database that uses PASSWORD() function
9
correct syntax for setting password using mysql 5.5.8 command line
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.