MySQL Installation and Deployment

It is recommended to use MySQL version 8.0.

Opening Specified Ports or Disabling Firewall

  1. View the ports that are already open:

    firewall-cmd --list-ports
  2. Open a specified port (e.g., port 3306 for MySQL):

    firewall-cmd --zone=public --add-port=3306/tcp --permanent
  3. Reload the firewall configuration:

    firewall-cmd --reload
  4. Confirm the opened ports:

    firewall-cmd --list-ports
  5. If needed, you can stop the firewall:

    systemctl stop firewalld
  6. Check the firewall status:

    systemctl status firewalld

Basic Environment Preparation

  1. Create a user and group for MySQL:

    groupadd mysql
    useradd -r -g mysql -s /sbin/nologin mysql
  2. Install dependencies for MySQL:

    yum install -y libncurses* libaio* lrzsz*
  3. Extract the MySQL installation package:

    tar -xvf mysql-8.0.28-linux-glibc2.12-x86_64.tar -C /usr/local/
  4. Rename the extracted directory:

    mv mysql-8.0.28-linux-glibc2.12-x86_64/ mysql
  5. Create required directories:

    cd /usr/local/mysql/
    mkdir data
  6. Change directory ownership:

    chown -R mysql:mysql /usr/local/mysql/

Deploy MySQL Service

  1. Initialize the database:

    /usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize
  2. Edit my.cnf configuration: Create/Edit the configuration file /etc/my.cnf and add the following content:

    bind-address =
  3. Configure environment variables:

    echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
    source /etc/profile
  4. Configure startup script:

    cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
    chmod +x /etc/rc.d/init.d/mysqld
    cat > /lib/systemd/system/mysqld.service <<EOF
    ExecStart=/etc/rc.d/init.d/mysqld start
    ExecReload=/etc/rc.d/init.d/mysqld restart
    ExecStop=/etc/rc.d/init.d/mysqld stop
  5. Reload systemd configuration:

    systemctl daemon-reload
  6. Set MySQL to start on boot:

    systemctl enable mysqld
  7. Start MySQL:

    systemctl start mysqld
  8. Check if MySQL port is active:

    netstat -tunlp | grep 3306

Configure Password for Remote Connection

  1. Enter the printed password to log in to MySQL:

    mysql -u root -p
  2. After logging in, change the root password:

    ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
  3. Check user information:

    select user, host, ssl_type from mysql.user;
    use mysql;
  4. Update the host field to % to allow remote connections:

    update user set host = '%' where user = 'root';
  5. Refresh privileges:

    flush privileges;

Adding Archive Platform Fields

  1. Log in to MySQL:

    mysql -u root -p
  2. Create a database:

    create database filing;
  3. Add data from the provided SQL file:

    use filing;
    source /usr/local/filing.sql;
  4. Check the added tables:

    use filing;
    show tables;

As always, ensure that you adapt paths, filenames, and other specifics to match your system's configuration.

results matching ""

    No results matching ""