How to get into the mysql console?

Question

MySQL

Question from the series I know the world ...

I want to get into the mysql console - I
registered the address cd c:\xampp\mysql\bin\mysql.exe
hit .. no logins or passwords ..
show databases\g
shows only information schema ..
if doing something like mysql -u dk -p 4332 -h localhost;
swears at error 42000...

Answer 1

Probably in your case you need something like this:
And it gives an error because you are trying to use command line parameters in the mysql console, where you need to use SQL syntax.
The password must be specified without a space after the -p switch , otherwise a password request will be issued, after which there will be an attempt to connect to the 4332 database.

Answer 2

I may be wrong
error 42000 is the command syntax incorrect?
and if so, then the parameter assumes that after it the value will be written
after you, after -p (indicates that you need to enter the password for the user dk ) there are numbers
+ you must specify the full path to mysql.exe

Answer 3

dk-web try to see the answers to the question How can I access the MySQL command line with XAMPP...