N/APosted on - 10/15/2013
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
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;