Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Mysql Tidak bisa di running
saat di restart tiba tiba Mysql saya tidak bisa dirunning, dan sudah saya coba gk bisa juga
2017-02-27 14:45:42 6192 [Note] Plugin 'FEDERATED' is disabled.
D:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
2017-02-27 14:45:42 6192 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-02-27 14:45:42 184c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-02-27 14:45:42 6192 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-02-27 14:45:42 6192 [Note] InnoDB: The InnoDB memory heap is disabled
2017-02-27 14:45:42 6192 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-02-27 14:45:42 6192 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-02-27 14:45:42 6192 [Note] InnoDB: Not using CPU crc32 instructions
2017-02-27 14:45:42 6192 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-02-27 14:45:42 6192 [Note] InnoDB: Completed initialization of buffer pool
2017-02-27 14:45:43 6192 [Note] InnoDB: Highest supported file format is Barracuda.
2017-02-27 14:45:43 6192 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600614 in the ib_logfiles!
2017-02-27 14:45:43 6192 [Note] InnoDB: Database was not shutdown normally!
2017-02-27 14:45:43 6192 [Note] InnoDB: Starting crash recovery.
2017-02-27 14:45:43 6192 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-02-27 14:45:51 6192 [Note] InnoDB: Restoring possible half-written data pages
2017-02-27 14:45:51 6192 [Note] InnoDB: from the doublewrite buffer...
2017-02-27 14:45:51 6192 [Note] InnoDB: 128 rollback segment(s) are active.
2017-02-27 14:45:52 6192 [Note] InnoDB: Waiting for purge to start
2017-02-27 14:45:52 6192 [Note] InnoDB: 5.6.16 started; log sequence number 1600614
2017-02-27 14:45:52 6192 [Note] Server hostname (bind-address): '*'; port: 3307
2017-02-27 14:45:52 6192 [Note] IPv6 is available.
2017-02-27 14:45:52 6192 [Note] - '::' resolves to '::';
2017-02-27 14:45:52 6192 [Note] Server socket created on IP: '::'.
2017-02-27 14:45:52 6192 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
Jika memang sudah tidak bisa, bagaimana cara agar saya instal ulang tampa menghilangkan database dan htdoc nya
3 Jawaban:
Habis upgrade mysqlnya gan? coba cek solusi disini gan, atur konfigurasinya lagi https://support.plesk.com/hc/en-us/articles/213954725-Mysql-service-does-not-start-with-Table-mysql-plugin-doesn-t-exist-error
masalahnya saya pake Windows Mas :D, gk tau kenapa tiba tiba gitu di Xampp saya coba instal ulang Program dan Windows Tetep gk bisa Mohon Solusinya 1 Project besar saya di sana :'
coba ganti port mysql nya gan , kemungkinan masalahnya udah pernah install mysql lain dan ada port yang tabrakan. Coba cari file my.ini ganti port nya misalnya sebelumnya 3306 jadi 3307