Fedora Linux Support Community & Resources Center
  #1  
Old 10th September 2005, 03:47 PM
Ridgerunner Offline
Registered User
 
Join Date: Dec 2004
Posts: 46
root password for mysql

I can not change the root password for mysql.

This is what I get when I try and change it:

mysql> SET PASSWORD FOR root = pass ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pass' at line 1

Ken
Reply With Quote
  #2  
Old 10th September 2005, 07:06 PM
smfinley Offline
Retired Community Manager
 
Join Date: Jul 2004
Posts: 1,334
See the MySQL section of the Notes for the correct syntax.
__________________
Stanton Finley
stanton-finley.net
Reply With Quote
  #3  
Old 10th September 2005, 07:57 PM
Trumar Offline
Registered User
 
Join Date: Mar 2005
Posts: 17
Type

mysqladmin -u root password 'thepassword'

where 'thepassword' is the password you want.

Hope that helps :-D
Reply With Quote
  #4  
Old 13th September 2005, 10:10 PM
perplexed Offline
Registered User
 
Join Date: Sep 2005
Posts: 5
Alternatively you can grab another mysql database directory e.g. /var/lib/mysql/mysql/ which you do know the root password for and replace it with your current one. I did this without forethought, between a Mysql 3.23 and mysql 4.1 as on fedora 4. It worked... i just didn't mean to copy over and rewrite that database.
Reply With Quote
Reply

Tags
mysql, password, root

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
How can I change the root password of MYSQL server Muideen Installation, Upgrades and Live Media 8 19th March 2009 06:42 PM
Big problem resetting mysql root password rob2000007 Using Fedora 3 5th December 2005 07:38 PM
Setting password for mysql root user. BrandonV Using Fedora 10 24th July 2005 11:08 PM
Big problem changed root password for mysql can't login alphonsebrown Servers & Networking 1 6th July 2005 03:10 PM


Current GMT-time: 22:25 (Wednesday, 20-08-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat