使用命令连接XAMPP中的mysql

数据库 专栏收录该内容
2 篇文章 0 订阅

 

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

  • 0
    点赞
  • 0
    评论
  • 0
    收藏
  • 一键三连
    一键三连
  • 扫一扫,分享海报

©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值