Apache Friends Support Forum

Firstly you need to verify Configuration File. Mostly config.inc.php file located in the root directory of phpMyAdmin.
Check $cfg['Servers'][$i]['password'], you can change or replace it with your new root password.

Change authentication file config.inc.php to $cfg['Servers'][$i]['auth_type'] = 'config';

Thank you! couldn't find it anywhere.

config.inc.php

I should add, I'm talking about an XAMPP setup

Well subject says it all. I followed directions to change root password, and then phpmyadmin won't authenticate. I changed it back to blank, but I can't figure out what config file has the password for phpmyadmin to update it!

Thanks! Andy

Nobbie wrote:Xampp is not a browser. These are messages from any third party tools, its not Xampp.

Is Apache running, can you see the dashboard when you enter http://localhost into the browser?

I wish I could post a screenshot, but I can't attach an image here.

I was running XAMPP, Apache and MySQL, so I could show the output of a .PHP file on a browser. Even PhpMyAdmin wouldn't show up.

To restore the MySQL database in XAMPP, try these steps:

Stop XAMPP:
Ensure that XAMPP is not running. You can stop it using the XAMPP Control Panel.

Restore XAMPP Folder:
Replace the current XAMPP folder in "/Applications" with the one you copied yesterday. Make sure the folder structure remains the same.

Check MySQL Configuration:
Open the "my.ini" or "my.cnf" file in the "xampp/mysql/bin" directory. Ensure the paths are correct and point to your restored MySQL data directory.

Start XAMPP:
Start XAMPP again and specifically try to start the MySQL service. Check if it stays running.

Database Visibility:
If MySQL is running, open phpMyAdmin and check if your "CRM" database and "contacts" table are visible. If not, you might need to import the database manually.

Import Database:
If needed, import your database using the MySQL command line or a tool like phpMyAdmin. Open a command prompt, navigate to the "xampp/mysql/bin" directory, and use the following command:

bash

mysql -u your_username -p your_database_name < path/to/your/backup.sql

Replace "your_username," "your_database_name," and "path/to/your/backup.sql" with your actual values.

Check Logs:
If you still face issues, check the MySQL error log for any clues. You can find the log file in the "xampp/mysql/data" directory.

Remember to back up your current state before making any changes. If the problem persists, consider seeking assistance from a database administrator or a tech support community.

Es tut mir leid zu hören, dass Sie Probleme mit Ihrer MySQL-Datenbank haben. Hier sind einige Schritte, die Sie unternehmen können, um das Problem zu beheben:

Versuchen Sie, XAMPP mit der folgenden Methode neu zu installieren

Laden Sie die neueste Version von XAMPP von der offiziellen Website herunter: https://www.apachefriends.org/index.html
Installieren Sie XAMPP neu und stellen Sie sicher, dass Sie es im Standardverzeichnis installieren.
Oder erwägen Sie die Wiederherstellung der Datenbank:

Kopieren Sie den gesamten MySQL-Datenordner aus Ihrem Backup (kopierter XAMPP-Ordner) und ersetzen Sie den MySQL-Datenordner im neu installierten XAMPP.
Wenn es immer noch nicht funktioniert, überprüfen Sie die MySQL-Protokolle:

Überprüfen Sie die MySQL-Protokolle auf Fehler. Sie befinden sich normalerweise im Verzeichnis xamppfiles/var/mysql/ (oder einem ähnlichen Pfad, abhängig von Ihrer Installation).
XAMPP-Steuerung:

Versuchen Sie, XAMPP zu starten und prüfen Sie, ob MySQL erfolgreich gestartet wurde. Überprüfen Sie außerdem, ob Port 3306 von einer anderen Anwendung blockiert wird.
Datenbankverbindung prüfen:

Stellen Sie mit dem MySQL-Befehlszeilentool oder einem grafischen Tool wie phpMyAdmin eine Verbindung zu Ihrer MySQL-Datenbank her. Stellen Sie sicher, dass Ihre Datenbank „CRM“ und die Tabelle „Kontakte“ vorhanden sind.
Überprüfen Sie die Benutzerberechtigungen:
Stellen Sie sicher, dass der Benutzer, den Ihr CRM-System verwendet, über die erforderlichen Berechtigungen für die „CRM“-Datenbank verfügt.
Zum Schluss noch die Firewall-Ausnahme:
Überprüfen Sie, ob Ihre Firewall den MySQL-Port zulässt (Standard ist 3306).

Proceed to the folder which holds Phpmyadmin.

Edit the file config.inc.php (you probably have to run with admin rights)

Watch out for the line for auth_type:

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'config';

Change 'config' to 'cookie'. Safe config.inc.php

Then start /localhost/phpmyadmin - you will be prompted for User and Password from now on, Phpmyadmin wont login automatically, instead with the credentials you provide in this dialog. Provide the correct values for User and Password (i.e. root and your new password).

Hi,
I installed XAMPP on macOS Sonoma 14.2.1. At this stage I can access on the web /localhost/myphpadmin showing the root user has blank password. Using command line, I created a database, piwigo. Then I used /localhost/myphpadmin to change the password to the database. Then, I loaded mysql database from my backup. I placed the piwigo server on htdocs (server and database has the same name). After some write permission corrections, my piwigo server (with all my photo albums) is working. Now I want to go in /localhost/myphpadmin but it gives me error

Code: Select all

Error
MySQL said: Documentation

Cannot connect: invalid settings.
 mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
 Connection for controluser as defined in your configuration failed.
 mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Since the macOS manager-osx does not have features of the windows control panel, I do not know how to correct this.

Your help is much appreciated.

Edit, If I can change the password back to blank, maybe I can access /localhost/myphpadmin. But I searched and the methods used is on the control panel which manager-osx does not have. I cannot find any command line to change XAMMP mysql password.

edit2. I found the command and use this to alter the root password

Code: Select all

/Applications/XAMPP/bin/mysql --user=root --password -e "Alter User 'root'@'localhost' IDENTIFIED BY '""'"

Now I cannot access my database, since I have changed the password to "". What can I do in phpmyadmin to change the password back but also allow me to access /localhost/phpmyadmin?

So it seems while you can edit the configuration files (opening from control panel) and set ports via text and save, when using the "Config" button from the Control Panel application it may show different ports and not reading what you have set manually.

I thought I had lost my phpmyadmin, localhost opened the wrong server port every single time, and then I opened up the "Config" dialogue only to see that one was not correct. After setting the right port there, the browser looked up phpmyadmin correctly.

Not sure if I missed something in the instructions or if "Config" is buggy, but it seems strange it does not read the edited values. Is it supposed to?

It does not seem to reflect the correct settings for autostart either, even after enabling services, but perhaps those are two different modes, autostart vs services.

to sort this problem,
1. click on the config button on the mysql port and select my.ini
2. scroll down to the mysqld and change the port to 3308 and close the notepad page.
3. go to your localdrive location and search for the xampp file, then sellect the phpmyadmin, select config.inc.php and open with notepad again
4. scroll down to the section with "/* Bind to the localhost ipv4 address and tcp */" and copy this code "$cfg['Servers'][$i]['connect_type'] = 'tcp';"
5. paste it just beneath the code but change the connect type to port and tcp to 3308.
6. save and close the file
7. go back to the xampp control panel and click on start on the mysql again and it should connect through.

or click on this link on youtube to watch the step by step process if you are not okay with my explanation https://youtu.be/8nutBUVxmQg?si=u05gDyM8ZhivqOUK

Fatal error: Maximum execution time of 120 seconds exceeded in C:\xampp\phpMyAdmin\libraries\classes\ErrorHandler.php on line 192

Hi,
Can anyone help me. I receive the message below, so i cannot access phpmyadmin.
Thank you.

10:12:29 [mysql] Error: MySQL shutdown unexpectedly.
10:12:29 [mysql] This may be due to a blocked port, missing dependencies,
10:12:29 [mysql] improper privileges, a crash, or a shutdown by another method.
10:12:29 [mysql] Press the Logs button to view error logs and check
10:12:29 [mysql] the Windows Event Viewer for more clues
10:12:29 [mysql] If you need more help, copy and post this
10:12:29 [mysql] entire log window on the forums


2024-01-11 10:12:27 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 10364
Cannot find checkpoint record at LSN (1,0x5582)
2024-01-11 10:12:27 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-01-11 10:12:27 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-01-11 10:12:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-11 10:12:27 0 [Note] InnoDB: Uses event mutexes
2024-01-11 10:12:27 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-11 10:12:27 0 [Note] InnoDB: Number of pools: 1
2024-01-11 10:12:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-11 10:12:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-11 10:12:27 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-11 10:12:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-11 10:12:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-11 10:12:27 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-11 10:12:27 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-11 10:12:27 0 [Note] InnoDB: Waiting for purge to start
2024-01-11 10:12:27 0 [Note] InnoDB: 10.4.32 started; log sequence number 34345005; transaction id 4312
2024-01-11 10:12:27 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2024-01-11 10:12:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-11 10:12:27 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-01-11 10:12:27 0 [ERROR] Failed to initialize plugins.
2024-01-11 10:12:27 0 [ERROR] Aborting

Had problems starting the MySQL DB in XAMPP this morning.
Could fix this by renaming aria_log_control, ib_lofgile0 and ib_logfile1.
MySQL DB started after this but I now get timeouts when I try to start phpmyadmin or my Wordpress site.
The default XAMPP dashboard (https://localhost/dashboard/) works.

When trying to start phpmyadmin there's no error. It just stuck in the "Loading..."' phase.
When I try to go to the Wordpress Site I get this error:

Fatal error: Maximum execution time of 120 seconds exceeded in C:\xampp\htdocs\WordpressTestSite\wp-includes\class-wpdb.php on line 1990

Just increasing the max_execution_time in php.ini doesn't solve this. I tried that already.

Any tips are appreciated. Thanks!