为什么在MySQL 8.0中无法再从表"groups“中选择数据

GRANT SELECT ON database_name.groups TO 'username'@'host';
FLUSH PRIVILEGES;

SHOW TABLES LIKE 'groups';

CREATE TABLE groups (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

mycursor.execute("SELECT * FROM groups")

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

SHOW TABLE STATUS WHERE Name = 'groups';

ALTER TABLE groups ENGINE=InnoDB;

SELECT * FROM information_schema.INNODB_TRX;

KILL TRANSACTION trx_id;