Nurah.lee

MySQL failed to start. The error.log file show log as below; 2024-08-18 20:45:04 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 22548 2024-08-18 20:45:04 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2024-08-18 20:45:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2024-08-18 20:45:04 0 [Note] InnoDB: Uses event mutexes 2024-08-18 20:45:04 0 [Note] InnoDB: Compressed tables use zlib 1.3 2024-08-18 20:45:04 0 [Note] InnoDB: Number of pools: 1 2024-08-18 20:45:04 0 [Note] InnoDB: Using SSE2 crc32 instructions 2024-08-18 20:45:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2024-08-18 20:45:04 0 [Note] InnoDB: Completed initialization of buffer pool 2024-08-18 20:45:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2024-08-18 20:45:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-08-18 20:45:04 0 [Note]

2024-05-26 12:20:54 0 [ERROR] mysqld: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed 2024-05-26 12:20:54 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed 2024-05-26 12:20:54 0 [ERROR] Aborting Refer Chatgpt :  https://chatgpt.com/share/73109e3b-a5c5-4b92-a51d-067ce10ffed3 The error message indicates that the proxies_priv table in the MySQL system database is corrupted and the automatic repair attempt has failed. This is preventing MariaDB from starting up because it cannot access the necessary privilege tables. Here's how you can manually repair the table and potentially resolve the issue: Steps to Repair the Corrupted Table Stop the MariaDB Server : Ensure that the MariaDB server is stopped before attempting to repair the table. You can stop the server from the XAMPP Control Panel or by running: net stop mysql Start MariaDB i

  Command >  mysql -u root > ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';

 https://learnsql.com/blog/join-tables-without-common-column/#:~:text=Yes%2C%20you%20can!,for%20merging%20tables%20in%20SQL.

Error :  Solution 1: Edit phpmyadmin config.inc.php File dir : C:\xampp2\phpMyAdmin\config.inc.php $cfg['Servers'][$i]['host'] = '127.0.0.1' Solution 2: Check windows host  File dir : C:\Windows\System32\drivers\etc\hosts

 SQLSTATE[HY000] [2006] MySQL server has gone away Cara untuk fix isu ni.. 1. Mula - mula check port mysql dulu. Check samada port duplicate atau tidak.  mysql> SHOW GLOBAL VARIABLES LIKE 'PORT'; Rujukan :  How to check what port mysql is running on 2. Allow connection from user and host mysql> GRANT ALL ON *.* to root@'127.0.0.1' IDENTIFIED BY 'root' Rujukan :  Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server 3. Change definer on view

Cara mudah untuk menukar format antara SQL. MSSQL ke MySQL. Di bawah ni Lee letak rujukan.  http://www.sqlines.com/online

Assalamualaikum korang. Hi gais. Untuk post kali ini… Lee nak kongsikan cara install MySQL di Centos 7. Sebelum tu Lee nak bagitahu yang versi MySQL 7 dan 8 agak berbeza. Cara install sama cuma part waktu nak connect tu nanti kena ubah setting sikit dekat MySQL. Ok jom kita start. 1. Mula – mula, kita kena pergi ke link https://dev.mysql.com/downloads/repo/yum/ Kita akan refer repo yang disenaraikan kat situ. Untuk reference gambar ni Lee download masa 23 March 2020. So kalau dah update ke apa ke korang boleh ikut yang macam dekat website tu. 2. Download repo guna command wget. Boleh refer kat gambar bawah ni. 3. Selesai download, perlu verify md5sum . Command rujuk rajah di bawah; Kita perlu rujuk sama ada md5 tu sama tak dengan yang di paparkan pada web. 4. Lepas kita verify, kita akan start install mysql-server. Pada directory yang ada software mysql yang kita download tadi. Kita boleh taip command sudo yum install mysql-server . 5. Setelah selesai install dan download de