The Symfony Frame work is very popular with PHP
developers and it has a very nice Demo
Application to help novices learn the intricacies
involved. But the demo does not use MySQL. So this blog
entry is about re configuring the demo so it works with MySQL 8.
And I am using Ubuntu 18.04 LTS to you may have to adjust the
following commands to work with your operating system.
This is not difficult but there are some steps that are not
exactly self evident that this blog will show you how to get the
demo working.
Preliminaries
The first thing to do is to make sure you have PHP 7.2 or better
installed including the php7.2-intl (sudo apt-get install
php7.2-intl) package as well as the PDO connector. I will admit I
have been using PHP since it appeared and this …
I am currently working my way through the many PHP Frameworks to
see how they get on with MySQL 8. The Frameworks that can
take advantage of the MySQL Improved Extension or mysqli
can take advantage of the SHA256 Caching Authentication method.
But those that are PDO based need to use the older MySQL Native
Authentication method.
I wanted to check the PDO based frameworks and today I just
happened to be wearing the very nice Symfony shirt I received as
part of my presentation at Symfony USA. So I started with a
fresh install of Symfony. All was going well until it came
time to get it to work with MySQL 8 through Doctrine.
Doctrine
Symfony uses Doctrine as an ORM (Object Relational Mapper)
and DBAL (Database Abstraction Layer) as an
intermediary to the database. While I myself am not a big
fan of ORMs …
If you’re trying to install the MySql Workbench Doctrine Plugin for Mac and don’t know where your %APPDATA% directory is, here’s the path:
%YOUR HOME DIRECTORY%/Library/Application Support/MySQL/Workbench/modules/DoctrineExport.grt.lua
– or as in my case on my laptop –
/Users/robert/Library/Application Support/MySQL/Workbench/modules/DoctrineExport.grt.lua
Once your drop in the DoctrineExport.grt.lua script, restart Workbench and you’re ready to go.