Image for post
Image for post

Some users have problems with brew upgrade and using Homebrew MySQL from 5.* to 8.

When enter to mysql -uroot, and enter SHOW DATABASES; returns the error: Mysql Error:The user specified as a definer (‘mysql.infoschema’@’localhost’) does not exist’ when trying to dump tablespaces

To solve this, follow:

mysql -u root -p
mysql> SET GLOBAL innodb_fast_shutdown = 1;
mysql_upgrade -u root -p

Done! It works!


Não deu!!! Mas não tem problema. Consegui chegar aos 142.4kg, com muita garra e vontade! São 2 meses de academia + nutrição onde perdi 11kg de gordura e ganha 2 kg de massa muscular. O tempo não para. A esposa maravilhosa está em cima me ajudando e me apoiando cada dia mais!

Tive uns deslizes nos últimos dias, mas sempre moderados, nos quais não aumentavam o peso.

Minha meta atual é -47 kg, e espero perder nos próximos 6 meses. Vamos que vamos!


Hello all,

I'm sharing my experience about installation of driver OCI with PDO on PHP, independent of version (5.6|7.*)

Follow the instructions:

  • Install the InstantClient from RPMs
  • Don’t create the symbolic links
  • See below for instructions regarding each module

OCI 8

  • For PHP 5.6: pecl install oci8–2.0.11
  • For PHP 7+: pecl install oci8

A sample oci8 configure path:instantclient,/opt/lib/oracle/12.1/client64/lib

PDO_OCI

  • Download the PHP sources, matching the current PHP version installed php -v
cd /root
mkdir src
cd src
wget http://be.php.net/distributions/php-7.y.z.tar.gz
tar xfvz php-7.y.z.tar.gz
  • Compile and install the extension
cd php-7.y.z
cd ext
cd pdo_oci
phpize
./configure --with-pdo-oci=instantclient,/usr,12.1
make
make install
echo extension=pdo_oci.so > /etc/php.d/pdo_oci.ini
php -i |grep oci

Enjoy! Tested with PHP 7.1+!

About

Vinicius Vicente

Tech Passionate | Backend Development

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store