ユーザー登録で「300円クーポン」プレゼント!まずは無料登録から!
募集をシェアしてメンターを探そう
シェア
エンジニア

mysqlのエラーを解消しているただける方募集しています。

4月14日
予算
〜 3,000円
提案数
2人が提案中

アプリ開発中にrails sをした際にhttp://localhost:3000に接続するとActiveRecord::ConnectionNotEstablished
Access denied for user 'root'@'localhost' (using password: YES)のエラーが発生。

エラーの解消するため検索していろいろな方法を試すが解消できず。
% mysql -u root -p00000
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
% mysql -u root -p4211
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
% mysql -u root -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
% mysql -u root -pbook-list
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
% mysql -u root -pbook_list
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
% systemctl stop mysqld
zsh: command not found: systemctl
% systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
zsh: command not found: systemctl
% systemctl start mysqld
zsh: command not found: systemctl
% systemctl stop mysql
zsh: command not found: systemctl
% systemctl restart mysql
zsh: command not found: systemctl
% service --status-all | grep mysql
zsh: command not found: service
% service mysql stop
zsh: command not found: service
% sudo service mysql stop

メンティーに提案してみましょう
募集をシェアしてメンターを探そう
シェア