Fedora Linux Support Community & Resources Center
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

Reply With Quote
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
Reply With Quote
Old 10th September 2005, 07:57 PM
Trumar Offline
Registered User
Join Date: Mar 2005
Posts: 17

mysqladmin -u root password 'thepassword'

where 'thepassword' is the password you want.

Hope that helps :-D
Reply With Quote
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

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 08: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: 13:20 (Tuesday, 19-09-2017)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive

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