Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 30th January 2007, 15:11
rh-penguin rh-penguin is offline
Junior Member
 
Join Date: Nov 2006
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Question MYSQL; setting/updating the root password question...

hi,

Im doing the: How To Set Up A Ubuntu/Debian LAMP Server(Im using debian)
About half way down is the MYSQL Section.
Code:
Creating users to use MySQL and Changing Root Password

By default mysql creates user as root and runs with no passport. You might need to change the root password.

To change Root Password

mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
mysql> FLUSH PRIVILEGES;
On the line:
Code:
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE
Would i put:
Code:
mysql> UPDATE user SET Password=dondude4482('new-password') WHERE
Reply With Quote
Sponsored Links
  #2  
Old 30th January 2007, 16:18
marsvin marsvin is offline
Junior Member
 
Join Date: Dec 2006
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

No you'd put:
Code:
mysql> UPDATE user SET Password=password('dondude4482') WHERE etc...
The first "password" is the name of the column you're updating (the "password" column in the "user" table.) The second "password" is a mysql function that encrypts whatever is between the parenthesis and 'dondude4482' is your actual password.

-- marsvin
Reply With Quote
  #3  
Old 30th January 2007, 18:47
rh-penguin rh-penguin is offline
Junior Member
 
Join Date: Nov 2006
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

ok, thanks
Reply With Quote
Reply

Bookmarks

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
monit howto Jamesk5 HOWTO-Related Questions 11 5th August 2008 15:10
mod_proxy / rewrite rules KenKnight Server Operation 25 30th January 2007 22:21
VMWare install on Ubuntu problem with the IP velonis HOWTO-Related Questions 10 21st September 2006 14:19
Apache - Virtual hosts - ISPConfig Hans Server Operation 8 23rd April 2006 16:29
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 22:40


All times are GMT +2. The time now is 09:37.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.