nixCraft

#1 (**permalink**) 01-05-2007, 12:39 AM

How do I set mysql debian set root password??

nixcraft · #2 (**permalink**) 01-05-2007, 12:45 AM

If you are setting root password first time, use mysqladmin

Code:

mysqladmin -u root password NEWPASSWORD

If you are looking to update or change root password (you know old root password and there is old root mysql password exist

, use

Code:

mysqladmin -u root -p password NEWPASSWORD

Note the difference between two command -p option is used.

More info available at our FAQ section http://www.cyberciti.biz/faq/mysql-c...root-password/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change root password using perl script?	Raj1	Solaris/OpenSolaris	8	06-14-2008 12:01 AM
how to change root password	sandromax	Solaris/OpenSolaris	4	10-11-2007 03:43 AM
mysql connect failed for root	raghuram	Databases servers	1	02-15-2007 12:06 PM
Change root password MySQL 5	chiku	Databases servers	1	01-16-2007 09:46 PM
I forgot my root password, how do I get into my system?	toor	Linux software	2	07-06-2006 12:59 PM

Mysql set root password howto