Mysql 5.0

Front 1

what is the command line prompt to connect to a mysql server on localhost as the user root?

Back 1

mysql -h 'localhost' -u 'root' -p

Front 2

how do you know when you are connected to the mysql server?

Back 2

the prompt changes to:

mysql>

Front 3

what is the syntax that will tell you what version of mysql you are running?

Back 3

mysql> select version();

Front 4

what is the syntax to determine what databases are running on the mysql server?

Back 4

mysql> show databases;

Front 5

what command do you issue to set the default database to default_db?

Back 5

mysql> use default_db;

Front 6

what are the two syntaxes for getting the version of mysql

Back 6

mysql> select version();
cmd> mysql --version

Front 7

What is mysqldump used for?

Back 7

The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server).

Hint 7

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Front 8

To get a consistent backup, what 2 things should you do first?

Back 8

lock tables
flush tables

Hint 8

http://dev.mysql.com/doc/refman/5.0/en/backup.html

Front 9

Normally, how does mysqldump treat the first name argument on the command line?

Back 9

Normally, mysqldump treats the first name argument on the command line as a database name and following names as table names.

Hint 9

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html find on page -B

Front 10

What is the -B option used for?

Back 10

Dump several databases.

Normally, mysqldump treats the first name argument on the command line as a database name and following names as table names.

With this option -B, it treats all name arguments as database names.

CREATE DATABASE and USE statements are included in the output before each new database.

Hint 10

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html find on page -B

Front 11

What command line do you issue to determine which database is in use?

Back 11

mysql> select database();

Hint 11

http://dev.mysql.com/doc/refman/5.0/en/creating-database.html

Front 12

What command line do you issue to see the tables in a database?

Back 12

mysql> SHOW TABLES;

Hint 12

http://dev.mysql.com/doc/refman/5.0/en/creating-tables.html

Front 13

What command line do you issue to see a table's schema?

Back 13

mysql> DESCRIBE <tbl_name>;

Hint 13

http://dev.mysql.com/doc/refman/5.0/en/creating-tables.html

Front 14

In the mySQL reference, where do you look for more information on mysql privileges tables?

Back 14

5.4. The MySQL Access Privilege System

Hint 14

http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html

Front 15

When you run a client program that connects to the server, MySQL access control involves what?

Back 15

2 stages:

Stage 1: The server accepts or rejects the connection based on your identity and whether you can verify your identity by supplying the correct password.
Stage 2: Assuming that you can connect, the server checks each statement you issue to determine whether you have sufficient privileges to perform it.

Hint 15

http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html

Front 16

what command line do you issue to see a list of users?

Back 16

mysql> select user, host from user;

Front 17

what command line do you issue to see what grants the user has?

Back 17

SHOW GRANTS FOR 'joe'@'office.example.com';

Hint 17

http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html

Front 18

what table contains the users?

Back 18

user

Front 19

When the user's host is %, what does that mean?

Back 19

The user was created without a host value.

Hint 19

http://dev.mysql.com/doc/refman/5.0/en/create-user.html

Front 20

How does mysql server determine a user's identity?

Back 20

identity is determined by the host from which you connect and the user name you specify

Hint 20

http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html