Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users

Dashboard
Notifications
Mark all as read
Q&A

unable to create databases in Ruby

+2
−1

I had installed Ruby.

rvm install 2.6.6

I had Ruby which version was 3.0.0. I had removed it. Then, installed 2.6.6. When I try

bundle install

I got no error. When I tried following commands in Terminal. Then, I got some error.

rails db:create
rails db:schema:load
rails r db/scripts/create_tags_path_view.rb
rails db:migrate
Traceback (most recent call last):
	4: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/ruby_executable_hooks:22:in `<main>'
	3: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/ruby_executable_hooks:22:in `eval'
	2: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/rails:23:in `<main>'
	1: from /home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/site_ruby/2.6.0/rubygems.rb:303:in `activate_bin_path'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/site_ruby/2.6.0/rubygems.rb:284:in `find_spec_for_exe': can't find gem railties (>= 0.a) with executable rails (Gem::GemNotFoundException)
Traceback (most recent call last):
	4: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/ruby_executable_hooks:22:in `<main>'
	3: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/ruby_executable_hooks:22:in `eval'
	2: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/rails:23:in `<main>'
	1: from /home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/site_ruby/2.6.0/rubygems.rb:303:in `activate_bin_path'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/site_ruby/2.6.0/rubygems.rb:284:in `find_spec_for_exe': can't find gem railties (>= 0.a) with executable rails (Gem::GemNotFoundException)
Traceback (most recent call last):
	4: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/ruby_executable_hooks:22:in `<main>'
	3: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/ruby_executable_hooks:22:in `eval'
	2: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/rails:23:in `<main>'
	1: from /home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/site_ruby/2.6.0/rubygems.rb:303:in `activate_bin_path'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/site_ruby/2.6.0/rubygems.rb:284:in `find_spec_for_exe': can't find gem railties (>= 0.a) with executable rails (Gem::GemNotFoundException)
Traceback (most recent call last):
	4: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/ruby_executable_hooks:22:in `<main>'
	3: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/ruby_executable_hooks:22:in `eval'
	2: from /home/istiak/.rvm/gems/ruby-2.6.6/bin/rails:23:in `<main>'
	1: from /home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/site_ruby/2.6.0/rubygems.rb:303:in `activate_bin_path'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/site_ruby/2.6.0/rubygems.rb:284:in `find_spec_for_exe': can't find gem railties (>= 0.a) with executable rails (Gem::GemNotFoundException)

Currently, I have the directory /home/istiak/.local/share/gem/ruby/3.0.0/. Not 2.6.6. I had installed Ruby the way I wrote at first. Unfortunately, I couldn't access Ruby. That's why I had to install Ruby again.

sudo pacman -Sy ruby

I was using 2.6.6 following way.

/bin/bash --login
rvm use 2.6.6 --default

Here's the process

When I tried

bundle exec rails db:create

I got some error.

** Invoke db:create (first_time)
** Invoke db:load_config (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:load_config
** Execute db:create
Access denied for user 'root'@'localhost'
Couldn't create 'qpixel_dev' database. Please check your configuration.
rails aborted!
Mysql2::Error: Access denied for user 'root'@'localhost'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:90:in `connect'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:90:in `initialize'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:22:in `new'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:22:in `mysql2_connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:830:in `new_connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:874:in `checkout_new_connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:853:in `try_to_checkout_new_connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:814:in `acquire_connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:538:in `checkout'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:382:in `connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:1033:in `retrieve_connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_handling.rb:118:in `retrieve_connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/connection_handling.rb:90:in `connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/tasks/mysql_database_tasks.rb:6:in `connection'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/tasks/mysql_database_tasks.rb:14:in `create'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/tasks/database_tasks.rb:119:in `create'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/tasks/database_tasks.rb:139:in `block in create_current'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/tasks/database_tasks.rb:316:in `block in each_current_configuration'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/tasks/database_tasks.rb:313:in `each'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/tasks/database_tasks.rb:313:in `each_current_configuration'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/tasks/database_tasks.rb:138:in `create_current'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/activerecord-5.2.6/lib/active_record/railties/databases.rake:29:in `block (2 levels) in <top (required)>'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/task.rb:281:in `block in execute'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/task.rb:281:in `each'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/task.rb:281:in `execute'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/task.rb:199:in `invoke_with_call_chain'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/task.rb:188:in `invoke'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/application.rb:160:in `invoke_task'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/application.rb:116:in `each'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/application.rb:116:in `block in top_level'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/application.rb:125:in `run_with_threads'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/application.rb:110:in `top_level'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/railties-5.2.6/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/rake-13.0.3/lib/rake/application.rb:186:in `standard_exception_handling'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/railties-5.2.6/lib/rails/commands/rake/rake_command.rb:20:in `perform'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/railties-5.2.6/lib/rails/command.rb:48:in `invoke'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/railties-5.2.6/lib/rails/commands.rb:18:in `<top (required)>'
/home/istiak/qpixel/bin/rails:9:in `require'
/home/istiak/qpixel/bin/rails:9:in `<top (required)>'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/spring-2.1.1/lib/spring/client/rails.rb:28:in `load'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/spring-2.1.1/lib/spring/client/rails.rb:28:in `call'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/spring-2.1.1/lib/spring/client/command.rb:7:in `call'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/spring-2.1.1/lib/spring/client.rb:30:in `run'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/spring-2.1.1/bin/spring:49:in `<top (required)>'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/spring-2.1.1/lib/spring/binstub.rb:11:in `load'
/home/istiak/.rvm/rubies/ruby-2.6.6/lib/ruby/gems/2.6.0/gems/spring-2.1.1/lib/spring/binstub.rb:11:in `<top (required)>'
/home/istiak/qpixel/bin/spring:13:in `require'
/home/istiak/qpixel/bin/spring:13:in `<top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Tasks: TOP => db:create

When I tried to Setting up the database

mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.5.10-MariaDB Arch Linux

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE USER [email protected] IDENTIFIED BY '123456';
ERROR 1396 (HY000): Operation CREATE USER failed for 'qpixel'@'localhost'
MariaDB [(none)]> GRANT ALL ON qpixel_dev.* TO [email protected];
Query OK, 0 rows affected (0.014 sec)

MariaDB [(none)]> GRANT ALL ON qpixel_test.* TO [email protected];
Query OK, 0 rows affected (0.007 sec)

MariaDB [(none)]> GRANT ALL ON qpixel.* TO [email protected];
Query OK, 0 rows affected (0.018 sec)

I am actually unable to create user for qpixel. But, I could create user any other way. Why? How to create user for qpixel?

[istiak-4291zfv config]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.5.10-MariaDB Arch Linux

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE USER [email protected] IDENTIFIED BY '123';
Query OK, 0 rows affected (0.057 sec)

MariaDB [(none)]> CREATE USER [email protected] IDENTIFIED BY 'root';
ERROR 1396 (HY000): Operation CREATE USER failed for 'qpixel'@'localhost'
MariaDB [(none)]> CREATE USER [email protected] IDENTIFIED BY '123';
ERROR 1396 (HY000): Operation CREATE USER failed for 'qpixel'@'localhost'
Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

1 comment thread

General comments (5 comments)

0 answers

Sign up to answer this question »