Installing MySQL Using Generic Binaries | MySQL Binary Installation |
MySQL Binary Installation
#mysql | #database #administration | MySQL Binary Installation | database administration | #databaseadministration |
Subscribe the channel :) http://bit.ly/42QGIlw
This video contain MySQL binary installation step by step guidance for Linux. Generic Binary installation is one of the secure method for database administration in the IT fields.
Diwali Offer Link For Buy Amazon :) = https://bit.ly/459Puuw
I am using AWS EC2 instance with CentOS 7:
Binary installation of MySQL 8.0 with ssl connection:
It is need sudo user:
sudo -i
Update your server if not done before:
yum update -y
Check mariadb-libs to uninstall
yum list installed | grep mariadb
Remove mariadb-libs commands:
yum remove mariadb* -y
Check the Selinux status :
sestatus
To change the Selinux mode:
setenforce 0
Disable Selinux in the config file:
sed -i 's/^SELINUX=.*/SELINUX=disabled/' /etc/selinux/config
Must reboot your server after change the Selinux configuration:
reboot
Install needed softwere:
yum install wget -y
Download MySQL Distribution (Tar) Go to MySQL Community Downloads and click on MySQL Community Server.
https://downloads.mysql.com/archives/...
Click on Archives
Select TAR file and copy the link address by giving the right click.
wget https://downloads.mysql.com/archives/...
tar -xvf mysql-8.0.32-el7-x86_64.tar.gz
ll
cp -r mysql-8.0.32-el7-x86_64 /usr/local/
cd /usr/local/
Install all in one library:
yum install libaio -y
MySQL user and in the group
groupadd mysql
tail -5 /etc/group
Create user for MySQL without shell access
useradd -r -g mysql -s /bin/false mysql
tail -5 /etc/passwd
Link the directory with mysql
ls -ltrh
ln -s mysql-8.0.32-el7-x86_64 mysql
Create the data directory and support-files
cd mysql
mkdir mysql-files data
chown mysql:mysql mysql-files
chmod 750 mysql-files
ll
vi /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
user=mysql
Initialize the data directory:
cd /usr/local/mysql
bin/mysqld --initialize --user=mysql
To start the MySQL
bin/mysqld_safe --user=mysql & # Then hit enter
Start the secure installation:
bin/mysql_secure_installation
bin/mysql -u root -p
select @@version;
\s
exit
Verify the ssl connection before configure:
mysql -u root -p --ssl-mode=required
\s
exit
Run the script for ssl connection:
bin/mysql_ssl_rsa_setup
Verify the ssl connection:
mysql -u root -p --ssl-mode=required
\s
exit
Copy the MySQL files:
cp support-files/mysql.server /etc/init.d/mysql.server
/etc/init.d/mysql.server stop
/etc/init.d/mysql.server status
/etc/init.d/mysql.server start
Add the path for MySQL binary installation all users
insert line before "export PATH"
vi .bash_profile
PATH=$PATH:/usr/local/mysql/bin
mysql -V
Only for shell
export PATH=$PATH:/usr/local/mysql/bin
or you can start stop and check the status from this path also.
/usr/local/mysql/support-files/mysql.server stop / status / start
| database administration | database administrator | mysql database administration | database administrator |
Watch video Installing MySQL Using Generic Binaries | MySQL Binary Installation | online without registration, duration hours minute second in high quality. This video was added by user DBA Experiments 04 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 37 once and liked it people.