En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

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?

  • User-6575273
    il y a un an

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

Sujets
CalculBase de données
Balises
Amazon LightsailBase de donnéesMySQL
Langue
English
User-6575273
demandé il y a un an407 vues
1 réponse
0

You need to provide a hostname in that command.

mysql --host ${HOST} --user test_dba --port 3306 -p
AWS
MODÉRATEUR
philaws
répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents