Apache Friends Support Forum

... # 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! # #skip-networking # 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>, ...

... 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>, ...

For the "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there." issue see https://www.elasticwebworks.com/how-to-fix-the-phpmyadmin-configuration-storage-is-not-completely-configured-some-extended-features-have-been-deactivated-to-find-out-why-click-here/.

I used to have this fairly regularly and have no idea why it occurred but haven't had it since I've been running MySQL as a service for the Mariadb corruption issue

... the message says "Error Establishing Database Connection". However, there is nothing in the mysql.error.log file that suggests there was any contact with MySQL. At the same time there is no problem accessing MySQL when using phpmyadmin by accessing the localhost on the server machine. When doing that there is a message that gets displayed on the bottom of the screen as follows: The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. Or alternately go to 'Operations' tab of any database to set it up there.

when i follow your instruction i see

The phpMyAdmin configuration storage has been deactivated. Find out why.
create table
rename database to
copy database to
collation

there is no drop database option
do you know why?
thanks for help

... issue that was causing the one posted above. Somehow FF had an entry to allow no cookies from localhost. Once that was deleted all was fine. I did not post the second part 'cause I thought one might be causing the other. So my suggestion to other who experience this is to try a different browser first. The second problem was the error message at the bottom of the screen that said: "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. Or alternately go to 'Operations' tab of any database to set it up there." This one took a bit of research but the answer is to make sure that your username, usually root for most of us has ALL PRIVILEGES on all databases. This can be done from the terminal within the xaampp control panel using this query: GRANT ALL PRIVILEGES ON *.* TO 'username'@localhost IDENTIFIED BY 'your-password'; The final step is to open phpmyadmin\config.inc.php in a text editor and go ...

... 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>, ...

... 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>, ...

... this message Jun 08 14:52:30 localhost.localdomain systemd[1]: Started The Apache Webserver. Jun 08 14:55:04 localhost.localdomain systemd[1]: Stopping The Apache Webserver... Jun 08 14:55:04 localhost.localdomain start_apache2[27391]: AH00558: httpd-prefork: Could not reliably determine the server's fully qualified domain name, using localhost.localdomain. Set the 'ServerName' directive globally to suppress this message Jun 08 14:55:04 localhost.localdomain systemd[1]: apache2.service: Deactivated successfully. Jun 08 14:55:04 localhost.localdomain systemd[1]: Stopped The Apache Webserver. Don't know what I'm messing up. Any help is appreciated.

... work, so need to: 1. backup the \xampp\mysql\data folder to data_old folder. 2. Empty data folder and then copy contents of \xampp\mysql\backup to empty data folder. 3. Copy all database folder from data_old folder to data folder, but DO NOT copy mysql, phpmyadmin, performance_schema to data folder. 4. Copy ibdata1 from data_old folder to data folder. Run MariaDB. If you get the message: "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here." in phpMyAdmin, then: Run this SQL in phpMyAdmin with the phpmyadmin table selected: GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost'; Then if you had made user(s) before, you will have to make the users again, grant the privileges and use old password. If you don't have old password, make a new one. If you have projects already, the username and password may be in the configuration file for the project and you use those. I ...

... 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>, ...

Nobbie wrote:I cannot see any information from that screen. Please reboot your PC and after try to start Xampp via Terminal (not the GUI interface).

Enter the following command in a terminal (see also the FAQ for this):

Code: Select all

sudo /opt/lampp/lampp start

and show us the output.

This is the new image
https://imgur.com/a/jmC7TNe

Thank you it's succesfully run without GUI, hope after this xampp apache can run normally without configuration.
Other problem i face is after i can access the localhost/phpmyadmin it's shown red on this quote

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

does it matter for performance or it's normally because i haven't start database. thanks

Hi, I have installed the last XAMPP version on my Windows 10 Pc.

I have deactivated antivirus and UserAccessControl but when I tried to exit from XAMPP show me this error.

I have to build a video to show this problem:

https://www.loom.com/share/6ebb3896fba8421c9cf655043db48720

How to fix this problem?

Nobbie wrote:Its not an error, its not a warning, only a note, a little hint. Read it carefully and thats it, as you did not change privileges. Dont you understand that little note?

sorry my mistake. I didn't read it.

Another issue appear, If you can help me , it would be great.
After login into phpmyadmin page, with username "root" and password. I get two red error:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

The secret passphrase in configuration (blowfish_secret) is too short.

This is a screenshot for them

Code: Select all

https://i.ibb.co/28TWF5r/2.png

Use whatever bundle makes you most efficient.

Windows services are especially for portable versions not the way to go. That's why it is deactivated to register a service from the control panel itself. The non portable version does have red crosses / green ticks to register and unregister a service for each module.


Xampp gives you the possibility to use them, but the orientation of xampp is to be functional with as minimum changes to your system as possible. So if you are using the zip version and don't register any windows services the only thing to do to get rid of it completely is stopping its components and delete the xampp folder.