Sponsored Content
Top Forums Web Development Error when trying to set Admin password in MySQL Post 302430076 by Corona688 on Wednesday 16th of June 2010 01:14:35 PM
Old 06-16-2010
That's not the command to set the root password, just the command to login with mysqladmin and run the command new_password (which probably isn't a command at all).

To set the root password in mysql, login as root with mysql -uroot -p, then follow this syntax to change the password.

If you do not have the current root password you'll need to follow this procedure to reset it. It involves running the mysql daemon in a special 'safe mode'.
 

8 More Discussions You Might Find Interesting

1. Cybersecurity

Web site Security WRT MySql - how set up?

Hiya all, Newbie here - hope you can help Trying to set up a login authorization on my website. Reading away - it says works well with MySql database. Apache book goes onto to explain how to install Mysql etc.... But How do I set up the login page tho? Please assist Cheers... (5 Replies)
Discussion started by: marty 600
5 Replies

2. Solaris

Resetting forgotten admin password

How do you reset a forgotten administrator password in unix on a Sun Sunblade 100? :mad: (1 Reply)
Discussion started by: mehow
1 Replies

3. Solaris

How to reset SC admin password in Netra T2000 server?

I have one Sun Netra T2000 Server. The ALOM SC admin password of this server is not known. Could you anyone help and tell me how can i reset the SC admin account password?? Thanks in advance.. (2 Replies)
Discussion started by: sudhir_shet
2 Replies

4. UNIX and Linux Applications

set mysql password with host parameter

hi, linux gurus... i'm trying to write a script in ksh called ResetPass that allows a user to change mysql passwords. the script accepts user, password and host like this: ResetPass <user> <password> <host>. here's the code: ***************************************************** mysql... (1 Reply)
Discussion started by: ankimo
1 Replies

5. Gentoo

help|how to rest my password admin(root)

i have gentoo and i dont know what is my password user admin(root) how i can to rest my passord? thanks. (2 Replies)
Discussion started by: turivnkl
2 Replies

6. Solaris

How to recover Admin password

Dear all I have two doubts please clarify my doubt with clear steps 1. As a admin i forget my password how could i know whats my password. 2. If someone change my password how could i rectify that Please give me reply. with clear steps (0 Replies)
Discussion started by: suneelieg
0 Replies

7. Solaris

Recover Admin Password

Dear All Users I have two doubts please any one clarify my doubts 1. In solaris As a admin i've forget my password so how could i know whats my password 2. if someone change my password so how could i rectify my password. Please can anyone solve my doubt with clear steps (2 Replies)
Discussion started by: suneelieg
2 Replies

8. Solaris

help reset netra T1 lom admin password

Can someone please help here on how to reset a T1 lom password? I have tried the JP13 an try to find lom.conf in scadm dir but lom.conf is not on the machine ,some help thanks (1 Reply)
Discussion started by: rafise
1 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 09:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy