Ubuntu18.04 linux系统安装JDK与Mysql的方法
<p>平台部署</p>
<p>
一、安装JDK</p>
<p>
step1.下载OracleJDK<br>
step2. 解压<br>
step3. 加入环境变量</p>
<p>
具体操作如下：</p>
<blockquote>
<p>
lemon@ubuntu:~$ cd ~/download/<br>
lemon@ubuntu:~/download$ wget https://download.oracle.com/otn-pub/java/jdk/13.0.2+8/d4173c853231432d94f001e99d882ca7/jdk-13.0.2_linux-x64_bin.tar.gz</p>
<p>
lemon@ubuntu:~/download$ tar vxf jdk-8u191-linux-x64.tar.gz<br>
lemon@ubuntu:~/download$ ls #查看当前目录下的文件<br>
jdk1.8.0_191 jdk-8u191-linux-x64.tar.gz<br>
lemon@ubuntu:~/download$ sudo mv jdk1.8.0_191/ /usr/local/jdk1.8/ #将jdk1.8.0_191文件夹移动到/usr/local/下并重命名为jdk1.8<br>
lemon@ubuntu:~/download$ sudo vim /etc/profile #编辑环境变量</p>
</blockquote>
<p>
在环境变量末尾加入如下内容:</p>
<blockquote>
<p>
export JAVA_HOME=/usr/local/jdk1.8<br>
export JRE_HOME=${JAVA_HOME}/jre<br>
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib<br>
export PATH=.:${JAVA_HOME}/bin:$PATH</p>
</blockquote>
<p>
保存后重新加载环境变量，使生效：</p>
<blockquote>
<p>
lemon@ubuntu:~/download$ source /etc/profile #刷新环境变量，使生效<br>
lemon@ubuntu:~$ java -version#输入java -version，如显示以下信息，则JDK安装成功<br>
java version "1.8.0_191"<br>
Java(TM) SE Runtime Environment (build 1.8.0_191-b12)<br>
Java HotSpot(TM) 64-Bit Server VM (build 25.191-b12, mixed mode)</p>
</blockquote>
<p>
<strong>二、安装MySQL</strong></p>
<p>
step1. 安装MySQL并配置<br>
step2. 创建数据库与表</p>
<p>
由于在安装Ubuntu系统时，本人选择了安装LAMP服务，所以MySQL已安装完成，仅需设置即可启用。</p>
<p>
测试是否安装：</p>
<p>
lemon@ubuntu:~$ mysql #输入mysql，如出现以下提示，说明已安装mysql<br>
ERROR 1045 (28000): Access denied for user 'lemon'@'localhost' (using password: NO)</p>
<p>
如未安装：</p>
<blockquote>
<p>
lemon@ubuntu:~$ sudo apt-get install mysql-server<br>
lemon@ubuntu:~$sudo apt isntall mysql-client<br>
lemon@ubuntu:~$sudo apt install libmysqlclient-dev</p>
</blockquote>
<p>
如已安装：</p>
<p>
lemon@ubuntu:~$ sudo mysql_secure_installation</p>
<p>
两者都会进入MySQL设置过程，具体设置内容如下：</p>
<p>
#1<br>
VALIDATE PASSWORD PLUGIN can be used to test passwords...<br>
Press y|Y for Yes, any other key for No: N(不启用弱密码检查）</p>
<p>
#2<br>
Please set the password for root here...<br>
New password: (设置root密码)<br>
Re-enter new password: (重复输入)</p>
<p>
#3<br>
By default, a MySQL installation has an anonymous user,<br>
allowing anyone to log into MySQL without having to have<br>
a user account created for them...<br>
Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y(不启用匿名用户)</p>
<p>
#4<br>
Normally, root should only be allowed to connect from<br>
'localhost'. This ensures that someone cannot guess at<br>
the root password from the network...<br>
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y (不允许root远程登陆)</p>
<p>
#5<br>
By default, MySQL comes with a database named 'test' that<br>
anyone can access...<br>
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N</p>
<p>
#6<br>
Reloading the privilege tables will ensure that all changes<br>
made so far will take effect immediately.<br>
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (立刻刷新权限表)</p>
<p>
All done!</p>
<p>
接下来进入进入MySQL进行操作：</p>
<blockquote>
<p>
#最新版的MySQL安装之后无法使用密码进行登陆，需要sudo登录修改登录方式<br>
lemon@ubuntu:~$ sudo mysql -uroot -p<br>
Enter password: （空密码）<br>
mysql><br>
mysql>UPDATE mysql.user SET authentication_string=PASSWORD('LEMON'), plugin='mysql_native_password' WHERE user='root';<br>
mysql> FLUSH PRIVILEGES;<br>
mysql>exit</p>
<p>
lemon@ubuntu:~$ sudo service mysql restart<br>
lemon@ubuntu:~$ mysql -u root -p<br>
Enter password: （上一步设置的密码，PASSWORD括号内的）<br>
mysql>CREATE DATABASE nutch;<br>
mysql>USE nutch<br>
mysql> CREATE TABLE `webpage` (<br>
`id` varchar(767) NOT NULL,<br>
`headers` blob,<br>
`text` mediumtext DEFAULT NULL,<br>
`status` int(11) DEFAULT NULL,<br>
`markers` blob,<br>
`parseStatus` blob,<br>
`modifiedTime` bigint(20) DEFAULT NULL,<br>
`score` float DEFAULT NULL,<br>
`typ` varchar(32) CHARACTER SET latin1 DEFAULT NULL,<br>
`baseUrl` varchar(767) DEFAULT NULL,<br>
`content` longblob,<br>
`title` varchar(2048) DEFAULT NULL,<br>
`reprUrl` varchar(767) DEFAULT NULL,<br>
`fetchInterval` int(11) DEFAULT NULL,<br>
`prevFetchTime` bigint(20) DEFAULT NULL,<br>
`inlinks` mediumblob,<br>
`prevSignature` blob,<br>
`outlinks` mediumblob,<br>
`fetchTime` bigint(20) DEFAULT NULL,<br>
`retriesSinceFetch` int(11) DEFAULT NULL,<br>
`protocolStatus` blob,<br>
`signature` blob,<br>
`metadata` blob,<br>
`batchId`varchar(767)DEFAULT NULL,<br>
PRIMARY KEY (`id`)<br>
) ENGINE=InnoDB<br>
ROW_FORMAT=COMPRESSED<br>
DEFAULT CHARSET=utf8mb4;<br>
mysql>exit</p>
</blockquote>
<p>
*最新版本默认情况下，MySQL是不允许远程登录的，如需远程访问需要做一些修改：</p>
<blockquote>
<p>
lemon@ubuntu:~$sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf<br>
#将bind-address = 127.0.0.1注释掉，重启MySQL服务<br>
lemon@ubuntu:~$sudo service mysqld start</p>
</blockquote>
<p>
接下来就可以通过Navicat等软件，在其他计算机访问数据库了。</p>
<p>
<img style="max-width:100%!important;height:auto!important;"title="Ubuntu18.04 linux系统安装JDK与Mysql的方法" alt="Ubuntu18.04 linux系统安装JDK与Mysql的方法" src="https://zhuji.jb51.net/uploads/img/202305/9efe42d0065abb4470b83ca2b4534476.jpg"></p>
<p>
这样就Ok了</p>
頁:
[1]