1.环境

Mac

XAMPP8.0.6

 

2.连接语句

mysql -uxubo -h 192.168.64.2 -P 3306 -p

输入密码即可登录。

192.168.64.2为XAMPP部署服务的IP

phpmyadmin为：

http://192.168.64.2/phpmyadmin/index.php?route=/server/privileges&viewing_mode=server

 

3.操作记录：

 

localhost:mysql xubo$ mysql -uxubo -h 192.168.64.2 -P 3306 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 259
Server version: 5.5.5-10.4.19-MariaDB Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| springbootdb       |
| test               |
| xubo               |
+--------------------+
7 rows in set (0.00 sec)

mysql> use xubo;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_xubo |
+----------------+
| test           |
+----------------+
1 row in set (0.00 sec)

mysql> select * from test
    -> ;
+------+-----+------+------+
| name | age | data | info |
+------+-----+------+------+
| Bob  |  30 | test | test |
| Bob  |  30 | test | test |
+------+-----+------+------+
2 rows in set (0.00 sec)

mysql> use springbootdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ;
ERROR: 
No query specified

mysql> use springbootdb;
Database changed
mysql> show tables;
+------------------------+
| Tables_in_springbootdb |
+------------------------+
| city                   |
+------------------------+
1 row in set (0.01 sec)

mysql> select * from city;
+----+-------------+-----------+-----------------------------+
| id | province_id | city_name | description                 |
+----+-------------+-----------+-----------------------------+
|  1 |           1 | 温岭市    | BYSocket 的家在温岭。       |
+----+-------------+-----------+-----------------------------+
1 row in set (0.00 sec)

mysql> 

 

 

参考：

【1】 https://xubo245.blog.csdn.net/article/details/117630846