使用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

創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎

總結

以上是生活随笔為你收集整理的在服务器使用mysql_Linux服务器---使用mysql的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。