Skip to main content

MySQL 8.0.19 install | MySQL 8.0.91 configure

MySQL 8.0.19 install | MySQL 8.0.91 configure:

Install MySQL 8.0.19 Community edition:

Remove Maria DB packages:
# yum remove mariadb-libs.x86_64*

Install MySQL 8.0.19 rpm packages:

# yum install mysql-community-common-8.0.19-1.el7.x86_64.rpm
# yum install mysql-community-libs-8.0.19-1.el7.x86_64.rpm
# yum install mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm
# yum install mysql-community-client-8.0.19-1.el7.x86_64.rpm
# yum install mysql-community-embedded-compat-8.0.19-1.el7.x86_64.rpm
# yum install mysql-community-devel-8.0.19-1.el7.x86_64.rpm
# yum install mysql-community-server-8.0.19-1.el7.x86_64.rpm
# yum install mysql-shell-8.0.19-1.el7.x86_64.rpm

At this point mysql daemon is up and running at default location /var/lib/mysql at default port 3306. If you would like to customize location and port and other configuration parameters, make sure to remove directory /var/lib/mysql and kill the existing mysqld process running.

Disable Firewall:

# systemctl stop firewalld
# systemctl disable firewalld

Set SELINUX:

Edit file /etc/sysconfig/selinux and set SELINUX to permissive

#SELINUX=enforcing
SELINUX=permissive

Reboot server:
#reboot

Edit file mysql.service:

Edit file /usr/lib/systemd/system/mysqld.service by including following lines
PIDFile=/mysql/msqa/msqa.pid

# Start main service
#ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS
ExecStart=/usr/sbin/mysqld --defaults-file=/etc/my.cnf --daemonize --pid-file=/mysql/msqa.pid $MYSQLD_OPTS

Edit file /etc/my.cnf:

Edit file /etc/my.cnf and include following parameters

datadir=/mysql/<project_name>
socket=/mysql/<project_name>/<project_name>.sock
port=9987
server-id=9987
log-error=/mysql/<project_name>/<project_name>_error.log
default_authentication_plugin=mysql_native_password

Initialize mysqld:

#systemctl daemon-reload
#systemctl start mysqld

You should be able to see following process which has started mysql damon

/usr/sbin/mysqld --defaults-file=/etc/my.cnf --daemonize --pid-file=/mysql/<project_name>/<project_name>.pid

Connect mysql daemon and reset root password:

Sudo to user mysql if you are logged in using your AD ID
$ sudo su – mysql
Get temporary root user password from mysql error log file - /mysql/<project_name>/<project_name>_error.log
S mysql –uroot –p –S/mysql/<project_name>/<project_name>.sock
mysql > alter user `root`@`localhost` identified by `<your_ password>`;











 
Labels:
Location: San Francisco, CA, USA

Comments

Post a Comment

Popular posts from this blog

MySQL InnoDB cluster troubleshooting | commands

Cluster Validation: select * from performance_schema.replication_group_members; All members should be online. select instance_name, mysql_server_uuid, addresses from  mysql_innodb_cluster_metadata.instances; All instances should return same value for mysql_server_uuid SELECT @@GTID_EXECUTED; All nodes should return same value Frequently use commands: mysql> SET SQL_LOG_BIN = 0;  mysql> stop group_replication; mysql> set global super_read_only=0; mysql> drop database mysql_innodb_cluster_metadata; mysql> RESET MASTER; mysql> RESET SLAVE ALL; JS > var cluster = dba.getCluster() JS > var cluster = dba.getCluster("<Cluster_name>") JS > var cluster = dba.createCluster('name') JS > cluster.removeInstance('root@<IP_Address>:<Port_No>',{force: true}) JS > cluster.addInstance('root@<IP add>,:<port>') JS > cluster.addInstance('root@ <IP add>,:<port> ') JS > dba.getC...
Post a Comment
Read more

Oracle E-Business Suite Online Patch Phases executing adop

Following description about Oracle E-Business Suite is high level and from documentation https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm#5281339 for in depth and detail description refer it. The online patching cycle phases: Prepare Apply Finalize Cutover Cleanup Prepare phase: Start a new online patching cycle, Prepares the environment for patching. $ adop phase=prepare Apply phase: Applies the specified patches to the environment. Apply one or more patches to the patch edition. $ adop phase=apply patches=123456,789101 workers=8 Finalize phase: Performs any final steps required to make the system ready for cutover. Perform the final patching operations that can be executed while the application is still online. $ adop phase=finalize Cutover phase: Shuts down application tier services, makes the patch edition the new run edition, and then restarts application tier services. This is the only phase that involves a brief ...
Post a Comment
Read more

Create MySQL database with hyphen

Create MySQL database with hyphen: If you are trying to create MySQL database with hyphen " - " in the name such as test-db and get error  " your MySQL server version for the right syntax to use near '-db' at line" then you might be wondering how to get it done as your business require MySQL database name with hyphen " - "  Here is the fix, use escape character " ` " before and after database name such as `test-db` and you will be able to create database with hyphen. CREATE DATABASE `test-db`; 
Post a Comment
Read more