Quote:
Originally Posted by zama
mysql -h 192.168.2.140 -D mysql -e "select User from mysql;"
|
I am not sure there should be table name mysql in the database mysql, I think it should be user so try
Code:
mysql -h 192.168.2.140 -D mysql -e "select User from user;"
and it would be good if you use mysql username and mysql password. If you have username root and password blank, do not use it. A fair username and password is more secure than root and blank. Suppose your username is zama and password is zama897456 so it would be
Code:
mysql -h 192.168.2.140 -u zama -p'zama897456' -D mysql -e "select User from user;"