how to connect to the command line of mysql

0

I have set up a new instance in Lightsail with Debian 11 LAMP stack,

  1. Connected PhpMyAdmin through a tunnelled PuTTY and uploaded my data which looks good.
  2. Connected with FIleZilla and uploaded some php which works, and need to connect to the MySql with command line.

I have used mysql -u bitnami -p with password in the PuTTY command line and get ERROR 1045 (28000): Access denied for user 'bitnami'@'localhost' (using password: YES).
I have tried all the passwords I have used with this and am getting nowhere, not sure what i am missing. Can anyone help please?

  • Sorry to waste time, found the solution, log in with root and bitnami password!

질문됨 일 년 전369회 조회
1개 답변
0

You need to provide a hostname in that command.

mysql --host ${HOST} --user test_dba --port 3306 -p
AWS
중재자
philaws
답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠