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