Linux服务器---使用mysql
使用MySQL
创新互联建站是一家集网站建设,夏津企业网站建设,夏津品牌网站建设,网站定制,夏津网站建设报价,网络营销,网络优化,夏津网站推广为一体的创新建站企业，帮助传统企业提升企业形象加强企业竞争力。可充分满足这一群体相比中小企业更为丰富、高端、多元的互联网需求。同时我们时刻保持专业、时尚、前沿，时刻以成就客户成长自我，坚持不断学习、思考、沉淀、净化自己，让我们为更多的企业打造出实用型网站。
1
、登录，可以用密码登录，也可以不用密码登录。命令格式“mysql –u 用户名 –p 密码”
[root@localhost src]#
mysql -u root
–
p
//
有密码登录
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
当前网址：
http://kswjz.com/article/gsjids.html
扫二维码与项目经理沟通
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流
