1. Edit file /etc/my.cnf.d/mariadb-server.cnf and add these 3 lines to the [mysqld] section: innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true This will enable usage of Multi-byte (in particular – 4-byte) UTF-8 support in Drupal 7. 2. mysqli: If you have problems with mysqli/mysql change the mysqli to mysql (or vice versa – whatever works for you) in /sites/default/settings.php. Alternatively […]
Recovering your phpMyAdmin/mysql lost root login password How do you reset your mysqld and phpAdminPassword? First we need to change the mysql root password (or set to empty if we want to allow a passwordless login). After that we will setup phpMyAdmin to use this mysql login. 1. On newer Linuxes, e.g. Ubuntu 16.04 LTS […]
… copied as-is from : http://fedorasolved.org/server-solutions/lamp-stack Very useful info, everything works like a charm (I tried on FC15) so I am replicating this here in case that page ever gets archived, goes offline, etc. I will see if I can add some more info about setting phpMyAdmin here as well. Doing the work The best […]