Ubuntu 14.0.4 安装MySQL 和Java 八
Ubuntu 14.0.4 安装MySQL 和Java 8 安装Java (JDK 8) 1、下载JDK 从官网下载jdk8 jdk-8u5-linux-x64.tar.gz 2、解压 $ tar -zxvf jdk-8u5-linux-x64.tar.gz 解压出来是一个jdk1.8.0_05文件夹 3、将文件夹移动到安装目录 $ sudo mv jdk1.8.0_05 /usr/local/
Ubuntu 14.0.4 安装MySQL 和Java 8安装Java (JDK 8)
1、下载JDK 从官网下载jdk8
jdk-8u5-linux-x64.tar.gz
2、解压
$ tar -zxvf jdk-8u5-linux-x64.tar.gz
解压出来是一个jdk1.8.0_05文件夹
3、将文件夹移动到安装目录
$ sudo mv jdk1.8.0_05 /usr/local/
4、配置环境变量 ,更改/etc/profile文件
sudo gedit /etc/profile
在文件最后加上如下几行:
export JAVA_HOME=/usr/local/jdk1.8.0_05
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH
export CLASSPATH=$CLASSPATH:.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
5、更改默认配置选项 ,依次执行如下命令
sudo update-alternatives --install /usr/bin/java java /usr/local/jdk1.8.0_05/bin/java 300
sudo update-alternatives --install /usr/bin/javac javac /usr/local/jdk1.8.0_05/bin/javac 300
sudo update-alternatives --install /usr/bin/jar jar /usr/local/jdk1.8.0_05/bin/jar 300
sudo update-alternatives --install /usr/bin/javah javah /usr/local/jdk1.8.0_05/bin/javah 300
sudo update-alternatives --install /usr/bin/javap javap /usr/local/jdk1.8.0_05/bin/javap 300
安装MySQL
1.安装数据库:sudo apt-get install mysql-server
安装过程中需要设置密码。
2.安装客户端:sudo apt-get install mysql-client
3.登录MySQL:mysql -u root -p
4.配置文件:/etc/mysql/my.cnf
a.设置远程访问:将bind-address = 127.0.0.1中的127.0.0.1给为本机IP,这样能够使数据库支持网络远程访问。设置完成后,重启mysql服务:service mysql restart
b.数据库开启/关闭/重启等:/etc/init.d/mysql [start|stop|restart|reload|force-reload|status]
5.退出数据库:exit
6.卸载MySQL:
a.删除 mysql
1 sudo apt-get autoremove --purge mysql-server-5.0
2 sudo apt-get remove mysql-server
3 sudo apt-get autoremove mysql-server
4 sudo apt-get remove mysql-common

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.

SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.

Java's platform independence means that the code written can run on any platform with JVM installed without modification. 1) Java source code is compiled into bytecode, 2) Bytecode is interpreted and executed by the JVM, 3) The JVM provides memory management and garbage collection functions to ensure that the program runs on different operating systems.

AI can help optimize the use of Composer. Specific methods include: 1. Dependency management optimization: AI analyzes dependencies, recommends the best version combination, and reduces conflicts. 2. Automated code generation: AI generates composer.json files that conform to best practices. 3. Improve code quality: AI detects potential problems, provides optimization suggestions, and improves code quality. These methods are implemented through machine learning and natural language processing technologies to help developers improve efficiency and code quality.

To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.

MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.

HTML5 brings five key improvements: 1. Semantic tags improve code clarity and SEO effects; 2. Multimedia support simplifies video and audio embedding; 3. Form enhancement simplifies verification; 4. Offline and local storage improves user experience; 5. Canvas and graphics functions enhance the visualization of web pages.
