Phpmyadmin

1. Memperbesar ukuran import 

nano /etc/php/7.0/apache2/php.ini

Cari kata post_max_size dan rubah menjadi 1000M

XAMP: xampp/php/php.ini

2. sql-mod

masukan pada file conection

mysql_query("SET SESSION sql_mode = ''");

    

3. Tidak bisa login 

flush privileges

1. Masuk mysql -u root -p mysql

#mysql -u root -p mysql

2.update user mysql

mysql> update user set plugin='' where User='root'

3.masukkan perintah

mysql> flush privileges;

4. exit

Type in:

use MySQL;

Press Enter.

Set your MySQL password with the following command, replacing "EnterYourPasswordHere" with your new chosen password:

UPDATE mysql.user SET Password=PASSWORD("EnterYourPasswordHere") WHERE User="root";

Press Enter.

Flush the privileges by typing:

FLUSH PRIVILEGES;

Exit by typing:

Exit

5. DATABASE SPLIT

SQLDumpSplitter.exe

6. 

variable innodb_default_row_format = dynamic

innodb_strict_mode=OFF;

mysql> set global innodb_strict_mode=OFF;

mysql> set global innodb_default_row_format = dynamic

7. menyalin isi tabel 

INSERT INTO `table2` SELECT * FROM `table1`;

8.  2006, MySQL server has gone away

Raising it in /etc/my.cnf (under [mysqld]) to 8 or 16M usually fixes it. (The default in MySql 5.7 is 4194304, which is 4MB.)
[mysqld]
max_allowed_packet=16M

35
For xampp users, the my.cnf can be found at: C:\xampp\mysql\bin\ 
– Valentin Despa
 Nov 8, 2012 at 11:38

9 Script timeout passed, if you want to finish import, please resubmit the same file and import will resume.

o to xampp/phpMyAdmin/libraries/config.default.php find $cfg['ExecTimeLimit'] = 300; line no 695 and replace $cfg['ExecTimeLimit'] = 0; 

8. membuat index
   a. mengecek query
      show processlist;
   b. menambah index
      ALTER TABLE `nama_tabel` ADD INDEX(`nama_field`)
   c. menghapus  index
      ALTER TABLE `nama_tabel` DROP INDEX `nama_field`;

10. 

Solution 1 – [Solved] mysqli_real_connect(): (HY000/1698):

ALTER USER 'root'@'%' IDENTIFIED BY 'berikan password baru disini';

# jika ingin berjalan pada mesin kalian saja 
# bisa menggunakan perintah berikut.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password baru kalian';

# Jika kalian ingin berjalan pada jaringan kalian
# sehingga  bisa diakses remote dalam satu jaringan
# atau remote jarak jauh dengan IP Publik.

ALTER USER 'root'@'ip_address' IDENTIFIED BY 'password baru';