I need a solution :
18:33:10 CREATE TABLE payment_methods
( payment_method_id
tinyint(4) NOT NULL AUTO_INCREMENT, name
varchar(50) NOT NULL, PRIMARY KEY (payment_method_id
) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Error Code: 1273. Unknown collation: ‘utf8mb4_0900_ai_ci’ 0.000 sec
Your MySQL server is probably too old. You can see the version in MySQL Workbench via Server/Status. Mosh uses version 8.0.15.
I actually solved it by deleting an extra line he added for some reason.