Is there a way to pass the DB user password into the command line tool mysqladmin?

mysql windows windows-server-2008 mysqladmin
Ethan Allen picture Ethan Allen · Oct 1, 2012 · Viewed 80k times · Source

I currently use the following but it ALWAYS prompts me to manually type the password. Is there any way to pass it in on the command line when launching the executable?

mysqladmin processlist -u root -p

Answer

Ethan Allen picture Ethan Allen · Oct 1, 2012

Just found out the answer....

mysqladmin processlist -u root -pYOURPASSWORDHERE

No space between your password and the -p

Related questions

MariaDB not allowing remote connections

As the screenshots show, I have the accounts setup to allow remote connections but as shown in the second screenshot I still cannot connect remotely.

Read More
Batch-file for mysqldump to backup each database into a separate file

Trying to create a batch (cmd) file for backing up each database into a separate file. Databases are created/deleted often, so batch file needs to grab current db names everytime it runs and backup each one of them. Here …

Read More
How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More