/SQL/How to pass password mysql command line

How to pass password mysql command line

How to pass password mysql command line

mysql -u user -ppassword
password should not have any space with -p

1

How to pass password to mysql command line

mysqladmin processlist -u root -pYOURPASSWORDHERE
No space between your password and the -p

1

Source: stackoverflow.com

Change mysql password from command line

ALTER USER 'root'@'localhost' IDENTIFIED BY 'New-Password';

0

Similar codes

1 vote334 views1 answer
Mysql text to decimal
SQL
2 votes307 views1 answer
Oracle list grants on package
SQL
0 vote318 views1 answer
How to get specific salary in sql
SQL
0 vote312 views1 answer
Mysql enter ubuntu
SQL
0 vote352 views1 answer
Remove mysql from centos 7
SQL
6 votes324 views2 answers
How to get yesterday date in mysql
SQL
0 vote302 views1 answer
Recover deleted data from mysql database
SQL
4 votes305 views3 answers
How to describe a table in sqlite3
SQL
0 vote303 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote306 views1 answer
Vbscript clean up ADODB.Recordset
SQL

Share