MySQL常用操作

远程连接MySQL

mysql -h 47.106.110.18 -u root -p

查询MySql端口号

mysql> show global variables like 'port';

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+
1 row in set (0.00 sec)

查看MySQL是否在运行

[root@iZwz9c7pkk6xpht2857qkhZ ~]# service mysql status

Redirecting to /bin/systemctl status  mysql.service
● mysqld.service - MySQL Community Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Sun 2018-05-13 10:44:32 CST; 2 days ago