SQL Error 1133 Cannot find any matching row

Asked By george wwilliam 0 points N/A Posted on - 10/15/2013

Hi.

I received an error from the User manager as shown in the image below. I was trying to create a new user account on SQL database server. Any remedies?

SQL Error 1133. Cant find any matching row in the user table

• Status: Open
• Question Views: 885
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Salazar Chaidez -10 points N/A #176754

SQL Error 1133 Cannot find any matching row

 There are 3 solutions to fix this problem:-

1 > Download latest version if you're facing problem suing HeidiSQL.

2 > Change SQL_MODE if you cannot change your current tool or SQL statement syntax anyhow. You should either set it for SESSION if you want to fix it.

C) Use SQL similar to :-

---

CREATE USER 'digitss'@'localhost' IDENTIFIED BY 'digitss';

GRANT EXECUTE, PROCESS, SELECT, SHOW DATABASES, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, CREATE USER, FILE, LOCK TABLES, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHUTDOWN, SUPER ON *.* TO 'digitss'@'localhost' WITH GRANT OPTION;

---

 

About Salazar Chaidez

Questions
0

Answers
53

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 10/17/2013
• Question Category: MySQL Server