SQL Error 1133 Cannot find any matching row

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #176754

SQL Error 1133 Cannot find any matching row

qa-featured

 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;


 

Login/Register to Answer

Related Questions