How to reset forgotten mysql root password? Post: 302887596

Sponsored Content

Operating Systems Solaris How to reset forgotten mysql root password? Post 302887596 by hicksd8 on Sunday 9th of February 2014 09:19:06 AM

02-09-2014

Moderator

[Solved] How to reset forgotten mysql root password?

Hi All,

I just found one thread on this forum on this subject here:

Forgot MYSQL password root | Unix Linux Forums | Web Development

but unfortunately the issue was not resolved.

I have the same problem with the same error message.
The background is that I built a Solaris 11 x86 server (using Solaris 11 Live DVD hard drive install option) for using as a test web server on my local LAN. I was amazed at how simple this was to "throw on" MySQL, Apache, PHP, and other prerequisites. I then installed Wordpress and it just worked. Unfortunately, in the rush to get it running I didn't note the MySQL root password that I used.

NOTE TO MODERATOR: If this would get a better response on a forum other than Solaris please do move it.

I haven't looked for or tried solutions found on Google yet. I just thought I'd put it on this great forum first.

I have modified the role of the root user to "normal". Obviously, I have physical hardware access, console root login access, etc.
Anybody know how to get back into MySQL in these circumstances?
Thanks in advance

Last edited by hicksd8; 02-09-2014 at 10:24 AM..

hicksd8

View Public Profile for hicksd8

Find all posts by hicksd8

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Root password forgotten

If someone a Unix system administrator forgets the root password ?. What will be the consequences ?. Should the OS needs to be reinstalled ??

2. Cybersecurity

How to reset root password of old Unix System V

Hi all, This is first time I met unix in my life. I purchased old Scanning Elecron Microscope which came with 486/33MHz PC running Unix System V, ver. 3.6. The one simple user name/passw is known so I can boot and login. But can not shutdown! It asks root or su passw. I'm very sensitive not to...

3. UNIX for Advanced & Expert Users

Not able to reset mysql root password

Hi, My root password for mysql has some problem as it dosent allow me to login.... all commands to reset it failed. so I removed mysql yum remove mysql and installed it by yum install mysql mysql-devel mysql-server and it installed fine I gave chkconfig --levels 235 mysqld on...

4. Solaris

Reset lost superuser/root password in x86

I've come across this question during interview as Sys Adm. "How you reset lost root/superuser password on x86 system running solaris (8/9/10) which remotely located. (Not locally in front of you)" As much as I know, you must be physically in front of the server to reset the lost...

5. UNIX for Advanced & Expert Users

How to reset the ldap root password?

How to change the ldap root password. I have generated the password by using "slappasswd " command, but In my root machine "/etc/ldap/sldap.d" file is not there. instead of the file sldap.d directory only is there. please help me...?

6. Red Hat

Fedora reset root password

I need some help with Fedora. I am trying to reset the root password. When I tried to login I was not able to. I kept getting the authentication failure message. I got the password reset success message. passwd: all authentication tokens updated successfully. I then thought maybe the root...

7. Emergency UNIX and Linux Support

Reset AIX root password without shutting down the system

Hi All, I'm stuck in a severe problem here , Someone have changed the root password and he cannot remember it and there is no other user privileged user on the system , But I do have access to a non privileged user. On the top of the system an application which requires a theoretical ...

8. UNIX for Dummies Questions & Answers

Forgotten root password

I forgot the password of root and i dont know "How to reset root password without loosing of my previous data and users."

9. Solaris

solaris 8 reset root password from OSX

Hello, I have two old Solaris machines $ uname -a SunOS unknown 5.8 Generic_117350-39 sun4u sparc SUNW,UltraAX-e2 unfortunately, it has been so long ago that i have used these that the root password has left my head... i can log into one of the machine as a normal user, but am unable to...

10. UNIX for Beginners Questions & Answers

Linux root Password Reset

Hi , I ve a question about the Linux system root password change. Which can be done using grub menu without inputting the old password.:confused: So If anybody can change the root password without any password and then how it is secure. Anybody can manipulate the other user using the...

LEARN ABOUT LINUX

mysql_secure_installation

MYSQL_SECURE_INST(1)					       MySQL Database System					      MYSQL_SECURE_INST(1)

NAME

       mysql_secure_installation - improve MySQL installation security

SYNOPSIS

       mysql_secure_installation

DESCRIPTION

       This program enables you to improve the security of your MySQL installation in the following ways:

       o   You can set a password for root accounts.

       o   You can remove root accounts that are accessible from outside the local host.

       o   You can remove anonymous-user accounts.

       o   You can remove the test database (which by default can be accessed by all users, even anonymous users), and privileges that permit
	   anyone to access databases with names that start with test_.

       mysql_secure_installation helps you implement security recommendations similar to those described at Section 2.10.2, "Securing the Initial
       MySQL Accounts".

       Invoke mysql_secure_installation without arguments:

	   shell> mysql_secure_installation

       When executed, the script prompts you to determine which actions to perform.

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014						      MYSQL_SECURE_INST(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Root password forgotten

Discussion started by: dhanamurthy

2. Cybersecurity

How to reset root password of old Unix System V

Discussion started by: 82026

3. UNIX for Advanced & Expert Users

Not able to reset mysql root password

Discussion started by: viji19812001

4. Solaris

Reset lost superuser/root password in x86

Discussion started by: shahru