nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

Mysql set root password howto

This is a discussion on Mysql set root password howto within the Databases servers forums, part of the Mastering Servers category; How do I set mysql debian set root password??...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-04-2007, 11:39 PM
Guest
 
Posts: n/a
Default Mysql set root password howto

How do I set mysql debian set root password??
Reply With Quote
  #2 (permalink)  
Old 01-04-2007, 11:45 PM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,697
Thanks: 11
Thanked 243 Times in 183 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

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 exists) , 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/
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

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


All times are GMT +5.5. The time now is 12:07 PM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2009 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38