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
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
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
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
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 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
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
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
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
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
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
LEARN ABOUT OPENSOLARIS
mysqld_multi
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)