I'll start coding with JEE soon. Product environment adopts Oracle WebLogic in Linux, technology adopts EJB3 and JPA. So I'm going to set a development environment in my own computer with them. For iMac installing JDK, Eclipse or Maven wil
I'll start coding with JEE soon. Product environment adopts Oracle + WebLogic in Linux, technology adopts EJB3 and JPA. So I'm going to set a development environment in my own computer with them.
For iMac installing JDK, Eclipse or Maven will not be problem, but installing Oracle seems a impossible mission, now virtualbox become a very good choice.
Install VirtualBox
Download from https://www.virtualbox.org/, nothing special on installing. But it's really a magic tool.
Create a new Virtual Machine for Oracle Linux
You'd better to download a Oracle Linux 7 installer ISO file before starting this step. https://edelivery.oracle.com/linux. You need specify a installer ISO file during the process of creating virtual machine.
1. Name your virtual machine, choose the OS you will install later and set the size of memory.
2. Set the size of virtual machine's "hard disk". Click OK the virtual machine will be created.
You still need change's several basic settings. Select the virtual machine you just created, click "Settings" button on the top of VirtualBox Manager.
1. Specify the installer ISO file which will be installed onto this virtual machine later.
Storage --> Click CD ROM icon on right (Storage Tree) --> Click CD ROM icon on left (Attributes) --> Choose a virtual CD/DVD disk file --> Select the Oracle Linux installer which you downloaded in advance.
2. Enable network connection. This virtual machine will be assigned a IP address you can access from you computer after OS has been installed. For example, you can ssh this virtual machine.
3. All done, click OK.
Install Oracle Linux 7 in this Virtual Machine
1. Select VirtualBox you created former, click "Start" button on top
** Clicking "Left Command Button" can move your mouse cursor out of the installation screen.
2. Software Selection
3. Enable network connection
4. Reboot after complete installation, still need do some basic configurations.
- Enable Kdump
- Set up software update. I select "No, I prefer to register at a later time." because I don't purchase any oracle product...
Rmove OpenJDK
OpenJDK is default JVM in Oracle Linux. I see quite a lot of posts say simply run command "yum remove java*", but I'm not sure if this way is secure because wildcard is used, so it seems not really. I'm going to use software GUI to remove it.
After you login Oracle Linux-->Start menu-->System tools-->Software, search openjdk then remove packages.
Install Oracle JDK
1. Download 64bit jdk archive file
2. Extract it into /usr/lib
3. Add JAVA_HOME variable into /etc/profile. This jvm is enabled for all the users of this vm.
export JAVA_HOME=/usr/lib/jdk-1.8.0-xxx
export PATH=$PATH:$JAVA_HOME/bin

MySQLstringtypesimpactstorageandperformanceasfollows:1)CHARisfixed-length,alwaysusingthesamestoragespace,whichcanbefasterbutlessspace-efficient.2)VARCHARisvariable-length,morespace-efficientbutpotentiallyslower.3)TEXTisforlargetext,storedoutsiderows,

MySQLstringtypesincludeVARCHAR,TEXT,CHAR,ENUM,andSET.1)VARCHARisversatileforvariable-lengthstringsuptoaspecifiedlimit.2)TEXTisidealforlargetextstoragewithoutadefinedlength.3)CHARisfixed-length,suitableforconsistentdatalikecodes.4)ENUMenforcesdatainte

MySQLoffersvariousstringdatatypes:1)CHARforfixed-lengthstrings,2)VARCHARforvariable-lengthtext,3)BINARYandVARBINARYforbinarydata,4)BLOBandTEXTforlargedata,and5)ENUMandSETforcontrolledinput.Eachtypehasspecificusesandperformancecharacteristics,sochoose

TograntpermissionstonewMySQLusers,followthesesteps:1)AccessMySQLasauserwithsufficientprivileges,2)CreateanewuserwiththeCREATEUSERcommand,3)UsetheGRANTcommandtospecifypermissionslikeSELECT,INSERT,UPDATE,orALLPRIVILEGESonspecificdatabasesortables,and4)

ToaddusersinMySQLeffectivelyandsecurely,followthesesteps:1)UsetheCREATEUSERstatementtoaddanewuser,specifyingthehostandastrongpassword.2)GrantnecessaryprivilegesusingtheGRANTstatement,adheringtotheprincipleofleastprivilege.3)Implementsecuritymeasuresl

ToaddanewuserwithcomplexpermissionsinMySQL,followthesesteps:1)CreatetheuserwithCREATEUSER'newuser'@'localhost'IDENTIFIEDBY'password';.2)Grantreadaccesstoalltablesin'mydatabase'withGRANTSELECTONmydatabase.TO'newuser'@'localhost';.3)Grantwriteaccessto'

The string data types in MySQL include CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and TEXT. The collations determine the comparison and sorting of strings. 1.CHAR is suitable for fixed-length strings, VARCHAR is suitable for variable-length strings. 2.BINARY and VARBINARY are used for binary data, and BLOB and TEXT are used for large object data. 3. Sorting rules such as utf8mb4_unicode_ci ignores upper and lower case and is suitable for user names; utf8mb4_bin is case sensitive and is suitable for fields that require precise comparison.

The best MySQLVARCHAR column length selection should be based on data analysis, consider future growth, evaluate performance impacts, and character set requirements. 1) Analyze the data to determine typical lengths; 2) Reserve future expansion space; 3) Pay attention to the impact of large lengths on performance; 4) Consider the impact of character sets on storage. Through these steps, the efficiency and scalability of the database can be optimized.


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

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

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

Zend Studio 13.0.1
Powerful PHP integrated development environment

SublimeText3 Linux new version
SublimeText3 Linux latest version
