Categories
MySQL

MySQL 8 : About GRANT / PRIVILEGES

In previous version of MySQL (before v8), we can grant/create mysql user one and grant it at once to get access by each host (location / 127.0.0.1) base on your mysql config. In MySQL 8, you no longer can (implicitly) create a user using the GRANT command. You need to do by CREATE USER and […]

Categories
MySQL

Import file size limit in PHPMyAdmin

Performance tuning is very important and there are still a lot of question around, here our tips to help base on our experience. Import file size limit in PHPMyAdmin For uploading large files through PHPMyAdmin, follow these steps: Step 1: Open your php.ini file. Step 2: Upgrading Memory Limit: memory_limit = 750M Step 3: Upgrading […]

Categories
MySQL

How to fix “Current Profile Has no WMI enable” – MySQL Workbench

On My SQL Workbench 5.x or 6.x, to manage the administration stuff such as import/export. Somehow, you could face an error when click on those admin tool: Current Profile Has no WMI enable Solution To solve this, it’s simply :   On MySQL Workbench: Server Administration (on the right column) Click Manage Server Instances Select […]

Categories
MySQL

[MySQL] Illegal mix of collations – Solved in direct request

In case, you have executed some request as following example UPDATE `td_invoice_zzz` zi, ts_zone zo SET `zzz_com_zon_id` = zo.zon_id WHERE zzz_com_zon_code = zo.zon_code; And you receive the error about illegal mix of collations as: Error Code: 1267. Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' You are trying to compare two fields that […]

Categories
Drupal MySQL PHP

My Recommendation Performance Settings [Drupal]

I posted some posts about drupal since I started to implement things with drupal. Issue with “Maximum execution time“ Issue with “MySQL server has gone away“ And still with memory “The InnoDB memory heap“ Here is my own recommendation for Drupal or some heavy PHP/MySQL application. php.ini max_execution_time=5000 memory_limit=1024M my.ini [mysqld] max_allowed_packet = 128m sort_buffer_size […]

Categories
MySQL

MySQL: The InnoDB memory heap is disabled

When you start your MySQL server, check in the log, you might found this warning message: [Note] InnoDB: The InnoDB memory heap is disabled The memory heap is related to performance of the MySQL with engine of InnoDB Solutions The issue would be solved by provide the setting in my.cnf/my.ini as [mysqld] # Comment the […]

Categories
MySQL

MySQL server has gone away, Issue & Solution [drupal]

MySQL server has gone away, issue on drupal, drupal ecommerce kickstart gives me alot of headache since I do not first aware that the issue because of there are so many packets execution on mysql with drupal. The full error is (or similar): Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error: […]

Categories
MySQL

MySQL Workbench 6.x Preview

MySQL Workbench, a visual editor for MySQL database, one of the free and popular tool to manage database and modeling. MySQL Workbench version 6.x has been release since July 2013 after a long running of version 5.x. Here are some screenshot of MySQL Workbench 6.0.8 that I just installed: Learn more.

Categories
MySQL

MySQL issue & Solution: Illegal mix of collations for operation ‘=’

MySQL Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Overview I have two databases in mysql, I have written a sql to compare two table (dbA.contact & dbB.actor). Example: SELECT dbB.* FROM dbA.contact co, dbB.actor ac WHERE co.name = ac.name When I execute the request, I will get above error, why it […]