MySQL Installation on Linux

 MySQL Installation

1. Download the right rpm package for MySQL corresponding to your Linux version. For instance, RHEL7 requires
mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar

2. Make Directory mysql under /opt as /opt/mysql

3. Move the tar file to mysql

4. tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar

5  sudo yum install mysql-community-{server,client,common,libs}-*

6. systemctl start mysqld

7 To reveal the password
sudo grep 'temporary password' /var/log/mysqld.log

8. Change the password by
mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';


9.
mysqld --initialize --user=mysql
mysqld --initialize-insecure --user=mysql

CREATE USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL ON *.* TO 'admin'@'%';

**************************************************

Using yum install
sudo must be prefixed even though you login as root
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html

Comments

Post a Comment

Popular posts from this blog

 Apache Linux Installation Steps Add User and Group  $ groupadd tomcat   $ useradd -s /sbin/nologin -g tomcat -d /path/to/tomcat tomcat   $ passwd tomcat Extract the package tar xvzf apache-tomcat-[#].tar.gz mv apache-tomcat-[#] /desiredpath/tomcat Once the tomcat user is created, give it permissions and ownership rights to the Tomcat installation directory and all of its contents using the following chown command # chown -R tomcat:tomcat /desiredpath/tomcat # ls -l /desiredpath/tomcat create a  tomcat.service vi /etc/systemd/system/tomcat.service Copy and paste the following configuration in the  tomcat.service  file. [Unit] Description=Apache Tomcat Server After=syslog.target network.target [Service] Type=forking User=tomcat Group=tomcat Environment=CATALINA_PID=/desiredpath/tomcat/temp/tomcat.pid Environment=CATALINA_HOME=/desiredpath/tomcat Environment=CATALINA_BASE=/desiredpath/tomcat ExecStart=/usr/local/tomcat9/bin/catalina.sh sta...
Read more

Dolibarr Installation

 Dolibarr Installation using PHP, MySQL, Apache Apache HTTPD Server Project Configuration (https://httpd.apache.org/docs/2.4/install.html) Downloaded httpd-2.4.48.tar.gz Extracted and renamed by following 2 commands tar -xvf httpd-2.4.48.tar.gz mv httpd-2.4.48.tar.gz httpd-2.4.48 Run from /opt/httpd folder ./configure Got configure: error: APR not found.  Please read the documentation Downloaded  expat-2.2.6.tar .gz  tar -xvf  expat-2.2.6.tar .gz     mv  expat-2.2.6  /opt/httpd-2.4.48/srclib/ Navigate to  expat-2.2.6 folder   ./configure  --prefix=/usr/local/expat make make install Downloaded apr-1.7.0.tar.gz  tar -xvf apr-1.7.0.tar.gz     mv  apr-1.7.0  /opt/httpd-2.4.48/srclib/apr Navigate to  apr folder   ./configure  --prefix=/usr/local/apr make make install Downloaded  apr-util-1.6.1.tar.gz tar -xvf apr-util-1.6.1.tar.gz mv apr-util-1.6.1 ...
Read more