CREATE TABLE accounts (
id int NOT NULL AUTO_INCREMENT,
username varchar(255) NOT NULL,
fullname varchar(255) NOT NULL,
password varchar(255) NOT NULL,
email varchar(255),
designation varchar(255) NOT NULL,
about_yourself varchar(255) NOT NULL,
PRIMARY KEY (id)
);
Create a User and assign specific permissions
CREATE USER 'root'@'%' IDENTIFIED BY 'Anand@123';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;
( Server -02 ) Python Installation on RHEL 8.4
pre-required softwares
yum install wget,make,git -y
sudo dnf install wget yum-utils make gcc openssl-devel bzip2-devel libffi-devel zlib-devel
wget https://www.python.org/ftp/python/3.9.6/Python-3.9.6.tgz
tar xzf Python-3.9.6.tgz
cd Python-3.9.6
sudo ./configure --with-system-ffi --with-computed-gotos --enable-loadable-sqlite-extensions
sudo make -j ${nproc}
sudo make altinstall