Languages

Login to MySQL from cmd on Linux

1 points
Asked by:
Teilsa
795

How can I connect with command line to MySQL on Linux?

1 answer
2 points
Answered by:
Teilsa
795

Quick solution, just enter: 

mysql -u root -p

It will ask you for password. In case you want to login on any other user, instead of 'root' use other user name.

Example:

If we want to enter password in the same line:

mysql -u root -proot

Parameter -p is connected with our password in this case the password is root.

When we use MySQL or MariaDB for tests on localhost or VM's we use root or admin as a password, for convenience when the security is not so importnat. 

Example:

0 comments Add comment
Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Join to our subscribers to be up to date with content, news and offers.
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join