Topic: Think I screwed up Mysql...

[Henrik]

Hi!
I tried to install PHP Nuke and played around a little bit with mysql. I saw some earlier post on how to install php nuke and how to create a user in mysql... I tried a little bit but did'nt have any luck. I didn't put much energy to it because I hadn't time to RTFM and didn't find any easy docs on how to install php nuke... So I gave up pretty quick

Now I noticed that I cannot reach my webmail anymore... I get this message:
Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/httpd/horde-phplib/db_mysql.inc on line 73

I think I created a user and changed password, because I can't acsses mysqladm anymore

So my stupid question is if there is a way to reset all changes in mysql and get back to normal again? I know I haven't explained this so good but any hints would be nice...

Thanks,
Henrik

[Alejandro]

Henrick
if you think your question is stupid wait to hear this answer:

you could try with a reinstalation disk (create one just now, to keep all accounts ibays and so....) and do a desktop pc backup of your server.
then  reintall it with that disk and restore the backup from the desktop pc.
it would bring up a "factory default" server but with all data and account info you have just now, the only loose is updates and additional software you have added to your box, (if you are interested in some statics you should save manually log files etc.
)

the hole process takes only 45 min and is a good way to repair unknown modified files

hoping be stupid enough!
alejandro

[Henrik]

I have too much software and stuff that I don't want to loose... is there a way to just reset mysql?

[Dan Brown]

http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Resetting_permissions

[Sergei Slobodov]

I have noticed an error similar to this ("Error ...blah.. in /home/httpd/horde-phplib/db_mysql.inc on line 73") after editing php.ini with pico from command line. It turns out, pico helpfully wraps lines at column 80 by default, confusing php completely. After I unwrapped the long lines (with vi or mc edit, or even pico itself), the error disappeared. Wasted a few hours before I figured that out.

The error message is even more confusing because the problem is in php setup, not in mysql, so reinstalling mysql doesn't help a bit.

Hope this post will save somebody a few frustrating hours.

Sergei

[Erik]

Hi Sergei,

I have just experienced the same problem. Quick question; how do you unwrap lines using PICO.

Thanks for any help, this problem has driven me crazy for the better part of the day seeing as there are 75 email accounts on the server.

Best,
Erik

[Dan Brown]

Well, pico -w [filename] will let you edit a file without wrapping lines.  If you have a file that's already wrapped and you want to unwrap it, you'd have to do it manually.

[Erik]

This is probably a very silly question, but how do I know if the lines are wrapped in pico?