mysql community server 8.0.12安装配置方法图文教程
MySQL8带来了全新的体验,比如支持NoSQL、JSON等,拥有比MySQL5.7两倍以上的性能提升。本文讲解如何在Windows下安装MySQL8,以及基本的MySQL用法。
下载
下载地址
本例为:MySQLCommunityServer8.0.12。
解压
解压至安装目录,比如D盘根目录下。
本例为:D:\mysql-8.0.12-winx64。
创建my.ini
my.ini是MySQL安装的配置文件:
[mysqld] #安装目录 basedir=D:\\mysql-8.0.12-winx64 #数据存放目录 datadir=D:\\mysqlData\\data
my.ini放置在MySQL安装目录的根目录下。需要注意的是,要先创建D:\mysqlData目录。data目录是由MySQL来创建。
初始化安装
执行:
mysqld--defaults-file=D:\mysql-8.0.12-winx64\my.ini--initialize--console
控制台输出如下,说明安装成功:
>mysqld--defaults-file=D:\mysql-8.0.12-winx64\my.ini--initialize--console 2018-08-20T16:14:45.287448Z0[System][MY-013169][Server]D:\mysql-8.0.12-winx64\bin\mysqld.exe(mysqld8.0.12)initializingofserverinprogressasprocess5012 2018-08-20T16:14:45.289628Z0[ERROR][MY-010457][Server]--initializespecifiedbutthedatadirectoryhasfilesinit.Aborting. 2018-08-20T16:14:45.299329Z0[ERROR][MY-010119][Server]Aborting 2018-08-20T16:14:45.301316Z0[System][MY-010910][Server]D:\mysql-8.0.12-winx64\bin\mysqld.exe:Shutdowncomplete(mysqld8.0.12)MySQLCommunityServer-GPL. D:\mysql-8.0.12-winx64\bin>mysqld--defaults-file=D:\mysql-8.0.12-winx64\my.ini--initialize--console 2018-08-20T16:15:25.729771Z0[System][MY-013169][Server]D:\mysql-8.0.12-winx64\bin\mysqld.exe(mysqld8.0.12)initializingofserverinprogressasprocess18148 2018-08-20T16:15:43.569562Z5[Note][MY-010454][Server]Atemporarypasswordisgeneratedforroot@localhost:L-hk!rBuk9-. 2018-08-20T16:15:55.811470Z0[System][MY-013170][Server]D:\mysql-8.0.12-winx64\bin\mysqld.exe(mysqld8.0.12)initializingofserverhascompleted
其中,“L-hk!rBuk9-.”就是root用户的初始化密码。稍后可以做更改。
启动、关闭MySQLserver
执行mysqld就能启动MySQLserver,或者执行mysqld–console可以看到完整的启动信息:
>mysqld--console 2018-08-20T16:18:23.698153Z0[Warning][MY-010915][Server]'NO_ZERO_DATE','NO_ZERO_IN_DATE'and'ERROR_FOR_DIVISION_BY_ZERO'sqlmodesshouldbeusedwithstrictmode.Theywillbemergedwithstrictmodeinafuturerelease. 2018-08-20T16:18:23.698248Z0[System][MY-010116][Server]D:\mysql-8.0.12-winx64\bin\mysqld.exe(mysqld8.0.12)startingasprocess16304 2018-08-20T16:18:27.624422Z0[Warning][MY-010068][Server]CAcertificateca.pemisselfsigned. 2018-08-20T16:18:27.793310Z0[System][MY-010931][Server]D:\mysql-8.0.12-winx64\bin\mysqld.exe:readyforconnections.Version:'8.0.12'socket:''port:3306MySQLCommunityServer-GPL.
关闭,可以执行mysqladmin-urootshutdown。
使用MySQL客户端
使用mysql来登录,账号为root,密码为“L-hk!rBuk9-.”:
>mysql-uroot-p Enterpassword:************ WelcometotheMySQLmonitor.Commandsendwith;or\g. YourMySQLconnectionidis11 Serverversion:8.0.12 Copyright(c)2000,2018,Oracleand/oritsaffiliates.Allrightsreserved. OracleisaregisteredtrademarkofOracleCorporationand/orits affiliates.Othernamesmaybetrademarksoftheirrespective owners. Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.
执行下面的语句来改密码。其中“123456”即为新密码。
mysql>ALTERUSER'root'@'localhost'IDENTIFIEDBY'123456'; QueryOK,0rowsaffected(0.13sec)
MySQL常用指令
显示已有的数据库:
mysql>showdatabases; +--------------------+ |Database| +--------------------+ |information_schema| |mysql| |performance_schema| |sys| +--------------------+ 4rowsinset(0.08sec)
创建新的数据库:
mysql>CREATEDATABASElite; QueryOK,1rowaffected(0.19sec)
使用数据库:
mysql>USElite; Databasechanged
建表:
建表执行:
mysql>CREATETABLEt_user(user_idBIGINTNOTNULL,usernameVARCHAR(20)); QueryOK,0rowsaffected(0.82sec)
查看表:
查看数据库中的所有表:
mysql>SHOWTABLES; +----------------+ |Tables_in_lite| +----------------+ |t_user| +----------------+ 1rowinset(0.00sec)
查看表的详情:
mysql>DESCRIBEt_user; +----------+-------------+------+-----+---------+-------+ |Field|Type|Null|Key|Default|Extra| +----------+-------------+------+-----+---------+-------+ |user_id|bigint(20)|NO||NULL|| |username|varchar(20)|YES||NULL|| +----------+-------------+------+-----+---------+-------+ 2rowsinset(0.00sec)
插入数据:
mysql>INSERTINTOt_user(user_id,username)VALUES(1,'老卫'); QueryOK,1rowaffected(0.08sec)
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。