Sponsored Content
Operating Systems Solaris How to reset forgotten mysql root password? Post 302887608 by Neo on Sunday 9th of February 2014 10:51:42 AM
Old 02-09-2014
Did you do this? (from bartus11's link)

Quote:
C.5.4.1.3. Resetting the Root Password: Generic Instructions

The preceding sections provide password-resetting instructions for Windows and Unix systems. Alternatively, on any platform, you can set the new password using the mysql client (but this approach is less secure):

Stop mysqld and restart it with the --skip-grant-tables option. This enables anyone to connect without a password and with all privileges. Because this is insecure, you might want to use --skip-grant-tables in conjunction with --skip-networking to prevent remote clients from connecting.

Connect to the mysqld server with this command:

shell> mysql

Issue the following statements in the mysql client. Replace the password with the password that you want to use.

mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES
;

The FLUSH statement tells the server to reload the grant tables into memory so that it notices the password change.
This User Gave Thanks to Neo For This Post:
 

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 ?? (6 Replies)
Discussion started by: dhanamurthy
6 Replies

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... (6 Replies)
Discussion started by: 82026
6 Replies

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... (1 Reply)
Discussion started by: viji19812001
1 Replies

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... (4 Replies)
Discussion started by: shahru
4 Replies

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...? (0 Replies)
Discussion started by: ungalnanban
0 Replies

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... (6 Replies)
Discussion started by: cokedude
6 Replies

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 ... (5 Replies)
Discussion started by: h@foorsa.biz
5 Replies

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." (5 Replies)
Discussion started by: yashwanthguru
5 Replies

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... (4 Replies)
Discussion started by: Norman Khine
4 Replies

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... (6 Replies)
Discussion started by: pradyumnajpn10
6 Replies
mysqld_multi(1) 						  MySQL database						   mysqld_multi(1)

NAME
mysqld_multi - is meant for managing several mysqld processes running in different UNIX sockets and TCP/IP ports. USAGE
mysqld_multi [OPTIONS] {start|stop|report} [GNR,GNR,GNR...] SYNOPSIS
mysqld_multi [--config-file=...] [--example] [--help] [--log=...] [--mysqladmin=...] [--mysqld=...] [--no-log] [--password=...] [--tcp-ip] [--user=...] [--version] DESCRIPTION
mysqld_multi --config-file=... Alternative config file. NOTE: This will not affect this program's own options (group [mysqld_multi]), but only groups [mysqld#]. Without this option everything will be searched from the ordinary my.cnf file. --example Give an example of a config file. --help Print this help and exit. --log=... Log file. Full path to and the name for the log file. NOTE: If the file exists, everything will be appended. --mysqladmin=... mysqladmin binary to be used for a server shutdown. --mysqld=... mysqld binary to be used. Note that you can give mysqld_safe to this option also. The options are passed to mysqld. Just make sure you have mysqld in your environment variable PATH or fix mysqld_safe. --no-log Print to stdout instead of the log file. By default the log file is turned on. --password=... Password for user for mysqladmin. --tcp-ip Connect to the MySQL server(s) via the TCP/IP port instead of the UNIX socket. This affects stopping and reporting. If a socket file is missing, the server may still be running, but can be accessed only via the TCP/IP port. By default connecting is done via the UNIX socket. --user=... MySQL user for mysqladmin. --version Print the version number and exit. NOTE
Please see the mysql manual for more detailed information on this. SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_safe(1), mysqldump(1), mysql_fix_privilege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1) For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://www.mysql.com/doc/en/ BUGS
Please refer to http://bugs.mysql.com/ to report bugs. AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur- media.com) ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +--------------------+------------------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +--------------------+------------------------------------+ |Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt | +--------------------+------------------------------------+ |Interface Stability | External | +--------------------+------------------------------------+ NOTES
Source for mysql is available on http://opensolaris.org. MySQL 4.0 19 December 2000 mysqld_multi(1)
All times are GMT -4. The time now is 07:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy