[BlueOnyx:20604] Re: how to downgrade mariadb 10 to 5.5 or MYSQL?

[Mon Chan]

Dear Michael

My fix in Mariadb 10 chinese text issue.
Just add one line in this file.
/etc/my.cnf.d/mysql-clients.cnf
[mysql]
default-character-set=utf8



BTW: I have some question for PHP+Mariadb bundle. is product behavior or
bug?

1. The PHP app must set the server as 127.0.0.1, using locathost is cannot
connect. I Using phpmyadmin see the premission table, the server address is
127.0.0.1
2. Create the first MYSQL account is not working, need go to UI Services >
MariaDB > MariaDB Permissions and click save.





On Fri, Jan 27, 2017 at 4:06 AM, Michael Stauber <mstauber at blueonyx.it>
wrote:

> Hi Mon Chan.
>
> > 1. Opencert : how to change mPDO driver?
>
> You mean OpenCart? In the directory where OpenCart is installed there is
> a config.php. In it change this line ...
>
> define('DB_DRIVER', 'mysqli');
>
> ... to this:
>
> define('DB_DRIVER', 'mpdo');
>
> You need to do the same with admin/config.php, too.
>
> > 2. Can you test OrangeHRM with installer setup?
>
> I just tried. With the usual php-mysql I get this:
>
> You need at least MySQL 4.1.x, Detected MySQL ver
>
> When I replace php-mysql with php-mysqlnd it works and reports this (in
> green color):
>
> MySQL Client    OK (ver mysqlnd 5.0.10 - 20111026 - $Id:
> e707c415db32080b3752b232487a435ee0372157 $)
> MySQL Server    OK (ver 5.5.5-10.1.18-MariaDB)
>
> > 3. For the joomla 1.5 with chinese text (Migrate from 5108R), i need add
> > UTF8 support in my.cnf( I forget what set before.)
>
> I just checked and found this article related and interesting:
>
> https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/
>
> Yes, you can set the character set for databases either on a global
> (server) level. Or on a per database level.
>
> The URL above give some tips on how to do this.
>
> --
> With best regards
>
> Michael Stauber
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20170127/04b8487a/attachment.html>