Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.20
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select user,host from mysql.user; ← 查看用户信息
+------+----------------------------+
| user | host |
+------+----------------------------+
| | localhost |
| | 127.0.0.1 |
| root | localhost |
| | sample.centospub.com |
| root | sample.centospub.com |
+------+----------------------------+
4 rows in set (0.02 sec)
mysql> delete from mysql.user where user=''; ← 删除匿名用户
Query OK, 2 rows affected (0.17 sec)
mysql> select user,host from mysql.user; ← 查看用户信息
+------+----------------------------+
| user | host |
+------+----------------------------+
| root | localhost |
| root | sample.centospub.com |
+------+----------------------------+
2 rows in set (0.00 sec)
mysql> exit ← 退出MySQL服务器
删除测试用数据库
在MySQL被安装后，存在名为test的空数据库，将它删除。这里要注意的是，系统默认的还有一个名为mysql的数据库，它用于系统管理，所以请不要删除。
[root@sample ~]# mysql -u root -p ← 通过密码用root登录
Enter password: ← 在这里输入密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.20
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases; ← 查看系统已存在的数据库
+-------------+
| Database |
+-------------+
| mysql |
| test |
+------------+
2 rows in set (0.02 sec)
mysql> drop database test; ← 删除名为test的空数据库
Query OK, 0 rows affected (0.07 sec)
mysql> show databases; ← 查看系统已存在的数据库
+-------------+
| Database |
+-------------+
| mysql | ← 确认名为test的数据库被删除，已不存在
+-------------+
1 row in set (0.00 sec)
mysql> exit ← 退出MySQL服务器
4、测试MySQL
下面对MySQL进行测试。包括建立新用户，以及用对关系性数据库进行数据库操作的指令来试着建立数据库及数据表，这里，新建用户以centospub为例。
[root@sample ~]# mysql -u root -p ← 通过密码用root登录
Enter password: ← 在这里输入密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.1.20
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all privileges on test.* to centospub@localhost identified by 'newpwd’; ← 建立对test数据库有完全操作权限的名为centospub的用户
Query OK, 0 rows affected (0.03 sec)
mysql> select user from mysql.user where user='centospub'; ← 确认centospub用户的存在与否
+---------+
| user |
+---------+
| centospub | ← 确认centospub已经被建立
+---------+
1 row in set (0.01 sec)
mysql> exit ← 退出MySQL服务器
[root@sample ~]# mysql -u centospub -p ← 用新建立的centospub用户登录MySQL服务器
Enter password: ← 在这里输入密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 4.1.20
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database test; ← 建立名为test的数据库
Query OK, 1 row affected (0.00 sec)
mysql> show databases; ← 查看系统已存在的数据库
+-------------+
| Database |
+-------------+
| test |
+-------------+
1 row in set (0.00 sec)
mysql> use test; ← 连接到数据库
Database changed
mysql> create table test(num int, name varchar(50)); ← 在数据库中建立表
Query OK, 0 rows affected (0.03 sec)
mysql> show tables; ← 查看数据库中已 在的表
+-------------------+
| Tables_in_test |
+-------------------+
| test |
+-------------------+
1 row in set (0.01 sec)
mysql> insert into test values(1,'Hello World!'); ← 插入一个值到表中
Query OK, 1 row affected (0.02 sec)
mysql> select * from test; ← 查看数据库中的表的信息
+------+-------------------+
| num | name |
+------+-------------------+
| 1 | Hello World! |
+------+-------------------+
1 row in set (0.00 sec)
mysql> update test set name='Hello Everyone!'; ← 更新表的信息，赋予新的值
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql