1
mysql --host 127.0.0.1 --port 23306 --user root -proot

I have no idea was -proot is and I cannot find it in any documentation.

I am following the following instructions on how to set up a docker container with my SQL: Connect to mysql in a docker container from the host

Ivar
  • 6,138
  • 12
  • 49
  • 61
chargingBrontosaurus
  • 31
  • 7

1 Answers1

2

The password used is actually root.

It's the same as:

mysql --host 127.0.0.1 --port 23306 --user root --password=root

Tasos P.
  • 3,994
  • 2
  • 21
  • 41
  • Why TF is there nothing in the documentation, where did you come up with this? This has got to be one of the least documented databases to date, I dont know why anyone uses it. – chargingBrontosaurus Sep 20 '21 at 14:50
  • 1
    @chargingBrontosaurus it **is** described in the mysql cli documentation: https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html#option_mysql_password – Shadow Sep 20 '21 at 16:18
  • @Shadow no its not, Ctrl-F and try to find 'proot' – chargingBrontosaurus Sep 20 '21 at 20:45
  • @chargingBrontosaurus you cannot seriously expect a documentation to list all possible passwords, can you? – Shadow Sep 20 '21 at 22:31