Problema con base de datos en XAMPP

[vought]

Saludos a todos,

Soy el novato muy, muy novato y me he encontrado con un problemón inesperado que no sé resolver. Trabajo en local usando XAMPP y durante el mes largo que llevo preparando mi primera página web no me había dado ningún problema. Sin embargo, hoy no puedo acceder a ella porque desde el XAMPP me cierra la base de datos mysql a los pocos segundos de abrirla. Este es el mensaje que me aparece en la propia pantalla del XAMPP:

----------------------------------------------------
9:22:08 AM [Apache] Attempting to start Apache app...
9:22:08 AM [Apache] Status change detected: running
9:22:16 AM [mysql] Attempting to start MySQL app...
9:22:16 AM [mysql] Status change detected: running
9:22:26 AM [mysql] Status change detected: stopped
9:22:26 AM [mysql] Error: MySQL shutdown unexpectedly.
9:22:26 AM [mysql] This may be due to a blocked port, missing dependencies,
9:22:26 AM [mysql] improper privileges, a crash, or a shutdown by another method.
9:22:26 AM [mysql] Press the Logs button to view error logs and check
9:22:26 AM [mysql] the Windows Event Viewer for more clues
9:22:26 AM [mysql] If you need more help, copy and post this
9:22:26 AM [mysql] entire log window on the forums
---------------------------------------------------

Tal como indica el mensaje, abrí el archivo de logs para ver qué dice, y esto es lo que aparece:

---------------------------------------------------
2019-08-12 9:19:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-12 9:19:11 0 [Note] InnoDB: Uses event mutexes
2019-08-12 9:19:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-12 9:19:11 0 [Note] InnoDB: Number of pools: 1
2019-08-12 9:19:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-12 9:19:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-12 9:19:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-12 9:19:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-12 9:19:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-12 9:19:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-12 9:19:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-12 9:19:11 0 [Note] InnoDB: Waiting for purge to start
2019-08-12 9:19:11 0 [Note] InnoDB: 10.3.16 started; log sequence number 55984813; transaction id 51307
2019-08-12 9:19:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-12 9:19:11 0 [Note] InnoDB: Buffer pool(s) load completed at 190812 9:19:11
2019-08-12 9:19:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-12 9:19:11 0 [Note] Server socket created on IP: '::'.
---------------------------------------------------

No tengo ni idea de lo que dice y por eso me gustaría que alguien me pudiese ayudar, ya que no puedo continuar trabajando en mi web. El único motivo que se me ocurre por el cual esto ha pasado es que la última vez que trabajé en ella hace unos días me instalé el plugin "Duplicator" para hacer copias de seguridad. Hice la primera de ellas y no medió ningún problema, pero desde entonces no había vuelto a tocar el emulador.

¿Podría alguien echarme una mano, por favor?

Muchas gracias por adelantado.

 

[SnAFKe]

Pega el error completo ahí esta a medias.

 

[Carlos Frias]

@vought segun el log que has compartido faltan archivos o el puerto ya esta en uso.
Verifica esos puntos comentados y nos informas 😛

 

[Linton]

Pásate a FlyWheel, una opción bastante mejor.

 

[vought]

Pega el error completo ahí esta a medias.

Aquí lo cuelgo todo, pero lo que hace es repetirse una y otra vez lo mismo:

-------------------------------------
2019-08-12 9:11:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-12 9:11:23 0 [Note] InnoDB: Uses event mutexes
2019-08-12 9:11:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-12 9:11:23 0 [Note] InnoDB: Number of pools: 1
2019-08-12 9:11:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-12 9:11:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-12 9:11:23 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-12 9:11:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=55984777
2019-08-12 9:11:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-12 9:11:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-12 9:11:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-12 9:11:24 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-12 9:11:24 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-12 9:11:24 0 [Note] InnoDB: Waiting for purge to start
2019-08-12 9:11:24 0 [Note] InnoDB: 10.3.16 started; log sequence number 55984786; transaction id 51307
2019-08-12 9:11:24 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-12 9:11:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-12 9:11:24 0 [Note] InnoDB: Buffer pool(s) load completed at 190812 9:11:24
2019-08-12 9:11:24 0 [Note] Server socket created on IP: '::'.
2019-08-12 9:18:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-12 9:18:42 0 [Note] InnoDB: Uses event mutexes
2019-08-12 9:18:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-12 9:18:42 0 [Note] InnoDB: Number of pools: 1
2019-08-12 9:18:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-12 9:18:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-12 9:18:42 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-12 9:18:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-12 9:18:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-12 9:18:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-12 9:18:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-12 9:18:42 0 [Note] InnoDB: Waiting for purge to start
2019-08-12 9:18:42 0 [Note] InnoDB: 10.3.16 started; log sequence number 55984804; transaction id 51307
2019-08-12 9:18:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-12 9:18:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-12 9:18:43 0 [Note] Server socket created on IP: '::'.
2019-08-12 9:19:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-12 9:19:11 0 [Note] InnoDB: Uses event mutexes
2019-08-12 9:19:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-12 9:19:11 0 [Note] InnoDB: Number of pools: 1
2019-08-12 9:19:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-12 9:19:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-12 9:19:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-12 9:19:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-12 9:19:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-12 9:19:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-12 9:19:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-12 9:19:11 0 [Note] InnoDB: Waiting for purge to start
2019-08-12 9:19:11 0 [Note] InnoDB: 10.3.16 started; log sequence number 55984813; transaction id 51307
2019-08-12 9:19:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-12 9:19:11 0 [Note] InnoDB: Buffer pool(s) load completed at 190812 9:19:11
2019-08-12 9:19:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-12 9:19:11 0 [Note] Server socket created on IP: '::'.

-------------------------------------

 

[SnAFKe]

No veo ningún error en los logs.

Trata de cambiar el puerto del mysql por otro por ejemplo 3307 , 3308 etc.

No se que tan cierto sea pero no esta mal que intentes es que cierres el Skype si lo tienes abierto que según dicen este causa este problema.

También otro problema pudiera ser es que el servidor MySQL este corriendo revisa en los proceso que no hay nada de MySQL si lo hay ciérralo.

 

[vought]

@vought segun el log que has compartido faltan archivos o el puerto ya esta en uso.
Verifica esos puntos comentados y nos informas 😛

Gracias por la respuesta, el puerto TCP 3306 está libre ahora mismo. Te muestro el netsat:

-----------------------------------------------------
Microsoft Windows [Version 10.0.17134.885]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\Alter>netstat -a

Active Connections

Proto Local Address Foreign Address State
TCP 0.0.0.0:80 User-PC:0 LISTENING
TCP 0.0.0.0:135 User-PC:0 LISTENING
TCP 0.0.0.0:443 User-PC:0 LISTENING
TCP 0.0.0.0:445 User-PC:0 LISTENING
TCP 0.0.0.0:1801 User-PC:0 LISTENING
TCP 0.0.0.0:2103 User-PC:0 LISTENING
TCP 0.0.0.0:2105 User-PC:0 LISTENING
TCP 0.0.0.0:2107 User-PC:0 LISTENING
TCP 0.0.0.0:5040 User-PC:0 LISTENING
TCP 0.0.0.0:5357 User-PC:0 LISTENING
TCP 0.0.0.0:17500 User-PC:0 LISTENING
TCP 0.0.0.0:49664 User-PC:0 LISTENING
TCP 0.0.0.0:49665 User-PC:0 LISTENING
TCP 0.0.0.0:49666 User-PC:0 LISTENING
TCP 0.0.0.0:49667 User-PC:0 LISTENING
TCP 0.0.0.0:49668 User-PC:0 LISTENING
TCP 0.0.0.0:49671 User-PC:0 LISTENING
TCP 0.0.0.0:49683 User-PC:0 LISTENING
TCP 10.8.8.7:139 User-PC:0 LISTENING
TCP 10.8.8.7:52323 ec2-34-192-22-186:https CLOSE_WAIT
TCP 10.8.8.7:52412 162.125.34.137:https CLOSE_WAIT
TCP 10.8.8.7:52413 ec2-52-200-117-50:https CLOSE_WAIT
TCP 10.8.8.7:52417 162.125.69.3:https CLOSE_WAIT
TCP 10.8.8.7:52418 162.125.69.7:https CLOSE_WAIT
TCP 10.8.8.7:52447 162.125.33.7:https CLOSE_WAIT
TCP 10.8.8.7:52448 a104-104-54-228:https LAST_ACK
TCP 10.8.8.7:52465 ec2-176-34-155-23:https ESTABLISHED
TCP 10.8.8.7:52466 162.125.18.133:https ESTABLISHED
TCP 10.8.8.7:52467 162.125.18.133:https ESTABLISHED
TCP 10.8.8.7:52469 a-0001:https ESTABLISHED
TCP 10.8.8.7:52470 a-0001:https ESTABLISHED
TCP 10.8.8.7:52471 a-0001:https ESTABLISHED
TCP 10.8.8.7:52473 13.107.246.10:https ESTABLISHED
TCP 10.8.8.7:52474 204.79.197.254:https ESTABLISHED
TCP 10.8.8.7:52475 13.107.136.254:https ESTABLISHED
TCP 10.8.8.7:52476 204.79.197.222:https ESTABLISHED
TCP 10.8.8.7:55435 ec2-54-186-239-73:https ESTABLISHED
TCP 10.8.8.7:55448 104.18.42.158:http ESTABLISHED
TCP 10.8.8.7:55555 162.125.69.3:https CLOSE_WAIT
TCP 10.8.8.7:55590 ec2-34-211-132-103:https ESTABLISHED
TCP 127.0.0.1:843 User-PC:0 LISTENING
TCP 127.0.0.1:969 User-PC:0 LISTENING
TCP 127.0.0.1:5354 User-PC:0 LISTENING
TCP 127.0.0.1:5354 activate:49669 ESTABLISHED
TCP 127.0.0.1:5354 activate:49670 ESTABLISHED
TCP 127.0.0.1:17600 User-PC:0 LISTENING
TCP 127.0.0.1:27015 User-PC:0 LISTENING
TCP 127.0.0.1:49669 activate:5354 ESTABLISHED
TCP 127.0.0.1:49670 activate:5354 ESTABLISHED
TCP 127.0.0.1:52397 activate:52398 ESTABLISHED
TCP 127.0.0.1:52398 activate:52397 ESTABLISHED
TCP 127.0.0.1:52446 activate:65001 ESTABLISHED
TCP 127.0.0.1:54663 activate:54664 ESTABLISHED
TCP 127.0.0.1:54664 activate:54663 ESTABLISHED
TCP 127.0.0.1:54669 activate:54670 ESTABLISHED
TCP 127.0.0.1:54670 activate:54669 ESTABLISHED
TCP 127.0.0.1:54678 activate:54679 ESTABLISHED
TCP 127.0.0.1:54679 activate:54678 ESTABLISHED
TCP 127.0.0.1:54724 User-PC:0 LISTENING
TCP 127.0.0.1:54765 activate:54766 ESTABLISHED
TCP 127.0.0.1:54766 activate:54765 ESTABLISHED
TCP 127.0.0.1:54767 activate:54768 ESTABLISHED
TCP 127.0.0.1:54768 activate:54767 ESTABLISHED
TCP 127.0.0.1:54771 activate:54772 ESTABLISHED
TCP 127.0.0.1:54772 activate:54771 ESTABLISHED
TCP 127.0.0.1:54892 User-PC:0 LISTENING
TCP 127.0.0.1:54892 activate:55431 ESTABLISHED
TCP 127.0.0.1:55431 activate:54892 ESTABLISHED
TCP 127.0.0.1:55546 User-PC:0 LISTENING
TCP 127.0.0.1:55569 activate:55570 ESTABLISHED
TCP 127.0.0.1:55570 activate:55569 ESTABLISHED
TCP 127.0.0.1:55576 activate:55577 ESTABLISHED
TCP 127.0.0.1:55577 activate:55576 ESTABLISHED
TCP 127.0.0.1:55578 activate:55579 ESTABLISHED
TCP 127.0.0.1:55579 activate:55578 ESTABLISHED
TCP 127.0.0.1:55697 activate:55698 ESTABLISHED
TCP 127.0.0.1:55698 activate:55697 ESTABLISHED
TCP 127.0.0.1:65001 User-PC:0 LISTENING
TCP 127.0.0.1:65001 activate:52446 ESTABLISHED
TCP 192.168.1.130:139 User-PC:0 LISTENING
TCP 192.168.1.130:54671 162.125.68.3:https CLOSE_WAIT
TCP [::]:80 User-PC:0 LISTENING
TCP [::]:135 User-PC:0 LISTENING
TCP [::]:443 User-PC:0 LISTENING
TCP [::]:445 User-PC:0 LISTENING
TCP [::]:1801 User-PC:0 LISTENING
TCP [::]:2103 User-PC:0 LISTENING
TCP [::]:2105 User-PC:0 LISTENING
TCP [::]:2107 User-PC:0 LISTENING
TCP [::]:5357 User-PC:0 LISTENING
TCP [::]:17500 User-PC:0 LISTENING
TCP [::]:49664 User-PC:0 LISTENING
TCP [::]:49665 User-PC:0 LISTENING
TCP [::]:49666 User-PC:0 LISTENING
TCP [::]:49667 User-PC:0 LISTENING
TCP [::]:49668 User-PC:0 LISTENING
TCP [::]:49671 User-PC:0 LISTENING
TCP [::]:49683 User-PC:0 LISTENING
UDP 0.0.0.0:1434 *:*
UDP 0.0.0.0:3702 *:*
UDP 0.0.0.0:3702 *:*
UDP 0.0.0.0:5050 *:*
UDP 0.0.0.0:5353 *:*
UDP 0.0.0.0:5355 *:*
UDP 0.0.0.0:17500 *:*
UDP 0.0.0.0:17500 *:*
UDP 0.0.0.0:56555 *:*
UDP 0.0.0.0:56923 *:*
UDP 0.0.0.0:58996 *:*
UDP 0.0.0.0:60676 *:*
UDP 0.0.0.0:63020 *:*
UDP 10.8.8.7:137 *:*
UDP 10.8.8.7:138 *:*
UDP 10.8.8.7:1900 *:*
UDP 10.8.8.7:5353 *:*
UDP 10.8.8.7:5353 *:*
UDP 10.8.8.7:56551 *:*
UDP 127.0.0.1:1900 *:*
UDP 127.0.0.1:48401 *:*
UDP 127.0.0.1:48501 *:*
UDP 127.0.0.1:49905 *:*
UDP 127.0.0.1:55634 *:*
UDP 127.0.0.1:56552 *:*
UDP 127.0.0.1:60674 *:*
UDP 127.0.0.1:60675 *:*
UDP 127.0.0.1:60678 *:*
UDP 192.168.1.130:137 *:*
UDP 192.168.1.130:138 *:*
UDP 192.168.1.130:1900 *:*
UDP 192.168.1.130:5353 *:*
UDP 192.168.1.130:5353 *:*
UDP 192.168.1.130:56550 *:*
UDP [::]:1434 *:*
UDP [::]:3702 *:*
UDP [::]:3702 *:*
UDP [::]:5353 *:*
UDP [::]:5355 *:*
UDP [::]:56556 *:*
UDP [::]:60677 *:*
UDP [::]:63021 *:*
UDP [::1]:1900 *:*
UDP [::1]:5353 *:*
UDP [::1]:5353 *:*
UDP [::1]:56549 *:*
UDP [fe80::8840:bea3:b530:a5be%8]:1900 *:*
UDP [fe80::8840:bea3:b530:a5be%8]:56547 *:*
UDP [fe80::c10b:2eca:cbb8:4a17%15]:1900 *:*
UDP [fe80::c10b:2eca:cbb8:4a17%15]:56548 *:*

C:\Users\Alter>
-------------------------------------------------

He dado permisos a todos los usuarios en la carpeta del XAMPP. He desactivado el Firewall, he ejecutado en modo administrador y sigue sin funcionar. ¿Cómo puedo saber si hay ficheros que faltan?

 

[vought]

Pásate a FlyWheel, una opción bastante mejor.

Gracias por la sugerenciak, pero antes necesito poder acceder a mi base de datos para poder instalar plugins. 🙁

 

[Carlos Frias]

Que tienes en my.cnf?

 

[Linton]

Gracias por la sugerenciak, pero antes necesito poder acceder a mi base de datos para poder instalar plugins. 🙁

No es un plugin sino otro programa para montaje en localhost.

 

[vought]

Que tienes en my.cnf?

Trabajo en Windows 10. He buscado en todo mi disco duro (también como my.ini) y no lo encuentro.

 

[vought]

No es un plugin sino otro programa para montaje en localhost.

Gracias por la sugerencia. Si consigo recuperar mi web, me lo plantearé seriamente. 🙁

 

[Carlos Frias]

Trabajo en Windows 10. He buscado en todo mi disco duro (también como my.ini) y no lo encuentro.

Revisa en C:\xampp\mysql\bin

 

[vought]

Revisa en C:\xampp\mysql\bin

Genial. Gracias. Aquí tienes una copia de todo el archivo.

----------------------
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password = your_password
port = 3306
socket = "C:/xampp/mysql/mysql.sock"


# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql"
tmpdir = "C:/xampp/tmp"
datadir = "C:/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
key_buffer = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"

# Change here for bind listening
# bind-address="127.0.0.1"
# bind-address = ::1 # for ipv6

# Where do all the plugins live
plugin_dir = "C:/xampp/mysql/lib/plugin/"

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
# commented in by lampp security
#skip-networking
#skip-federated

# Replication Master Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin


# Point the following paths to different dedicated disks
#tmpdir = "C:/xampp/tmp"
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "C:/xampp/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/xampp/mysql/data"
#innodb_log_arch_dir = "C:/xampp/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

## UTF 8 Settings
#init-connect=\'SET NAMES utf8\'
#collation_server=utf8_unicode_ci
#character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="C:/xampp/mysql/share/charsets"
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
log_bin_trust_function_creators = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

----------------------

 

[vought]

Otra pregunta. ¿Cómo puedo saber el nombre que le puse a la base de datos que creé en su momento? No lo recuerdo y voy a intentar desinstalar y reinstalar Xampp. ¿Dónde puedo ver ese nombre?

 

[absa]

Instala Mysql por separado... y verifica la instalación, al correr Xampp solo arrancas apache la bd estará como un servicio.

 

[Programarte]

Si no mal recuerdo creo que da esas broncas al tener abierto Skype porque usan el mismo puerto, repito no estoy seguro si era este u otro programa el que causaba estos conflictos.

 

[absa]

Si no mal recuerdo creo que da esas broncas al tener abierto Skype porque usan el mismo puerto, repito no estoy seguro si era este u otro programa el que causaba estos conflictos.

Pero esas son las que entran en conflicto con apache, ya que el de mysql es muy especifico.