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?

Complete a 3 Question Survey and Earn a re:Post Badge

Help improve AWS Support Official channel in re:Post and share your experience - complete a quick three-question survey to earn a re:Post badge!

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
2 years ago
Sorry to waste time, found the solution, log in with root and bitnami password!

Topics

Compute Database

Relevant content

phpmyadmin access on Lightsail LAMP instance
DaveMaul
asked 6 years ago
while installation of wordpress bitnami ami in ec2 container we are unble to do ssh through putty also we cant able connect through ppk
ruchik
asked 9 months ago
I can't connect in database after create a new instance by snapshot in Lightsail Lamp Stack
Adriel Cavalcante
asked 7 months ago
Can't connect to MySQL db from Lightsail instance. MY-010055 warning in logs.
jeffbond
asked 3 years ago
How do I manually install a LAMP stack on my Lightsail instance?
AWS OFFICIALUpdated a year ago
How do use PuTTY or Filezilla to connect to my Lightsail instance if I lost the SSH key pair?
AWS OFFICIALUpdated a year ago
How do I install WordPress in a Lightsail instance instead of the WordPress blueprint that Bitnami provides?
AWS OFFICIALUpdated a year ago
How can I troubleshoot database connection errors on WordPress-based applications hosted in Lightsail?
AWS OFFICIALUpdated a year ago
Secure way to set up IPsec VPN between IBM Cloud and an AWS-managed VPN endpoint with static routing
EXPERT
Vinay Gugueoth
published 2 years ago
Efficiently way to use a dynamic BGP to create a VPN tunnel between AWS and Oracle Cloud Infrastructure
EXPERT
Vinay Gugueoth
published 2 years ago