Cómo usar Mysql por línea de comandos en XAMPP

Si has instalado XAMPP para emular servidores web en un ordenador Windows, peude que te encuentres que tienes que usar la línea de comandos de MYSQL y no sepas como.
No te va a ocurrir muy a menudo, pero hay ciertas cosas, como la importación de bases de datos grandes con source o mysqldump, que pueden requerirlo. Aquí te dejamos cómo hacerlo.

Tienes que irte al directorio de instalación de XAMPP, y buscar ahí el mysqldump/bin, por ejemplo, en la ruta por defecto: C:\xampp\mysql\bin\

Ahí debería haber un fichero mysql.exe.

Abre una línea de comandos (un terminal). Ve a la ruta C:\xampp\mysql\bin\  y ejecuta ese mysql.exe de esta manera:

mysql.exe –h localhost –u root -p

Te preguntará la contraseña, déjalo en blanco.

Y ya lo tienes, acceso root a tu mysql por línea de comando en XAMPP.

 

Os recomendamos los siguientes productos relacionados con la informática:

 

Repetidor WiFi, Amplificador señal WiFi,4 Antenas Externas, Amplificador WiFi 2.4GHz con Repertidor/Ap Modo y la función WPS,1 Puerto Ethernet, Facil de Instalar,Compatible with All WiFi Devices

(15449)

35,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Kingston Canvas Select Plus Tarjeta microSD, SDCS2/128GB Class 10 con Adaptador SD, garantía de por vida con el fabricante.

(171727)

8,95 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

BOOX Tablet Note Air4 C 10,3 Pulgadas Color ePaper Notepad 64 GB Android 13 E-Ink

(24)

549,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

INIU Cable USB C, 100W 2m Cable de Carga Rápida QC de USB C a USB C, Cable Tipo C Trenzado Nylon de Datos Cargador de Teléfono USB-C para Samsung S22 iPad Pro MacBook Tabletas LG Google etc

(34975)

7,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Lenovo Chromebook (2nd Gen) - Ordenador Portátil 11.6" FHD Táctil y Convertible (Intel CELERON N4120, 4GB RAM, Integrated Intel UHD Graphics 600, Chrome OS) Black - Teclado QWERTY Español

(245)

190,41 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Memoria USB 982GB - Alta Velocidad USB 3.0 Pendrive Gran Capacidad Memory Stick Metal Disco Duro Externo, para Almacenamiento de Datos, TV, PC, Portátil

(4618)

18,99 € (as of 20 noviembre, 2024 08:43 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

AiTodos® Soporte para Computadora Portatil, Aleación de Aluminio, Antideslizante, Soporte Portátil Plegable, Ventilación y Disipación de Calor, Ajuste de 6 Engranajes.

(4010)

12,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

TP-Link UB500 Adaptador Bluetooth 5.0 USB, Tamaño Mini para Ordenador, Portatil, Auriculares, Altavoz, Teclado, Compatible con Windows 11/10/8.1/7, Multicolor

(39945)

12,00 € (as of 20 noviembre, 2024 08:43 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Nuevo Amazon Kindle (16 GB), el Kindle más ligero y compacto, con pantalla sin reflejos, pasos de página más fluidos, luz frontal ajustable y batería de larga duración | Sin publicidad, negro

(55)

119,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Cable trenzado Carplay para iPhone 16 15 Coche 1m,18W 3A Cable USB C a USB Carplay para Apple CarPlay y Android Auto,Cable USB a USB C Carga Rápida Datos para Samsung A55 A35 A15 A54 A34 Pixel 9 Pro

(54)

12,48 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)