Hello
I installed the lamp according to this tutorial:
https://en.opensuse.org/SDB:LAMP_setup
Of course, there was no training for php 8, but anyway …
I have three problems with phpmyadmin:
1- What is this error !? This error even existed on the tutorial page.
https://s22.picofile.com/file/8448661426/Screenshot_from_2022_03_28_08_31_01.png
“The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.”
2- I have to use the following address to enter phpmyadmin in the browser:
https://s22.picofile.com/file/8448661450/Screenshot_from_2022_03_28_08_41_55.png
It is strange that it is case sensitive!
3- Why is there no utf8 option in phpmyadmin and in the “Server connection collation” section?
https://s23.picofile.com/file/8448661568/screencast.gif
Thanks.
In tumbleweed phpMyAdmin is not more installed in /srv/www/htdocs but in /usr/share/phpMyAdmin.
In directory /etc/apache2/conf.d/ I have a file phpMyAdmin.conf which contains an alias so that php can find phpMyadmin
# By default the /phpMyAdmin Alias is enabled for all vhosts.
# To disable the /phpMyAdmin Alias, run
# a2enflag -d phpMyAdmin && rcapache2 restart
# This will make /phpMyAdmin unavailable on any vhosts.
#
# If you want to have the /phpMyAdmin Alias only on a specific
# vhost, add the Alias to the config of that vhost.
<IfDefine phpMyAdmin>
<IfModule mod_alias.c>
Alias /phpMyAdmin /usr/share/phpMyAdmin
</IfModule>
</IfDefine>
.....
I suppose that the alias forces the case sensitive.
Regards
Philippe
AFAIK mysql (and probably also mariadb) uses utf8mb4 and stores the characters with a maximum length of 4 bytes. Before they used utf8mb3 (3 bytes maximum per characters) which was named utf8: not all utf8 could be used.
For more details see for example In MySQL, never use “utf8”. Use “utf8mb4”. | by Adam Hooper | Medium
Regards
Philippe
Thank you very much!
This problem solved, I opened the file:
sudo vim /etc/apache2/conf.d/phpMyAdmin.conf
And a line containing the following text:
Alias /phpMyAdmin /usr/share/phpMyAdmin
I changed to:
Alias /phpmyadmin /usr/share/phpMyAdmin
And finally I restarted Apache2:
sudo systemctl restart apache2
So utf8mb4 can be used without any problems, right?
Yes, I use utf8mb4_unicode_ci since years without problem.
Regards
Philippe
Thank you very much.
This problem also solved.
To solve it, first open the following file:
sudo nvim /etc/phpMyAdmin/config.inc.php
Find the following text:
$ cfg ‘ZeroConf’] = false;
And set its value to true.
The result should be something like this:
$ cfg ‘ZeroConf’] = true;
Finally restart Apache 2, log in to phpmyadmin and approve phpmyadmin request to create tables.