温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

Linux服务器---使用mysql

发布时间:2020-08-11 01:49:48 来源:ITPUB博客 阅读:127 作者:一生有你llx 栏目:建站服务器

使用mysql

1 、登录,可以用密码登录,也可以不用密码登录。命令格式“mysql –u 用户名 –p 密码”

[root@localhost src]#  mysql -u root      // 有密码登录

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 3

[root@localhost src]#  mysql -u root          // 无密码登录

 

2 、退出,命令“quit” 

[root@localhost bin]#  quit

 

3 、创建数据库,命令“create database 数据库名称;”,注意这个命令后面有分号

mysql>  create database test1;

Query OK, 1 row affected (0.00 sec)

 

4 、查看数据库,命令“show databases;”

mysql>  show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| test               |

| test1              |

+--------------------+

4 rows in set (0.00 sec)

 

5 、删除数据库,命令“drop database 数据库名称;”

mysql>  drop database test1;

Query OK, 0 rows affected (0.01 sec)

 

6 、设置权限 

mysql 允许给某个特定的用户赋予指定的权利,而且可以指定在某台机器上使用。Mysql的权限如下

权限

数据库

Table

Column

说明

all privileges



所有权利

alter


增减、删除、修改列

create


创建数据库、表

delete


删除行

drop


删除表、数据库

file



操作文件

index


索引

insert

插入

process



查看线程、连接

reference



创建外键

reload



重新加载,拥有此权限可以刷新表

select

选择

shutdown



关闭

update

更新

usage



无权限,只能连接

 

1 )授权用户权限,命令格式“grant 权限on 数据库文件to 用户名@ip identified by ‘密码’;”。在使用grant的时候,如果用户不存在,那么久创建用户。

// david 在本机授权插入功能,密码 123456 ,只能对 test01 操作

mysql>  grant insert on test01.* to david@localhost identified by '123456';

Query OK, 0 rows affected (0.00 sec)

mysql> 

// david 所有权限,在所有的主机都可以操作,而且可以操作任意数据库

mysql>  grant all privileges on *.* to david@'%' identified by '123456';

Query OK, 0 rows affected (0.00 sec)

mysql>

2 )查看当前数据库所有授权情况,命令“select host,user from mysql.user” 

mysql>  select host,user from mysql.user;

+-----------------------+-------+

| host                  | user  |

+-----------------------+-------+

| %                     | david |

| 127.0.0.1             | root  |

| localhost             |       |

| localhost             | david |

| localhost             | root  |

| localhost.localdomain |       |

| localhost.localdomain | root  |

+-----------------------+-------+

7 rows in set (0.00 sec)

mysql> 

3 )查看当前登录用户的权利,命令“show grants” 

mysql>  show grants;

+----------------------------------------------------------------------------------------------------------------------------------------+

| Grants for root@localhost                                                                                                             |

+----------------------------------------------------------------------------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*1256939B1977AFF6C3D114C5594EE354EF363A8B' WITH GRANT OPTION |

+----------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

mysql> 

4 )查看某个用户在某台机器的权限,命令“show grants for user@ip” 

mysql>  show grants for david@localhost;

+--------------------------------------------------------------------------------------------------------------+

| Grants for david@localhost                                                                                  |

+--------------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'david'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' |

| GRANT INSERT ON `test01`.* TO 'david'@'localhost'                                                            |

+--------------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

mysql> 

5 )删除用户的权限,命令“revoke 权限on  数据库文件  from  user@ip”

mysql>  revoke all privileges on *.* from david@'%'; 

Query OK, 0 rows affected (0.00 sec)

 

mysql>  show grants for david@localhost;        // 删除之后查看一下

+--------------------------------------------------------------------------------------------------------------+

| Grants for david@localhost                                                                                  |

+--------------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'david'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' |

+--------------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

mysql>         

6 )删除用户,命令“delete from user where user=‘username’”

mysql>  use mysql;       // 首先要调用这个命令

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

 

mysql>  delete from user where user='david';    // 删除用户

Query OK, 2 rows affected (0.00 sec)

 

mysql>  select host,user from mysql.user;     // 查看用户

+-----------------------+------+

| host                  | user |

+-----------------------+------+

| 127.0.0.1             | root |

| localhost             |      |

| localhost             | root |

| localhost.localdomain |      |

| localhost.localdomain | root |

+-----------------------+------+

5 rows in set (0.00 sec)

mysql> 


做了一个Linux学习的平台,目前出来一个雏形,各位可以参考使用
链接: https://pan.baidu.com/s/1GOLVU2CbpBNGtunztVpaCQ   密码:n7bk

Linux服务器---使用mysql



向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI