Getting Started With ProFTP Server

ProFTP is a popular File Transfer Protocol (FTP) server available for unix-like operating systems. This tutorial will walk you through the steps you might need to get your ProFTP server up and running in Red Hat Enterprise Linux.

Installation
sudo yum install proftpd

Staring, restarting and stopping the server
sudo service proftpd start
sudo service proftpd restart
sudo service proftpd stop

Configuration
The first step in configuring a proftpd daemon is knowing where the configuration file, usually named proftpd.conf, is located. The default location for this file is /etc/proftpd.conf or /usr/local/etc/proftpd.conf, depending on your installation.
You can edit the file as needed. Here is a configuration you will need to set up an FTP server for anonymous user access, meaning anybody will have access to the server without having to enter username and password:

<IfDefine ANONYMOUS_FTP>
  <Anonymous ~ftp>
  User                        ftp
  Group                       ftp
  AccessGrantMsg              "Anonymous login ok, restrictions apply."

  # We want clients to be able to login with "anonymous" as well as "ftp"
  UserAlias                   anonymous ftp

  # Limit the maximum number of anonymous logins
  MaxClients                  10 "Sorry, max %m users -- try again later"


  # We want 'welcome.msg' displayed at login, '.message' displayed in each newly 
  #chdired directory and tell users to read README* files.
  DisplayLogin                /welcome.msg
  DisplayChdir                .message
  DisplayReadme               README*

  # Cosmetic option to make all files appear to be owned by user "ftp"
  DirFakeUser                 on ftp
  DirFakeGroup                on ftp

  # An upload directory that allows reading and storing files but not deletion
  <Directory /uploads>
     AllowOverwrite            no

     <Limit DELE RMD>
        AllowUser ftpadm
        DenyAll
     </Limit>

  </Directory>

  # Don't write anonymous accesses to the system wtmp file (good idea!)
  WtmpLog                     off

  # Logging for the anonymous transfers
  ExtendedLog                 /var/log/proftpd/access.log WRITE,READ default
  ExtendedLog                 /var/log/proftpd/auth.log AUTH auth

  </Anonymous>
</IfDefine>

Configuring MySQL 8 in RedHat Linux

After successful installation of MySQL 8 in your RedHat Linux, here are some of the common next steps, you might want to do as a Database administrator:

  1. Change 'root' user password

MySQL creates a temporary password for the default 'root' user during installation. The first thing you want to do is to change that password for the root user using the temporary password which you can get from /var/log/mysqld.log . To change the password, run mysql_secure_installation from the terminal

2. Create a database

Now, you can log in to the your database by using the following command from your terminal:

mysql -u root -p

use the password that created in step 1. To create a database:

mysql> create database db1

3. Create a user and grant the user all access to db1

mysql> create user 'user1'@'%' identified by 'user_pass';

mysql> grant all privileges on db1.* to 'user1'@'%' with grant option;

4. Changing database host port

MySQL configurations was pulled from any of these files: /etc/my.cnf, /etc/mysql/my.cnf, ~/.mysql/my.cnf . Edit the files and add or modify the port variable. For example:

port=3306

Be sure to restart mysql server:

shell>sudo service mysqld restart

5. Back up all tables of database

shell>mysqldump db1 > backup-file.sql

6. Load tables to a database from the dump file

shell>mysql -u user1 -p db_name < backup-file.sql

In case, you wanna connect to the mysql server remotely, you can do so using a command-line mysql client by:

shell> mysql -u user1 -h host-name_or_ipaddress -P portnumber -D database_name -p