Recent Lessons

Show all results for ""

Feature Overview

Ace your exams with our all-in-one platform for creating and sharing quizzes and tests.

Quizzes

Create quizzes and tests automatically from your content using AI.

Flashcards

Automatically turn your notes into digital flashcards.

Share, Export & Embed

Share with classmates or export to Excel and your learning management system.

Stats & Reporting

Auto-grading quizzes and tests with detailed stats and reports.

Mobile Apps

The smarter way to study – wherever you are.

Pricing

Search...

10 Questions

0 Views

MySQL Brukeradministrasjon

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Kvar vert all informasjon om brukarnamn, passord og operasjonstilgang til databasen lagret når det gjeld MySQL?

I tabellen 'passwords' i databasen 'mysql'

I tabellen 'user' i databasen 'mysql' (correct)

I tabellen 'database' i databasen 'user'

I tabellen 'user' i databasen 'database'

Kva SQL-operasjon skal du bruke for å opprette ein ny brukar i MySQL?

UPDATE USER

INSERT INTO

ADD NEW USER

CREATE USER (correct)

Kva anna SQL-operasjon kan du bruke for å endre brukarnamnet til ein eksisterande brukar i MySQL?

RENAME USER (correct)

MODIFY USER

UPDATE USER

CHANGE USERNAME

Kva er ein tryggare måte å leggje til ein ny brukar i MySQL enn å leggje til ein ny rad direkte i tabellen?

Bruke INSERT-kommandoen med parameterisert spørring Signup and view all the answers

Kva er rett syntaks for å endre passordet til brukaren 'zhangsan' til '123456' i MySQL?

SET PASSWORD FOR zhangsan = '123456' Signup and view all the answers

如何查看当前 MySQL 数据库一共有多少用户？

使用 SELECT COUNT(*) FROM user; Signup and view all the answers

下列关于新增用户的说法，哪一项是正确的？

通过执行 CREATE USER [user_name] IDENTIFIED BY [user_pwd]; 来新增用户。 Signup and view all the answers

什么是修改用户名称的正确语法？

RENAME USER [user_name] TO [new_user_name]; Signup and view all the answers

为什么不建议直接在 MySQL 数据库中插入一条记录来新增用户？

可能会对 MySQL 服务器造成伤害。 Signup and view all the answers

以下哪个语句是正确修改 'zhangsan' 用户密码为 '123456' 的语法？

ALTER USER zhangsan IDENTIFIED BY '123456'; Signup and view all the answers