【若泽大数据基础第六天】基础-mysql-创建database和用户

创建database

登录MySQL数据库

• 使用mysql -u -p登录命令MySQL

hadoop614:mysqladmin:/usr/local/mysql:>mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 188
Server version: 5.6.23-log MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

• 查看数据库show database

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bigdata            |
| boblog             |
| mysql              |
| performance_schema |
| ruoze_d6           |
| ruozedata          |
| test               |
+--------------------+
8 rows in set (0.10 sec)

• 新建数据库create database testdata

mysql> create database testdata;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bigdata            |
| boblog             |
| mysql              |
| performance_schema |
| ruoze_d6           |
| ruozedata          |
| test               |
| testdata           |
+--------------------+
9 rows in set (0.00 sec)

创建用户

• 创建testuser用户：grant all privileges on testdata.* to testuser@'%' identified by '123456'

mysql> grant all privileges on testdata.* to testuser@'%' identified by '123456' ;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,password,host from user where user='testuser';
+----------+-------------------------------------------+------+
| user     | password                                  | host |
+----------+-------------------------------------------+------+
| testuser | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | %    |
+----------+-------------------------------------------+------+
1 row in set (0.00 sec)

使用testuser用户登录

mysql> exit;
Bye
hadoop614:mysqladmin:/usr/local/mysql:>mysql -utestuser -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 190
Server version: 5.6.23-log MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>