Skip to content

MySQL access error #36

Open
Open
@bennyzr

Description

@bennyzr

The script generates errors when trying to access MySQL.

At the step:
Okay to drop all existing databases named rails-devise-pundit? 'No' will abort immediately! (y/n) y

run bundle exec rake db:drop from "."
[Simple Form] Simple Form is not configured in the application and will use the default values. Use rails generate simple_form:install to generate the Simple Form configuration.
rake aborted!
Mysql2::Error: Access denied for user 'rails-devise-pundit'@'localhost' (using password: NO)
/home/benny/.rbenv/versions/2.3.1/bin/bundle:22:in load' /home/benny/.rbenv/versions/2.3.1/bin/bundle:22:in

'
Tasks: TOP => db:drop => db:check_protected_environments
(See full trace by running task with --trace)
run bundle exec rake db:create:all from "."
Access denied for user 'rails-devise-pundit'@'localhost' (using password: NO)Please provide the root password for your MySQL installation


Mysql2::Error: No database selected: GRANT ALL PRIVILEGES ON rails-devise-pundit_development.* TO 'rails-devise-pundit'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;
Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "reconnect"=>false, "database"=>"rails-devise-pundit_development", "pool"=>5, "username"=>"rails-devise-pundit", "password"=>nil, "host"=>"localhost"}
rake aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: No database selected: GRANT ALL PRIVILEGES ON rails-devise-pundit_development.* TO 'rails-devise-pundit'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;
/home/benny/.rbenv/versions/2.3.1/bin/bundle:22:in load' /home/benny/.rbenv/versions/2.3.1/bin/bundle:22:in

'
Mysql2::Error: No database selected
/home/benny/.rbenv/versions/2.3.1/bin/bundle:22:in load' /home/benny/.rbenv/versions/2.3.1/bin/bundle:22:in '
Mysql2::Error: Access denied for user 'rails-devise-pundit'@'localhost' (using password: NO)
/home/benny/.rbenv/versions/2.3.1/bin/bundle:22:in load' /home/benny/.rbenv/versions/2.3.1/bin/bundle:22:in '
Tasks: TOP => db:create:all
(See full trace by running task with --trace)

All subsequent commands to the database fail as well.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions