creating DB and grant syntax error in mysql

Question

enter image description hereI'm beginner python code, and not good at english.

my laptop window 10 pro, python version 3.6 mysql commmunity server version 8.0.12

problem

headfirst python

this is the code

mysql -u root -p
mysql>create database vsearchlogDB;
mysql>grant all on vsearchlogDB.* to 'vsearch' identified by 'vsearchpasswd';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'vsearchpasswd'' at line 1

create user vsearchlogDB identified by 'vsearchpasswd'; not just create vsearchlogDB; — Mihai
– Mihai, Commented Oct 1, 2018 at 8:30

Matt · Accepted Answer · 2020-03-05 08:42:02Z

2

it should be grant all privileges, not just all the username should also have the host pointer like `vserach'@'%'

grant all privileges on vsearchlogDB.* to 'vsearch'@'%' identified by 'vsearchpasswd';

is more like it

EDIT: I'm blind and totally ignored the "8.0" part. On 8.0 this should look like:

create user 'vsearch'@'%' identified by 'vsearchpasswd';
grant all privileges on vsearchlogDB.* to 'vsearch'@'%'; //(Don't forget the ';')

edited Mar 5, 2020 at 8:42

Matt

33 bronze badges

answered Oct 1, 2018 at 8:28

Jan Myszkier

2,7541 gold badge18 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

최준석 Over a year ago

same error occurred ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'vsearchpasswd'' at line 1

user11675320 · Accepted Answer · 2019-06-20 09:53:01Z

1

Please try this code:

create user 'vsearch' identified by 'vsearchpasswd';

grant all on vsearchlogDB.* to vsearch;

answered Jun 20, 2019 at 9:53

user11675320

111 bronze badge

1 Comment

RalfFriedl Over a year ago

How is this better than the previous answer?

Collectives™ on Stack Overflow

creating DB and grant syntax error in mysql

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related