This is incompatible with sql_mode=only_full_group_by – MySQL
Your MySQL is enabled ONLY_FULL_GROUP_BY mode, don’t worry you can disable it simply There are two solutions to disable it:
Read moreYour MySQL is enabled ONLY_FULL_GROUP_BY mode, don’t worry you can disable it simply There are two solutions to disable it:
Read moreOpen terminal and run the commands to fix it
1 2 3 |
sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin |
now restart the apache
1 |
sudo service apache2 restart |
Read more
While your are creating the structure for table just add theĀ AUTO_INCREMENT = YOUR_DEFINED_NUMBER. Doing this your Primary Key will set
Read more