Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 14th April 2010, 19:45
carlosinfl carlosinfl is offline
Member
 
Join Date: Dec 2009
Location: Orlando, FL
Posts: 70
Thanks: 3
Thanked 3 Times in 3 Posts
Send a message via AIM to carlosinfl
Default

Well my friend, this is either really fun or going to suck. All depends on your fame of mind. For me it's fun because you learn how to reset your root password which is common for DBA's. You basically have locked yourself out of MySQL and are going to have to perform a password recovery which in my opinion is very easy.

This is your best bet for "Password recover on MySQL":

http://dev.mysql.com/doc/refman/5.1/...rmissions-unix
Reply With Quote
Sponsored Links
  #12  
Old 15th April 2010, 12:21
Riff Riff is offline
Junior Member
 
Join Date: Mar 2010
Location: England
Posts: 22
Thanks: 3
Thanked 0 Times in 0 Posts
Default

I think it's going to be fun...

Caveat... I've read the instructions and I'm not sure how comprehensive they are. There are gaps in my knowledge - I'll give it a go and then see where I get but thanks for the link. I was afraid I'd done something like this
Reply With Quote
  #13  
Old 15th April 2010, 17:53
Riff Riff is offline
Junior Member
 
Join Date: Mar 2010
Location: England
Posts: 22
Thanks: 3
Thanked 0 Times in 0 Posts
Default

ok I may come across as being pretty stupid here... hope not - but like I said I've got some knowledge gaps. I'm new to MySQL and new to Fedora and especially the command line so bear with me please

I can start mysql from terminal but not mysqld - so I've done that and search shows I have a mysqld.pid in var/run/mysqld

I've tried using the kill `cat /mysql-data-directory/host_name.pid` as per the instructions in the link - I've changed it to kill `cat /mysql-data-directory/host_name.pid`
and I also tried kill `cat /var/run/mysql.pid`

Nothing seems to happen much and if I try going to the next stage I get an output error saying it can't remove the .pid file.

I'm probably missing something... any suggestions as to what?

TIA (again)
Reply With Quote
  #14  
Old 20th April 2010, 12:10
Riff Riff is offline
Junior Member
 
Join Date: Mar 2010
Location: England
Posts: 22
Thanks: 3
Thanked 0 Times in 0 Posts
 
Default

ok just an update - I think I've got a working install, though if I'm completely honest, I'm not sure if I know how I managed it.

Either way, I seem to be able to access MySQL and can start working on learning it properly

Thanks for the help chaps
Reply With Quote
Reply

Bookmarks

Tags
configuring, fedora 12, lamp, mysql

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
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Failed to install libmysql library for MYSQL client dinesh.4126 Server Operation 1 24th September 2009 13:39
MySQL problem satimis Server Operation 5 25th June 2008 15:41
Weird mysql error after trying to install MyDNS :/ pne General 5 29th October 2007 15:44
ISPConfig: Install: mysql: unknown variable 'db-name=default' dreger Installation/Configuration 3 30th July 2006 22:23


All times are GMT +2. The time now is 16:59.


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