Thursday, April 2, 2026

Error while starting My sql or Appache in Xampp server

 https://webolute.com/blog/programming/this-may-be-due-to-a-blocked-port-missing-dependencies/


and for My sql, use below steps

Open the XAMPP Control Panel and click Config next to MySQL, then select my.ini.

Find the lines port=3306 (usually in two places) and change them to port=3307.


next step

If going to localhost:8000 get error than change the config.inc.php, enter the password in string $cfg['Servers'][$i]['password'] = 'root';

and change

$cfg['Servers'][$i]['controluser'] = 'pma'; to  $cfg['Servers'][$i]['controluser'] = 'root';

$cfg['Servers'][$i]['controlpass'] = '';$cfg['Servers'][$i]['controluser'] = 'root';


=========================================
C:/xampp/php/php.ini
C:/xampp/apache/conf/httpd.conf
C:/xampp/mysql/bin/my.ini
C:/xampp/phpMyAdmin/config.inc.php
These above 4 files are changed.

C:/xampp/phpMyAdmin/config.inc.php
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

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

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'root';

and for xampp server- default password is blank
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

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

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';
 
=======================
C:/xampp/mysql/bin/my.ini - How to change the port of Mysql in xampp
port=3306
socket="C:/xampp/mysql/mysql.sock"

# Here follows entries for some specific programs 

# The MySQL server
default-character-set=utf8mb4
[mysqld]
port=3306
socket="C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"

C:/xampp/apache/conf/httpd.conf(How to change port of Appache server in xampp) 
For changing https port
Listen 80 -- change here
ServerName localhost:80

C:/xampp/php/php.ini
if getting error "plugin does not exist. Valid plugin IDs for Drupal\Core\ImageToolkit\ImageToolkitManager are: gd in Drupal\Core\Plugin\DefaultPluginManager-"
1) Press Ctrl + F and search for ;extension=gd.
2) Remove the semicolon (;) at the beginning of the line so it looks like this: extension=gd.
3) restart xaamp server
and
Add or uncomment the following line in your php.ini file: zend_extension=opcache.
Verify Settings: Ensure opcache.enable=1 is set in your php.ini.

c:\xampp\apache\conf\extra\httpd-ssl.conf
SSL port 4443

c:\xampp\apache\conf\extra\httpd-xampp.conf
if appache is not running than change this file.

c:\xampp\mysql\bin\my.ini
port=3307

C:\xampp\htdocs\PRGIWebsitedrupal\sites\default\settings.php
$config['system.image']['toolkit'] = 'gd';

For more drupal settings, please see link below.

Note:- In settings.php file port can be 3306 of Mysql workbench client and In My.ini port can be different(3307) because appache server my sql is different and mysql workbench is different.

No comments:

Post a Comment