JTM Blog

MySQL 8.0 was released couple day ago. MySQL 8.0 bring some new features and improvement.  Here are the step to upgrade MySQL 5.7 to 8.0 Download the repository and install it rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm  After that, do upgrade by typing yum update mysql-community-server --enablerepo=mysql80-community Wait until the update process finish. After that, type this command mysql_upgrade -u root -p<yourpassword>    If you do not do that command, you would face this following error : The user specified as a definer ('mysql.infoschema'@'localhost') does not exist . Wait until the process finish. Done, your mysql is ready. PS : In this version, MySQL change the default authentication type to caching_sha2_password. this type of authentication is not supported yet for common driver like PHP mysqli. So, for the temporary solution, you could change the default authentication typ...

I got this issues some days ago, when my CI based apps returned 404 error when i accessing it. My machine is running Slackware with httpd + PHP-FPM. This issue is not appear when i used httpd/apache + mod_php. This issue is like httpd's rewrite module is not enabled. But, i have made sure that that module had been activated. After searching and googling, I found solution from here . From that article, we should be doing something tricky. And this is my new .htaccess (edited from CI's .htaccess) Options -Indexes # index file can be index.php, home.php, default.php etc. DirectoryIndex index.php # Rewrite engine RewriteEngine On # condition with escaping special chars RewriteCond $1 !^(index\.php|robots\.txt|favicon\.ico) RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d # the following is for rewritting under FastCGI <IfModule mod_php5.c>        RewriteRule ^(.*)$ index.php/$1 [L,QSA] </IfModule> # the following is f...