Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Open remote MySQL database connection managed under CentOS     - iostat command Detailed (Linux)

- Linux operating system buffer overflow attacks Countermeasures (Linux)

- The wrong in Linux: too many open files (Linux)

- Java object serialization and deserialization (Programming)

- W and uptime command (Linux)

- Vim useful plugin: EasyGrep (Linux)

- How to upgrade the kernel to 3.13.7 on Ubuntu / Linux Mint (Linux)

- Windows 8.1 hard drive to install Ubuntu 14.04 dual system reference tutorials and multi-drive Precautions (Linux)

- Installation and deployment of Hadoop 2.7.1 on Ubuntu 14.04 LTS (Server)

- Ubuntu 14.10 PPA installed Android Studio (Linux)

- Ubuntu installation under Scrapy (Linux)

- Linux Kernel 4.2 Installation Instructions (Linux)

- Protection Docker container Notice (Server)

- Linux Basics Tutorial: create your own Vim IDE (Linux)

- C # Future: Tracking null reference (Programming)

- Ubuntu 14.04 LTS 64-bit install GNS3 1.3.7 (Linux)

- Linux command find (Linux)

- C / C ++ various data types Conversion Summary (Programming)

- JavaScript is implemented without new keywords constructor (Programming)

- Vim highlight lookup operation (Linux)

 
         
  Open remote MySQL database connection managed under CentOS
     
  Add Date : 2018-11-21      
         
         
         
  When the Linux server is not running PHP, phpMyAdmin did not install the remote management of MySQL becomes necessary. Because in CentOS set, so the title added CentOS, the following command in the Debian systems should also be possible.

1.mysql -u root -p mysql # 1st mysql command is executed, the first two mysql is the name of the system data

In the mysql console to perform:

1.grant all privileges on *.* to 'root' @ '%' identified by '123456' with grant option;

2. # root user name,% represents any host, '123456' password specified (the local root password can be set to different, independently of each other)

# Override system privileges;

3.flush privileges

4.exit;

Allow port 3306

1.iptables -I INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

2. Check whether the rule to take effect #

3.iptables -L -n # or: service iptables status

4. # production environment is not safe at this time, should be closed after the remote management port, delete previously added rules

5.iptables -D INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

PS, the above iptables add / delete rules are temporary, if also need to restart to take effect, you need to save the changes:
service iptables save # or: /etc/init.d/iptables save

In addition,

vi / etc / sysconfig / iptables # add the following line to the rule are possible

-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

Remote database management software under Windows system can use Navicat, with several remote software, this feeling with them pretty good.
     
         
         
         
  More:      
 
- How to install the NVIDIA 358.16 driver in Ubuntu 15.10,14.04 (Linux)
- Wireless LAN security solutions (Linux)
- Java coding conventions (Programming)
- The basic principles for the protection of a good linux server security (Linux)
- Upload the project to GitHub, synchronous remote repository Github (Linux)
- CentOS 6/7 Series Docker Installation (Linux)
- OpenGL shadow map (Programming)
- Python programmers most often committed ten errors (Programming)
- Java implementation file encryption and decryption (Programming)
- RedHat Linux source code package installation process (Linux)
- Ten linux version of the system (Linux)
- MD5 and simple to use (Linux)
- C language binary tree counts words (Programming)
- Detailed PHP code optimization [section] (explain reasons) (Programming)
- Java polymorphic methods inside constructors complete analysis (Programming)
- About Python default character set (Linux)
- The AWK use Cygwin tools mysql binlog log viewer (Database)
- C language programming entry - macro definitions and enum (Programming)
- Packages with Snort intrusion monitoring light (Linux)
- Oracle database, some basic grammatical structures (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.