mysql problems

[pinehead]

I just got a new dedicated server. However, mysql root seems to already have a password and i have no idea what it is. It is running redhat and what not. Can i just re-install mysql? just by getting the rpm and intalling it or do i have to remove something or what?

Thank you for your help
Anthony

[shebang]

[quote author=pinehead link=board=1;threadid=9563;start=0#msg87066 date=1090690156]
I just got a new dedicated server. However, mysql root seems to already have a password and i have no idea what it is. It is running redhat and what not. Can i just re-install mysql? just by getting the rpm and intalling it or do i have to remove something or what?

Thank you for your help
Anthony


[/quote]

Based on your question, you seem to on a rpm based distro. So i’d suggesting "erasing" the mysql rpm and re-installing a new one (preferably from src)..

rpm -e *.rpm (should work, IIRC [i’m not sure])

then:

rpm -Uvh *.rpm for installing a new one ..

[pinehead]

only question is, how do i find out what the name of the rpm file is?

[trickster]

No need to reinstall. You can always reset the password.

http://www.google.com/search?hl=en&i…=Google+Search

[shebang]

[quote author=trickster link=board=1;threadid=9563;start=0#msg87073 date=1090699369]
No need to reinstall. You can always reset the password.

http://www.google.com/search?hl=en&i…=Google+Search
[/quote]

Thanks!

[me=Shebang]is silly.. Never thought about googe’ing .. [/me]

[countach44]

I’ve had to do that before, it was one of those things where you forget one number in the password

[pinehead]

Only prblem is i dont’ have like the my file and what not. What does taht mean?

[pinehead]

It says mysqld is running, yet half the files such as mysql_safe wont work and what not as well.

Any ideas? I try to kill the pid. Yet, it says not pid running.

[trickster]

[quote author=pinehead link=board=1;threadid=9563;start=0#msg87082 date=1090707091]
Only prblem is i dont’ have like the my file and what not. What does taht mean?
[/quote]
What my file?

Try to follow this tutorial:

http://www.megalinux.net/archives/000183.html

[countach44]

try

killall mysqld

and

killall safe_mysqld