MySQL treats password in script as database

by

From man mysql:

If you use the short option form (-p), you cannot have a space between the option and the password.

So either

mysql -u root -p"$PASSWORD"

or

mysql -u root --password "$PASSWORD"

More Related Contents:

  1. How to export and import a .sql file from command line with options? [duplicate]
  2. Suppress warning messages using mysql from within Terminal, but password written in bash script
  3. Downloading MySQL dump from command line
  4. Install MySQL on Ubuntu without a password prompt
  5. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  6. Bash script to insert values in MySQL
  7. How to get number of rows affected, while executing MySQL query from bash?
  8. How do I make this MySQL query faster and better?
  9. MySQL update table based on another tables value
  10. On Duplicate Key Update same as insert
  11. Ordering by the order of values in a SQL IN() clause
  12. LAST_INSERT_ID() MySQL
  13. SQL Selecting from two Tables with inner join and limit [duplicate]
  14. a count for each join – optimisation
  15. The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
  16. Are column and table name case sensitive in MySQL?
  17. MySQL – SELECT WHERE field IN (subquery) – Extremely slow why?
  18. How to add not null constraint to existing column in MySQL
  19. Special Characters in MySQL Table Name
  20. connect ECONNREFUSED – node js , sql
  21. MySQL Aggregate Functions without GROUP BY clause
  22. Count days between two dates, excluding weekends (MySQL only)
  23. How to insert values in table with foreign key using MySQL?
  24. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  25. Fixing “Lock wait timeout exceeded; try restarting transaction” for a ‘stuck” Mysql table?
  26. How to set root password to null
  27. the MySQL service on local computer started and then stopped
  28. Rename a table in MySQL
  29. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  30. mySQL regex in the where clause

Leave a Comment