Friday, 15 January 2010

database - MySQL version 5.6.23 not allowing me to create a new user/grant privileges -


It seems that I am having this problem because I was playing with drop function and drop database mysql and test. .. i think i have to reset mysql to default. What is the best way to do this? Instructions do not work for me

---- My basic question ---

I am trying to create a new user and try to give them access to my database But I'm getting a syntax error. I can not see any syntax with which I am entering. I am using MySQL version 5.6.23.

There is a screenshot of this problem: Enter image details here

< P> Here I have the command that is entered in MySQL:

  Allow all the authorizations on simple_cms_development. * Mypassword12345 identified 'simple_cms' @' localhost ';';  

Error 1064 (42000): There is an error in your SQL syntax;

You are using the wrong type of quote character, these words are often found in documents in quotes. Most likely are pasted and pasted in a website or similar way.

I would rewrite the query, but suggest using the bid (') key on your keyboard.

Instead of bending to the quotes at both ends, there is a single up and down line, in the same way you attach your password to the error message.


No comments:

Post a Comment