mysql.exe --user=myuser --pass=mypassword --host=myhost.com
mysql.exe --user=myuser --pass=mypassword --host=localhost
mysql.exe --user=myuser --pass=mypassword --host=127.0.0.1
connect database at localhost
mysql.exe
query data
>show databases
>use mydatabase
>show tables
>select count(*) from table1
mysql is active status
mysqladmin.exe ping ----- view status of mysql at localhost
mysqladmin --host=192.168.0.10 --user=root --pass=mmppst ping
mysqladmin --host=myhostname --user=root --pass=mmppst ping
show current mysql server variable (with path )
mysqladmin --host=myhostname.com --user=root --pass=mmppst variables
mysqladmin --host=myhostname.com --user=root --pass=mmppst variables more
shutdown mysql server
mysqladmin --host=myhostname.com --user=root --pass=mmppst shutdown
view version
mysqladmin.exe --host=myhostname.com --user=root --pass=mmppst version
ไม่มีความคิดเห็น:
แสดงความคิดเห็น