Cannot complete MY-SQL Installation on Oracle Linux 5.5

Joy Stick · 02-19-2017, 01:59 PM

Dear Linux Experts,

I am trying to install MY-SQL on OEL 5.5 (LAPTOP).
But i could NOT complete installation process.
Actually i do not have any idea abt MY-SQL database.
To simulate some scenario i need to configure MY-SQL on LINUX personally.

PHP Code:



# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 5.5 (Tikanga)

# uname -a
Linux AUSDEV.COM 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT 2010 i686 i686 i386 GNU/Linux

PHP Code:



# service mysqld start  
Initializing MySQL database:                               [  OK  ]  
Installing validate password plugin:                       [  OK  ]  
Starting mysqld:                                           [  OK  ]  
 
# service mysqld status  
mysqld (pid  13364) is running...  
 
# mysql --version  
mysql  Ver 14.14 Distrib 5.7.17, for Linux (i686) using  EditLine wrapper

Help me to resolve it

PHP Code:



# mysql_secure_installation  
  
Securing the MySQL server deployment.  
  
Enter password for user root:   
Error: Access denied for user 'root'@'localhost' (using password: YES)

>> Installed RPMS

PHP Code:



# rpm -qa | grep mysql
mysql57-community-release-el5-7
mysql-community-libs-compat-5.7.17-1.el5
mysql-community-common-5.7.17-1.el5
mysql-community-server-5.7.17-1.el5
mysql-community-libs-5.7.17-1.el5
mysql-5.7.17-1.el5
mysql-community-client-5.7.17-1.el5

dijetlo · 02-19-2017, 02:27 PM

Quote:

# service mysqld start
Initializing MySQL database: [ OK ]
Installing validate password plugin: [ OK ]

That looks like PAM and you're probably doing this with the local root account rather than a domain account...
Did you try it with a blank password (just press enter at the prompt) ?

Joy Stick · 02-19-2017, 02:45 PM

# service mysqld stop
Stopping mysqld: [ OK ]

# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

Did you try it with a blank password (just press enter at the prompt) ?
No. I never entered anything.

How do i clear it ?

dijetlo · 02-19-2017, 03:00 PM

I'd start by reading this LQ post.. The last time I had this problem I reset the mysql root password and secure installation worked like a charm.
Hope that helps

NOT@JoyStick
<Steps up on Soap box >
The search function on this site is worth its weight in gold and scandalously under-utilized.
<Steps down from soap-box>

r3sistance · 02-19-2017, 03:22 PM

Oracle Linux... yet it Identifies as RHEL, not OEL. Also RHEL 5.5 which is definitely out of date. RHEL 5.11 is the current version of RHEL 5 and RHEL 5 is nearing end of production. So you should definitely consider upgrading/updating to something much much newer.

Anyways, you probably are gunna have to reset the MySQL root password, as dijetlo already linked too.

chrism01 · 02-19-2017, 10:31 PM

Also, RHEL & OEL are paid for distros if you want updates (& support). If you don't want to pay, try Centos instead - a free rebuild of RHEL.
Includes updates but not support.

Timothy Miller · 02-19-2017, 10:40 PM

Quote:

Originally Posted by chrism01

Also, RHEL & OEL are paid for distros if you want updates (& support). If you don't want to pay, try Centos instead - a free rebuild of RHEL.
Includes updates but not support.

To add onto that, if you needed some of the things oracle makes available in Oracle Linux that isn't in baseline RHEL/CentOS, you could always add the Oracle Linux repos to a modern CentOS following Oracle's instructions.

dijetlo · 02-20-2017, 09:19 AM

Quote:

To simulate some scenario i need to configure MY-SQL on LINUX personally.

It sounds like he's working on somebody elses node, which means he'll use the distro they installed.
But since we're all indulging in our open source fanboydom...
@JoyStick
Just slather it up with Slackware, you'll be fine.