MySQL basic commands and the use of MYSQLADMIN commands

Mysql

--user,-U

--host,-H

--password,-P

--port

--protocol

--database database,-D

MySQL Batch processing mode

[Email protected] ~]# Vim/test.sql

Create DATABASE TestDB;

CREATE TABLE testdb.tb1 (ID int,name CHAR (20))

[[email protected] ~]# MySQL

mysql> \. /test.sql

Query OK, 1 row affected (0.09 sec)

Query OK, 0 rows affected (0.29 sec)

mysql> drop database TestDB; #删除

Query OK, 1 row affected (0.25 sec)

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| Information_schema |

| MyDB |

| MySQL |

| Test |

+--------------------+

Rows in Set (0.06 sec)

Or

[Email protected] ~]# Mysql-uroot-p </test.sql

Enter Password:

[Email protected] ~]# mysql-uroot-p

mysql> use TestDB;

Mysql> Show tables;

+------------------+

| Tables_in_testdb |

+------------------+

| tb1 |

+------------------+

1 row in Set (0.00 sec)

MySQL commands are divided into client commands and server-side commands, and server-side commands end; (default)

Status View Current state

\d modifier Terminator

\ r Reconnect to Mysql-server

\g Whatever the Terminator is sent to the server side to execute

\g Regardless of the Terminator is sent to the server side execution, and the result is displayed vertically @ very good \g and useful

\! Execute shell command directly

\c suddenly did not want to execute this command, with \c abort

-A, disable name completion by using-a when connecting to MySQL

Mysql> rehash using name completion will affect the speed

mysql> \d # Change command Terminator to #

Mysql> Show tables;

Show tables#

+------------------+

| Tables_in_testdb |

+------------------+

| tb1 |

+------------------+

1 row in Set (0.00 sec)

mysql> \! Ls/tool

apache-tomcat-7.0.73.tar.gz memcached-1.4.33

Crmsh-2.3.2-1.1.noarch_ (1). RPM mysql-5.6.34.tar.gz

crmsh-scripts-2.3.2-1.1.noarch.rpm nginx-1.10.2

Discuz_x3.2_sc_gbk_ (1). zip nginx-1.10.2.tar.gz

httpd-2.4.23 package.xml

jdk-8u112-linux-x64.tar.gz python-parallax-1.0.1-9.8.x86_64.rpm

Libevent-2.0.22-stable Readme

libmemcached-1.0.18.tar.gz xcache-3.2.0

memadmin-1.0.12.tar.gz xcache-3.2.0.tar.gz

[email protected] ~]# MySQL--html #将MySQL的输出格式改为html

mysql> use MySQL

Mysql> select User,host from user;

<table BORDER=1><TR><TH>USER</TH><TH>HOST</TH></TR><TR><TD >root</TD><TD>127.0.0.1</TD></TR><TR><TD>root</TD><TD> 192.168.%.%</td></tr><tr><td>root</td><td>localhost</td></tr> <tr><td>root</td><td>node1.zxl.com</td></tr></table>4 rows in Set (0.05 Sec

After saving the output in. html format, open the display as a table in a browser

Get help command

Such as

mysql> Help Select

Mysql> help CREATE INDEX get assistance creating indexes

Usage of the mysqladmin command

[[email protected] ~]# mysqladmin-uroot-p password ' 123456 ' Change password to 123456

Enter Password:

Change it back again.

mysql> Update Mysql.user set Password=password (' 123 ') where user= ' root ';

mysql> flush Privileges;

Mysql> \q

[[email protected] ~]# MySQL

Welcome to the MySQL Monitor. Commands End With; or \g.

Ping to see if the MySQL host is online

[[email protected] ~]# mysqladmin Ping

Mysqld is alive

[[email protected] ~]# mysqladmin create hellodb creating Hellodb Library

[[email protected] ~]# mysqladmin drop HELLODB Delete Hellodb library

Displays the status information for MySQL and can be displayed consecutively multiple times

[Email protected] ~]# mysqladmin status

uptime:16982 threads:1 questions:117 Slow queries:0 opens:88 Flush tables:1 Open tables:81 queries per second avg:0.006

[[email protected] ~]# mysqladmin status--sleep 1--count 5

Display state variables and their values

[Email protected] ~]# mysqladmin extended-status

+-----------------------------------------------+-------------+

| variable_name | Value

+-----------------------------------------------+-------------+

| aborted_clients | 0

| aborted_connects | 4 |

| Binlog_cache_disk_use | 0 |

| Binlog_cache_use | 0 |

| Binlog_stmt_cache_disk_use | 0 |

| Binlog_stmt_cache_use | 14 |

| bytes_received | 7104 |

| bytes_sent | 38911 |

Display Server Variables

[Email protected] ~]# mysqladmin variables

Refresh Authorization Table

[Email protected] ~]# mysqladmin flush-privileges

Close all open tables

[Email protected] ~]# mysqladmin flush-tables

Resetting the thread pool cache

[Email protected] ~]# mysqladmin flush-threads

Reset most server state variables to start counting from 0

[Email protected] ~]# mysqladmin flush-privileges

Shutting down the MySQL server

[Email protected] ~]# mysqladmin shutdown

Starting and shutting down replication threads from the server

[Email protected] ~]# mysqladmin Start-slave

[Email protected] ~]# mysqladmin Stop-slave

The other MySQL client tools also have

Mysqldump a Backup tool

Mysqlimport an import Tool

Mysqlcheck Inspection Tools

This article is from the "11097124" blog, please be sure to keep this source http://11107124.blog.51cto.com/11097124/1896942

MySQL basic commands and the use of MYSQLADMIN commands