2023學年完整公開課版2MariaDB數(shù)據(jù)庫

Mariadb安全管理目錄登錄及退出創(chuàng)建與刪除顯示結(jié)構(gòu)插入與維護2登錄及退出MariaDB環(huán)境

連接并登錄到MariaDB操作環(huán)境3[root@www~]#mysql-urootWelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis21Serverversion:5.0.56-logSourcedistributionType'help;'or'\h'forhelp.Type'\c'toclearthebuffer.mysql>exitBye[root@www~]#mysqladmin-urootpassword"123456"未指定-p選項時表示不需要密碼驗證顯示數(shù)據(jù)庫結(jié)構(gòu)

查看數(shù)據(jù)庫列表信息4mysql>SHOWDATABASES;+--------------------+|Database|+--------------------+|information_schema||mysql||test|+--------------------+3rowsinset(0.00sec)初始化后默認的3個庫使用名為mysql的庫查看有哪些表查看mysql庫中的user表結(jié)構(gòu)顯示數(shù)據(jù)庫結(jié)構(gòu)

查看數(shù)據(jù)庫列表信息5初始化后默認的3個庫mysql>USEmysql;Databasechangedmysql>SHOWTABLES;+---------------------------+|Tables_in_mysql|+---------------------------+|columns_priv||db|…………|user|+---------------------------+17rowsinset(0.00sec)使用名為mysql的庫查看有哪些表查看mysql庫中的user表結(jié)構(gòu)顯示數(shù)據(jù)庫結(jié)構(gòu)

查看數(shù)據(jù)庫列表信息6初始化后默認的3個庫使用名為mysql的庫查看有哪些表mysql>DESCRIBEmysql.user;+-----------------------+-----------------------------+------+-----+---------+-------+|Field|Type|Null|Key|Default|Extra|+-----------------------+-----------------------------+------+-----+---------+-------+|Host|char(60)|NO|PRI||||User|char(16)|NO|PRI||||Password|char(41)|NO|||||Select_priv|enum('N','Y')|NO||N|||Insert_priv|enum('N','Y')|NO||N……查看mysql庫中的user表結(jié)構(gòu)數(shù)據(jù)庫的創(chuàng)建與刪除創(chuàng)建新的數(shù)據(jù)庫7mysql>CREATEDATABASEauth;QueryOK,1rowaffected(0.01sec)mysql>USEauth;mysql>CREATETABLEusers(user_nameCHAR(30)NOTNULL,user_passwdCHAR(20)NOTNULLDEFAULT'123456',PRIMARYKEY(user_name));QueryOK,0rowsaffected(0.01sec)創(chuàng)建users表創(chuàng)建auth庫數(shù)據(jù)庫的創(chuàng)建與刪除創(chuàng)建新的數(shù)據(jù)庫8mysql>DROPTABLEauth.users;QueryOK,0rowsaffected(0.00sec)mysql>DROPDATABASEauth;QueryOK,0rowsaffected(0.01sec)刪除users表刪除auth庫數(shù)據(jù)庫的創(chuàng)建與刪除創(chuàng)建新的數(shù)據(jù)庫9mysql>DESCRIBEusers;+--------------------+--------------+--------+-------+------------+---------+|Field|Type|Null|Key|Default|Extra|+--------------------+--------------+--------+-------+------------+---------+|user_name|char(30)|NO|PRI|NULL|||user_passwd|char(20)|NO||12345