search

apetkau / orthomcl-pipeline

Automates running of OrthoMCL software from http://orthomcl.org/common/downloads/software/v2.0/
80 stars 36 forks source link

Can't set up a new mysql user count #18

Closed xiao7462 closed 6 years ago

xiao7462 commented 6 years ago

When i type mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, CREATE VIEW, INDEX, DROP on *.* to orthomcl; by logging into the MySQL server as root i get ERROR 1133 (42000): Can't find any matching row in the user table

type flush privileges; doesn't work

apetkau commented 6 years ago

There is likely no orthomcl user set up in your database. You will have to run create user 'orthomcl'@'localhost' identified by 'password'; first - https://dev.mysql.com/doc/refman/8.0/en/create-user.html#create-user-overview