Tag: xampp

XAMPP

How to upgrade XAMPP in Windows

> Open XAMPP Control Panel (run as administrator!). > Stop services and uninstall them from services list if any. > Close XAMPP Control Panel. > Keep backup of htdocs, mysql\data directories and phpmyadmin\config.inc.php file. > Delete C:\xampp directory. > Download new XAMPP installer. > Install XAMPP to the same location (C:\xampp). > Copy your websites …

MySQL

Restore the MySQL root user’s full privileges in Windows

1. Stop MySQL service. Run services.msc as administrator and stop it. 2. Run cmd.exe as administrator. 3. Execute: c:xamppmysqlbinmysqld.exe –skip-grant-tablesc:xamppmysqlbinmysqld.exe –skip-grant-tables 4. Run another cmd.exe as administrator. 5. Execute: c:xamppmysqlbinmysql.exec:xamppmysqlbinmysql.exe 6. Execute query: UPDATE mysql.user SET Grant_priv=’Y’, Super_priv=’Y’ WHERE USER=’root’;UPDATE mysql.user SET Grant_priv=’Y’, Super_priv=’Y’ WHERE User=’root’; FLUSH PRIVILEGES;FLUSH PRIVILEGES; 7. Close cmd windows. 8. Kill …

Apache, XAMPP

Change Apache Ports in XAMPP

Change port for Apache 1. Open x:xamppapacheconfhttpd.conf file for edit. 2. Find Listen 80 and change it to Listen 8081. 3. Find ServerName localhost:80 and change it to ServerName localhost:8081. 4. Save the file. 5. Restart Apache.   Change port for SSL 1. Open x:xamppapacheconfextrahttpd-ssl.conf file for edit. 2. Find Listen 443 and change it …