workbench - w3toppers.com

Errno 121, duplicate key on write or update?

This is likely because you have named at least one constraint with the same identifier as a column: /* You already have a column named `restaurant` in this table, but are naming the FK CONSTRAINT `restaurant` also… */ CONSTRAINT `restaurant` FOREIGN KEY (`restaurant` ) REFERENCES `mydb`.`restaurants` (`id` ) ON DELETE NO ACTION ON UPDATE NO … Read more

Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?

If you have that same problem in MySql 5.7.+ : Access denied for user ‘root’@’localhost’ it’s because MySql 5.7 by default allow to connect with socket, which means you just connect with sudo mysql. If you run sql : SELECT user,authentication_string,plugin,host FROM mysql.user; then you will see it : +——————+——————————————-+———————–+———–+ | user | authentication_string | … Read more