Starting MySQL ERROR! Couldn't find MySQL Server

Products

• CA Performance Management

Issue/Introduction

Previously I opened a case to understand the process to migrate Performance Center, I did all the steps from the Techdocs in the production environment, but I see the following error:

[root@##### ~]# service mysql status -l
Redirecting to /bin/systemctl status  -l mysql.service
● mysql.service - MySQL daemon
   Loaded: loaded (/etc/systemd/system/mysql.service; disabled; vendor preset: disabled)
   Active: inactive (dead) since Mon 2021-03-01 14:18:10 AST; 15s ago
  Process: 2793 ExecStop=/opt/CA/MySql/support-files/mysql.server stop (code=exited, status=0/SUCCESS)
  Process: 2787 ExecStart=/opt/CA/MySql/support-files/mysql.server start (code=exited, status=0/SUCCESS)

Mar 01 14:18:10 ##### systemd[1]: Starting MySQL daemon...
Mar 01 14:18:10 ##### mysql.server[2787]: /opt/CA/MySql/support-files/mysql.server: line 239: my_print_defaults: command not found
Mar 01 14:18:10 ##### mysql.server[2787]: /opt/CA/MySql/support-files/mysql.server: line 259: cd: /usr/local/mysql: No such file or directory
Mar 01 14:18:10 ##### mysql.server[2787]: Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)

 

Environment

Release : 20.2

Component : IM Reporting / Admin / Configuration

Cause

my.cnf file was copied to the wrong directory.

Resolution

Copied the my.cnf file in the /etc/directory.