How to connect to MySQL from the command line

by

See here http://dev.mysql.com/doc/refman/5.0/en/connecting.html

mysql -u USERNAME -pPASSWORD -h HOSTNAMEORIP DATABASENAME

The options above means:

-u: username
-p: password (**no space between -p and the password text**)
-h: host
last one is name of the database that you wanted to connect.

Look into the link, it’s detailed there!

As already mentioned by Rick, you can avoid passing the password as the part of the command by not passing the password like this:

mysql -u USERNAME -h HOSTNAMEORIP DATABASENAME -p

People editing this answer: PLEASE DONOT ADD A SPACE between -p and PASSWORD

More Related Contents:

  1. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. Throw an error preventing a table update in a MySQL trigger
  5. Do different databases use different name quote?
  6. Is there a MySQL option/feature to track history of changes to records?
  7. Adding a leading zero to some values in column in MySQL
  8. View’s SELECT contains a subquery in the FROM clause
  9. How to run SQL script in MySQL?
  10. MySQL : Multiple row as comma separated single row
  11. Check for x consecutive days – given timestamps in database
  12. MySQL Insert Into from one Database in another
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  15. How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]
  16. Dump a mysql database to a plaintext (CSV) backup from the command line
  17. Export a MySQL Database to SQLite Database
  18. How do I show the schema of a table in a MySQL database?
  19. How to find out the MySQL root password
  20. Remote connect to clearDB heroku database
  21. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  22. How to display open transactions in MySQL
  23. MySQL foreign key to allow NULL?
  24. MySQL query, MAX() + GROUP BY
  25. How to schedule a stored procedure in MySQL
  26. What’s the best way to migrate a Django DB from SQLite to MySQL?
  27. Easiest way to copy a table from one database to another?
  28. Foreign key constraints: When to use ON UPDATE and ON DELETE
  29. How to use a user variables in MySQL LIKE clause?
  30. How to store data with dynamic number of attributes in a database

Leave a Comment