RHEL 6 platform MySQL Database Server Installation Method, rhelmysql
MySQL database is the most widely used database system in Linux. It can be easily integrated with other servers, such as Apache, Vsftpd, and Postfix. The following describes how to install the MySQL database server on RHEL 6.
1. Install the complete
When a new SCSI device is installed in Rhel 6, a disk drift may occur, such as the original system disk is/DEV/SDA, add new device, restart the system, the letter to the last, such as/DEV/SSDA.
The reason for the drift of disk character
In the Linux kernel, the SCSI hard drive letter assignment is related to the drive scan to the hard disk sequence, that is, the first scan to the hard drive letter is/DEV/
Install Wetty on CentOS/RHEL 6.X
What is Wetty?
Wetty = Web + tty
As a system administrator, if you are on a Linux desktop, you can use it to connect to a remote server like a GNOME terminal (or similar). If you are in Windows, you can use an SSH client such as Putty to connect to a remote computer, and then access the Internet in a browser and check emails.
(LCTT note: in short, this is a Web browser-based
new-m tcp-p TCP--dport 22-j ACCEPT-A input-j REJECT--reject-with icmp-host-prohibited-A forward-j REJECT--reject-with icmp-host-prohibitedCOMMITSave and exit the file. Restart the Iptables service:Service Iptables RestartIn CentOS 7, run the following command to allow the Telnet service to pass through the firewall.Firewall-cmd--permanent--add-port=23/tcpFirewall-cmd--reloadThat's it. Now the Telnet service is ready to use.Create userCreate a test user, for example, the username is "SK" and the
Rhel/centos 6 does not configure network interfaces on default installation. Also, it's configured to use NetworkManager. To enable networking interface and disable NetworkManager please follow instructions below.The/etc/sysconfig/network-scripts/ifcfg-eth0 content looks as follows on default installation.Device= "Eth0″HWADDR=SPECIFC MAC AddressNm_controlled= "Yes"Onboot= "NoFor DHCP, configure the interfac
RHEL 7 went into single-user mode and reset password mode has changed a lot, grub from B-boot into ctrl+x boot.
There are two ways to reset the password mainly rd.break and init.
Rd.break Method:
1, when starting, in the start interface, the corresponding startup items, the kernel name on the "E";
2, after entering, find linux16 the beginning of the place, press the "End" key to the final, input rd.break, press the ctrl+x into;
3, enter after the
Install MySQL5.5 and centosmysql5.5 in RPM Mode Under CentOS/RHEL 6 +
Go to http://dev.mysql.com/downloads/mysql/5.5.html#downloads:
Download the following three files respectively (because my machine is 32-bit, the following is a 32-bit package. If your machine is 64-bit, please download the 64-bit version ):
MySQL-server-5.5.16-1.rhel5.i386.rpm
MySQL-client-5.5.16-1.rhel4.i386.rpm
MySQL-devel-5.5.16-1.rhe
rh-firewall-1-input-m State--state new-m tcp-p TCP--dport 22-j accept-a rh-firewall-1-input-m State--stat E new-m tcp-p tcp--dport 4750-j accept-a rh-firewall-1-input-m State--state new-m tcp-p TCP--dport 3306-j List-a rh-firewall-1-input-j REJECT--reject-with icmp-host-prohibited COMMIT
The part of the white list is set:
-N Whitelist
-a whitelist-s 10.202.106.1-j ACCEPT
-a whitelist-s 10.202.106.2-j ACCEPT
-a whitelist-s 10. 202.106.3-j ACCEPT
-a whitelist-s 10.202.106.4-j ACCEPT-a
I. Overview:
NFS (Network File system), which can be used for file sharing on Unix-like systems. If a system that involves windows needs to consider using the file share provided by the Samb service. It is a server program that is based on the RPC (Remote Procedure Call) protocol (port 111) and cannot be run without RPC. So: 1. The server side must start the RPC service and the NFS service to achieve file sharing; 2. The client side must also run the RPC service and the NFS service; 3).
MySQL database is the most used database system on Linux operating system, it can be easily integrated with other servers, such as Apache, VSFTPD, Postfix and so on. The following describes the installation method for the Rhel 6 platform MySQL database server.
1, the installation of a complete MySQL database requires the following RPM package files:
Data APIs for Perl-dbi-1.609-4.e16.i686.rpm:perl langu
After installing RHEL 6, you cannot log on to the system as Root on the logon page by default. First, log on to the system as the user created during installation,Open the terminal and convert it to the root user. The corresponding command is su root. Enter the root user password and press Enter,(We recommend that you back up the files to be modified for recovery)Edit the/etc/pam. d/TPD FileThe correspondin
Set iptables firewall whitelist in Linux (RHEL 6 and CentOS 7)
Go to the Linux Command Line and edit the firewall rule configuration file iptables.Vi/etc/sysconfig/iptables
The following is an example of whitelist settings:
# Firewall configuration written by system-config-securitylevel# Manual customization of this file is not recommended.* Filter: Input accept [0: 0]: Forward accept [0: 0]: Output accept
Set a firewall whitelist in Linux (RHEL 6 and CentOS 7)
Go to the Linux Command Line and edit the firewall rule configuration file iptables.Vi/etc/sysconfig/iptables
The following is an example of whitelist settings:
# Firewall configuration written by system-config-securitylevel# Manual customization of this file is not recommended.*filter:INPUT ACCEPT [0:0]:FORWARD ACCEPT [0:0]:OUTPUT ACCEPT [0:0]:RH-Fire
selection number:4 [Press Enter]Now you can try the Java version, the output is as follows# Java-versionjava Version "1.7.0_75" Java (tm) SE Runtime Environment (build 1.7.0_75-b13) Java HotSpot (tm) 64-bit Server V M (build 24.75-b04, Mixed mode)Set Environment variablescat >>/etc/profile.d/java7. sh eofexport java_home=/opt/jdk1. 7 . 0_75export jre_home=/opt/jdk1. 7. 0_75/jreexport PATH=\ $PATH:/opt/jdk1. 7. 0_75/bin:/opt/jdk1. 7. 0_75/jre/bineofRe-open the terminal env|grep HOME to see the
, and renamed to MY.CNF canCp/usr/share/mysql/my-huge.cnf/etc/my.cnfConfigure remote AccessFor security reasons, MySQL does not allow remote access by default, you can use the following to turn on remote accessGive any host access to dataMysql>grant all privileges on * * to ' root ' @ '% ' identified by ' YourPassword ' with GRANT OPTIONMake the changes effectiveMysql>flush PrivilegesIf the remote access is still not possible, it is likely that the firewall, you can open the firewall 3306 port o
Start
Motherboard BIOS -- Grub -- kernel -- run-level results
Running level
0 Shutdown
1 single user (Repair Mode)
2. No NFS Mode
3. Full mode without image Interface
4. Custom Mode
5. Full mode with image Interface
6. Restart
Add password to Grub
Cd/boot/grub
Vi menu. lst
Add a row to timeout
Password
Save and exit
Grub-install -- no-floppy/dev/sda # Make the modified grub start content take effect
Modify the running level
Init number
Service
Chkc
The cate_no value is 6, 2, 9, 13, 19, WHEREcate_noin (6, 7, 8) member nbsp; a field in the table named cate_no is of the string type. When the cate_no nbsp; value is nbsp; 6, 2, 9, 13, 19 nbsp; (the numerical order is out of order ). SELECT nbsp; * nbsp; FROM nbsp; th
, as follows:The result of the operation is:TaskCompletion time to fill in the blanks!!!Functional requirements: Define a two-dimensional array of three columns names and assign values, using a binary loop to output the elements in a two-dimensional array.Operation Result:Please add the Code Editor 5, 8, and line codes to complete1 Public classHelloWorld {2 Public Static voidMain (string[] args) {3 4 //define two-dimensional arrays of three columns and assign values5names={
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.