普通的建表
CREATE TABLE scores (
student_id INT,
course_id INT,
score INT COMMENT ‘得分’,
semester VARCHAR(50) COMMENT ‘学期’,
PRIMARY KEY (student_id, course_id),
FOREIGN KEY (student_id) REFERENCES students(student_id),
FOREIGN KEY (course_id) REFERENCES courses(course_id)
) COMMENT ‘学生成绩表’;
但是报错：SQL 错误 [1142] [42000]: REFERENCES command denied to user ‘xxx’@’%’ for table ‘students’
于是想给这个xxx授权references，请问如何操作
