I tried to install on my free GCP VM compute but when run rails db:schema:load

return error:

-- create_table("abilities", {:options=>"ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci", :force=>:cascade})
rails aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: Unknown collation: 'utf8mb4_0900_ai_ci': CREATE TABLE `abilities` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `community_id` bigint, `name` varchar(255), `description` text, `internal_id` varchar(255), `icon` varchar(255), `post_score_threshold` decimal(10,8), `edit_score_threshold` decimal(10,8), `flag_score_threshold` decimal(10,8), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `summary` text,  INDEX `index_abilities_on_community_id`  (`community_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

It was worked fine on my Mac OS, what's wrong with my ubuntu?

Maybe I need to install/activate utf8mb4_0900_ai_ci, but how to do it? I cant find any resource about install it, just suggestion to change it to utf8mb4_general_ci

My software specification:

• Ubuntu 18.04
• mysql 5.7.32-0ubuntu0.18.04.1-log
• Ruby 2.6.6
• gem 3.0.3
• rails 5.2.4.4
• rbenv 1.0.0

posted over 3 years ago

CC BY-SA 4.0

3y ago

Yaskur‭

56 reputation 3 0 11 6