Job for mariadb.service failed because the control process exited with error code - How to fix it ?
This article covers how to resolve the above maiadb problem "Job for mariadb.service failed because the control process exited with error code" which may arise during the installation of #MariaDB on #CentOS 8.
The /var/lib/mysql directory is not empty when MariaDB is installed, it contains e.g. the 'mysql' database and some other files.
Recreating the folder, even with correct permissions, will not help you.
Either MariaDB has not been successfully installed or the directory was removed. Reinstall MariaDB to get a working basic database system back.
Also, you can give access /var/log/mysql/* to mysql by running the command:
sudo chown mysql:mysql /var/log/mysql/*MariaDB offers more and better storage engines, NoSQL support, provided by Cassandra, allows you to run SQL and NoSQL in a single database system.
MariaDB also supports TokuDB, which can handle big data for large organizations and corporate users.
To view mysql error logs:
1. edit /etc/my.cnf [mysqld] log=/tmp/mysql.log.
2. restart the computer or the mysqld service service mysqld restart.
3. open phpmyadmin/any application that uses mysql/mysql console and run a query.
4. cat /tmp/mysql.log ( you should see the query )
Methods to Find Your Private IP Address in CentOS 8 ?
This article will guide you on the different methods to find the private IP address in CentOS 8.
Different ways to display IP addresses in Centos:
1. Using ifconfig command. The ifconfig command is the most commonly used command for displaying and modifying IP addresses on the system.
2. Using ip command.
3. Using the hostname command.
4. using nmcli command.
5. Using ip route show command.
To configure a static IP address on CentOS 7 / RHEL 7:
1. Create a file named /etc/sysconfig/network-scripts/ifcfg-eth0 as follows:
2. DEVICE=eth0.
3. BOOTPROTO=none.
4. ONBOOT=yes.
5. PREFIX=24.
6. IPADDR=192.168.x.xxx.
7. Restart network service: systemctl restart network.
Commands will get you the private IP address of your interfaces:
i. ifconfig -a.
ii. ip addr (ip a)
iii. hostname -I | awk '{print $1}'
iv. (Fedora) Wifi-Settings→ click the setting icon next to the Wifi name that you are connected to → Ipv4 and Ipv6 both can be seen.
v. nmcli -p device show.
Methods to Install Adobe Flash Player on Ubuntu 20.04 LTS ?
This article will guide you on different methods to install Adobe Flash Player on Ubuntu 20.04.
Once the Adobe Flash Player has been successfully installed on your Ubuntu 20.04 system, it will never render any error while displaying the contents of those websites that are based on the Adobe #Flash platform.
Moreover, whenever you feel like removing the Adobe Flash Player from your Ubuntu 20.04 system, then you can even remove it using the method described in this guide.
To update #Adobe Flash Player on #Ubuntu:
1. Open "Software & updates" or run software-properties-gtk from terminal.
2. Check all options under "Ubuntu Software" tab.
3. Run sudo apt-get update from terminal followed by sudo apt-get install adobe-flashplugin.
4. Restart Firefox browser if it is already open.
MariaDB on Debian 10 - Step by step process to install it ?
This article will guide you on the different methods to conveniently install and start the MariaDB service on a Debian 10 system. Also, we dealt with how to easily remove MariaDB from your Debian 10 system.
In MariaDB replication is faster whereas in MySQL replication is slower.
MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition.
MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.
Since MariaDB is a fork of MySQL, the database structure and indexes of MariaDB are the same as #MySQL.
This allows you to switch from MySQL to MariaDB without having to alter your applications since the data and data structures will not need to change. Data and table definition files are compatible.
To install #MariaDB on #Debian , follow these steps:
1. First update the apt packages index by typing: sudo apt update.
2. Once the packages list is updated, install MariaDB by running the following command: sudo apt install mariadb-server.
3. The MariaDB service will start automatically.
Modify the Date, Time, and Timezone in Ubuntu 20.04 LTS - How to do it ?
This article will guide you on the different methods to modify the date, time, and Timezone of your #Ubuntu 20.04 system.
However, if you have attempted to change these entities just for the sake of demonstration, then it is highly recommended to activate the #NTP Service again once you are done so that your system can again synchronize itself with NIST atomic clock.
This can be done by running the “timedatectl set-ntp yes” command.
To change the time zone in Linux systems use the sudo timedatectl set-timezone command followed by the long name of the time zone you want to set.
To change the hostname in #Linux:
1. Type the following command to edit /etc/hostname using nano or vi text editor: sudo nano /etc/hostname. Delete the old name and setup new name.
2. Next Edit the /etc/hosts file: sudo nano /etc/hosts.
3. Reboot the system to changes take effect: sudo reboot.
#NTP server sync date and time in Linux by:
i. On the Linux machine, log in as root.
ii. Run the ntpdate -u <ntpserver> command to update the machine clock. For example, ntpdate -u ntp-time.
iii. Open the /etc/ntp. conf file and add the NTP servers used in your environment.
iv. Run the service ntpd start command to start the NTP service and implement you configuration changes.
Assign Multiple IP Addresses to Single NIC in Ubuntu 20.04 LTS - How to do it ?
This article will guide you on how to assign multiple IP addresses to a single NIC in Ubuntu OS. Now you can allocate multiple IP addresses to a single NIC.
To change your IP address on #Linux, use the "ifconfig" command followed by the name of your network interface and the new IP #address to be changed on your computer.
To assign the subnet mask, you can either add a "netmask" clause followed by the subnet mask or use the CIDR notation directly.
The ifconfig command can be used from the #command line either to assign an address to a #network interface or to configure or display the current network interface configuration information.
The ifconfig command must be used at system startup to define the network address of each interface present on a machine.
To determine my IP address in Linux :
1. ifconfig -a.
2. ip addr (ip a).
3. hostname -I | awk '{print $1}'.
4. ip route get 1.2.
5. nmcli -p device show.
To add secondary IP address permanently on Ubuntu system, just edit /etc/network/interfaces file and add the requires IP details.
Verify the newly added IP address. # ifconfig eth0
