Access mysql remote database from command line

by

To directly login to a remote mysql console, use the below command:

mysql -u {username} -p'{password}' \
    -h {remote server ip or name} -P {port} \
    -D {DB name}

For example

mysql -u root -p'root' \
        -h 127.0.0.1 -P 3306 \
        -D local

no space after -p as specified in the documentation

It will take you to the mysql console directly by switching to the mentioned database.

More Related Contents:

  1. Can’t connect to MySQL server error 111 [closed]
  2. Suppress warning messages using mysql from within Terminal, but password written in bash script
  3. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  4. How to execute a MySQL command from a shell script?
  5. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  6. Linux shell script for database backup
  7. How to do a regular expression replace in MySQL?
  8. How to solve “Error: MySQL shutdown unexpectedly”?
  9. Count the number of occurrences of a string in a VARCHAR field?
  10. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  11. How to import a CSV file into a MySQL table
  12. How to store arrays in MySQL?
  13. MySQL high CPU usage [closed]
  14. How do I select between the 1st day of the current month and current day in MySQL?
  15. Subqueries with EXISTS vs IN – MySQL
  16. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  17. MySQL Cross Server Select Query
  18. How do I generate nested json objects using mysql native json functions?
  19. MySQL TEXT vs BLOB vs CLOB
  20. How accurately should I store latitude and longitude?
  21. MySQL: LAST_INSERT_ID() returns 0
  22. MySQL INNER JOIN select only one row from second table
  23. How to select only date from a DATETIME field in MySQL?
  24. UPDATE all records with a random number from a range
  25. mysql sorting of version numbers
  26. Get Insert Statement for existing row in MySQL
  27. mysql Failed to read auto-increment value from storage engine
  28. Alter table if exists or create if doesn’t
  29. Mysql stored procedure don’t take table name as parameter
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment