Ubuntu18.04 linux系统安装JDK与Mysql的方法
平台部署
一、安装JDK
step1.下载OracleJDK
step2.解压
step3.加入环境变量
具体操作如下：
lemon@ubuntu:~$cd~/download/
lemon@ubuntu:~/download$wgethttps://download.oracle.com/otn-pub/java/jdk/13.0.2+8/d4173c853231432d94f001e99d882ca7/jdk-13.0.2_linux-x64_bin.tar.gzlemon@ubuntu:~/download$tarvxfjdk-8u191-linux-x64.tar.gz
lemon@ubuntu:~/download$ls#查看当前目录下的文件
jdk1.8.0_191jdk-8u191-linux-x64.tar.gz
lemon@ubuntu:~/download$sudomvjdk1.8.0_191//usr/local/jdk1.8/#将jdk1.8.0_191文件夹移动到/usr/local/下并重命名为jdk1.8
lemon@ubuntu:~/download$sudovim/etc/profile#编辑环境变量
在环境变量末尾加入如下内容:
exportJAVA_HOME=/usr/local/jdk1.8
exportJRE_HOME=${JAVA_HOME}/jre
exportCLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib
exportPATH=.:${JAVA_HOME}/bin:$PATH
保存后重新加载环境变量，使生效：
lemon@ubuntu:~/download$source/etc/profile#刷新环境变量，使生效
lemon@ubuntu:~$java-version#输入java-version，如显示以下信息，则JDK安装成功
javaversion"1.8.0_191"
Java(TM)SERuntimeEnvironment(build1.8.0_191-b12)
JavaHotSpot(TM)64-BitServerVM(build25.191-b12,mixedmode)
二、安装MySQL
step1.安装MySQL并配置
step2.创建数据库与表
由于在安装Ubuntu系统时，本人选择了安装LAMP服务，所以MySQL已安装完成，仅需设置即可启用。
测试是否安装：
lemon@ubuntu:~$mysql#输入mysql，如出现以下提示，说明已安装mysql
ERROR1045(28000):Accessdeniedforuser'lemon'@'localhost'(usingpassword:NO)
如未安装：
lemon@ubuntu:~$sudoapt-getinstallmysql-server
lemon@ubuntu:~$sudoaptisntallmysql-client
lemon@ubuntu:~$sudoaptinstalllibmysqlclient-dev
如已安装：
lemon@ubuntu:~$sudomysql_secure_installation
两者都会进入MySQL设置过程，具体设置内容如下：
#1
VALIDATEPASSWORDPLUGINcanbeusedtotestpasswords...
Pressy|YforYes,anyotherkeyforNo:N(不启用弱密码检查）
#2
Pleasesetthepasswordforroothere...
Newpassword:(设置root密码)
Re-enternewpassword:(重复输入)
#3
Bydefault,aMySQLinstallationhasananonymoususer,
allowinganyonetologintoMySQLwithouthavingtohave
auseraccountcreatedforthem...
Removeanonymoususers?(Pressy|YforYes,anyotherkeyforNo):Y(不启用匿名用户)
#4
Normally,rootshouldonlybeallowedtoconnectfrom
'localhost'.Thisensuresthatsomeonecannotguessat
therootpasswordfromthenetwork...
Disallowrootloginremotely?(Pressy|YforYes,anyotherkeyforNo):Y(不允许root远程登陆)
#5
Bydefault,MySQLcomeswithadatabasenamed'test'that
anyonecanaccess...
Removetestdatabaseandaccesstoit?(Pressy|YforYes,anyotherkeyforNo):N
#6
Reloadingtheprivilegetableswillensurethatallchanges
madesofarwilltakeeffectimmediately.
Reloadprivilegetablesnow?(Pressy|YforYes,anyotherkeyforNo):Y(立刻刷新权限表)
Alldone!
接下来进入进入MySQL进行操作：
#最新版的MySQL安装之后无法使用密码进行登陆，需要sudo登录修改登录方式
lemon@ubuntu:~$sudomysql-uroot-p
Enterpassword:（空密码）
mysql>
mysql>UPDATEmysql.userSETauthentication_string=PASSWORD('LEMON'),plugin='mysql_native_password'WHEREuser='root';
mysql>FLUSHPRIVILEGES;
mysql>exitlemon@ubuntu:~$sudoservicemysqlrestart
lemon@ubuntu:~$mysql-uroot-p
Enterpassword:（上一步设置的密码，PASSWORD括号内的）
mysql>CREATEDATABASEnutch;
mysql>USEnutch
mysql>CREATETABLE`webpage`(
`id`varchar(767)NOTNULL,
`headers`blob,
`text`mediumtextDEFAULTNULL,
`status`int(11)DEFAULTNULL,
`markers`blob,
`parseStatus`blob,
`modifiedTime`bigint(20)DEFAULTNULL,
`score`floatDEFAULTNULL,
`typ`varchar(32)CHARACTERSETlatin1DEFAULTNULL,
`baseUrl`varchar(767)DEFAULTNULL,
`content`longblob,
`title`varchar(2048)DEFAULTNULL,
`reprUrl`varchar(767)DEFAULTNULL,
`fetchInterval`int(11)DEFAULTNULL,
`prevFetchTime`bigint(20)DEFAULTNULL,
`inlinks`mediumblob,
`prevSignature`blob,
`outlinks`mediumblob,
`fetchTime`bigint(20)DEFAULTNULL,
`retriesSinceFetch`int(11)DEFAULTNULL,
`protocolStatus`blob,
`signature`blob,
`metadata`blob,
`batchId`varchar(767)DEFAULTNULL,
PRIMARYKEY(`id`)
)ENGINE=InnoDB
ROW_FORMAT=COMPRESSED
DEFAULTCHARSET=utf8mb4;
mysql>exit
*最新版本默认情况下，MySQL是不允许远程登录的，如需远程访问需要做一些修改：
lemon@ubuntu:~$sudovim/etc/mysql/mysql.conf.d/mysqld.cnf
#将bind-address=127.0.0.1注释掉，重启MySQL服务
lemon@ubuntu:~$sudoservicemysqldstart
接下来就可以通过Navicat等软件，在其他计算机访问数据库了。
这样就Ok了