使用命令连接XAMPP中的mysql
2021/6/6 19:22:22
本文主要是介绍使用命令连接XAMPP中的mysql,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
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
这篇关于使用命令连接XAMPP中的mysql的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-06-25MySQL报错Duplicate entry '0' for key 'PRIMARY'
- 2024-05-29阿里 Canal 实时同步 MySQL 增量数据至 ClickHouse 数据库
- 2024-05-24在Linux下管理MySQL的大小写敏感性
- 2024-04-26MySQL查出时间比实际晚8小时的解决方案
- 2024-04-01JPA不识别MySQL的枚举类型
- 2024-03-30mysql数据库表卡死解决方法
- 2024-03-15MySQL多数据源笔记5-ShardingJDBC实战
- 2024-03-11natural join mysql
- 2024-03-11关于VS2017,VS2015 中利用 EF使用Mysql 不显示数据源问题解决方案
- 2024-02-26mysql 阿里云xb后缀备份文件恢复-icode9专业技术文章分享