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?

how to connect to the command line of mysql

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

Connected PhpMyAdmin through a tunnelled PuTTY and uploaded my data which looks good.
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?

User-6575273
1 年前
Sorry to waste time, found the solution, log in with root and bitnami password!

主题

计算数据库

标签

Amazon Lightsail 数据库 MySQL

语言

English

User-6575273

已提问 1 年前408 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

You need to provide a hostname in that command.

mysql --host ${HOST} --user test_dba --port 3306 -p

审核人员

philaws

已回答 1 年前

how to connect to the command line of mysql

相关内容