How to access MySQL from command line

June 4, 2016 452 views
MySQL WordPress Linux Commands Ubuntu

I am pretty new to command line, so I think I am simply not understanding something. I set up a one-click install of WordPress on my droplet and then logged in to root@mydropletsipaddress successfully. I wanted to mess around with MySQL so I can learn more about how command line and SQL works, but I can't figure out how to do it. I tried doing mysql -v and it doesn't come up with anything. Do I have to be in a certain directory to give mysql commands? Is MySQL actually not installed?

Any ELI5-level clarification would be greatly appreciated as I am brand new to this.

Thank you!

1 Answer

mysql -u mysql_username -p

Then you should be prompted for a password. That's it.

Have another answer? Share your knowledge.