Turn Your Vehicle Into a Smart Earning Asset

While you’re not driving your car or bike, it can still be working for you. MOTOSHARE helps you earn passive income by connecting your vehicle with trusted renters in your city.

🚗 You set the rental price
🔐 Secure bookings with verified renters
📍 Track your vehicle with GPS integration
💰 Start earning within 48 hours

Join as a Partner Today

It’s simple, safe, and rewarding. Your vehicle. Your rules. Your earnings.

How to fix MySQL Shutdown Unexpectedly Error

Errors : mysql_error.log

2020-10-22 12:48:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-10-22 12:48:24 0 [Note] InnoDB: Uses event mutexes
2020-10-22 12:48:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-22 12:48:24 0 [Note] InnoDB: Number of pools: 1
2020-10-22 12:48:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-10-22 12:48:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-10-22 12:48:24 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-22 12:48:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=249429322
2020-10-22 12:48:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-10-22 12:48:26 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2020-10-22 12:48:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-22 12:48:26 0 [Note] InnoDB: Setting file ‘C:\xampp\mysql\data\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2020-10-22 12:48:26 0 [Note] InnoDB: File ‘C:\xampp\mysql\data\ibtmp1’ size is now 12 MB.
2020-10-22 12:48:26 0 [Note] InnoDB: 10.3.16 started; log sequence number 249429331; transaction id 170022
2020-10-22 12:48:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-10-22 12:48:26 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2020-10-22 12:48:26 0 [Note] Server socket created on IP: ‘::’.

Solution

Step 1: Open Xampp Control Panel
Step 2: Click on Config -> Click on Service and Port Settings
Step 3: Click on MySQL Tab and change port to 3307 (Note: any other port which is free in your system)
Step 4: Click on Save -> Save.
Step 5: Restart your Xampp Control Panel

Note : you have to change port number in my.ini files also.

References :

References :
Click Here

Solution 2


if you find error like below image attached then forward video upto 8:00 duration.

you have to locate below file and change localhost ipv4 address. whenever you change mysql port then you should change below file also to work smoothly.

/xampp/phpmyadmin/config.inc.php (file)

old setting

/* Bind to the localhost ipv4 address and tcp */
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1:3307‘;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;

New Settings

/* Bind to the localhost ipv4 address and tcp */
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.