MariaDB 11.1.2 incorrect flags
rgreenn opened this issue · 3 comments
The --help
printout says that -p is password flag, while -D is for database. However, when running mariadb -u username -p password
in the container I am prompted to enter the password and it returns:
ERROR 1044 (42000): Access denied for user 'username'@'%' to database 'password'
Running mariadb -u username -D database
returns:
ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO)
I would like to run a command like mariadb -e "SELECT * FROM TABLE" -u username -p password -D database
within a bash script, but am unable to do so as the -p
flag appears to specify the database, and the -D
flag does nothing.
@rgreenn This is the wrong project for asking such a question but anyway. This is clearly documented in the manual:
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
If you use a --password or -p option and specify a password value, there must be no space between --password= or -p and the password following it.
Hope that helps!
Sorry, I'm fairly new to github.
Thanks, I appreciate the help!
Also documented https://mariadb.com/kb/en/mariadb-command-line-client/#-p-passwordname
https://mariadb.com/kb/en/getting-help-with-mariadb/
Welcome to MariaDB and github.
/wave @tanji 😸