<p>Quoting scott@tbwifi.ca:<br />
<br />
>><br />
>><br />
>> Quoting scott@tbwifi.ca:<br />
>><br />
>> > I have been trying to deal with problems that I am having
with<br />
>> MySQL on<br />
>>> Mandriva 2006. I am using MySQL for Mythtv. After installing and<br
/>
>>> uninstalling various versions of MySQL trying to make things work
I<br />
>> now<br />
>>> have version 4 installed. 40-4.0.26-1 to be exact. I've
installed<br />
>> MySQL,<br />
>>> MySQL-client, and MySQL common. Now I believe that I have a mess<br
/>
>> because<br />
>>> in services there is a listing for mysql and mysqld. Neither of<br
/>
>> them seem<br />
>>> to want to start or stop cleanly and show up as [FAILED] in MCC<br
/>
>> services.<br />
>>> How do I clean things up so that I can start the server and
connect<br />
>> to it?<br />
>>> Note if you didn't figure it out I am definitely a newbee to
this<br />
>> stuff,<br />
>>> but I was albe to make things work on my previous installation
of<br />
>> Mythtv.<br />
>>> If anyone has some pointers I would sure appreciate it. I am at
a<br />
>>> standstill.<br />
>>><br />
>>> Thx!<br />
>>> Scott<br />
>>> _______________________________________________<br />
>>> mythtv-users mailing list<br />
>>> mythtv-users@mythtv.org<br />
>>> <a target="_blank"
href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br
/>
>>><br />
>><br />
>> Scott-<br />
>><br />
>> So is your mysql server running (try #/sbin/service mysqld
status)<br />
>> if your server is running then you can try to login manualy with a<br
/>
>> command like: $mysql -h localhost -u mythtv -pmythtv mythconverg
If<br />
>> you can log into the mysql server then your goldin. if the server is<br
/>
>> not running, what are the logs? can you reinstall mysql (uninstall
&<br />
>> reinstall)? do you have anydata in the mysql server at this time?<br
/>
>><br />
>> let me know<br />
>><br />
>> -Matt<br />
>><br />
>> _______________________________________________<br />
>> mythtv-users mailing list<br />
>> mythtv-users@mythtv.org<br />
>> <a target="_blank"
href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br
/>
>><br />
><br />
> Thanks for the reply...<br />
><br />
> Is server running --> mysqld dead but subsys locked<br />
> Attempt to login --> ERROR 2002: Can't connect to local MySQL server<br
/>
> through socket '/var/lib/mysql/mysql.sock' (2)<br />
> Logs --> assuming that you mean /var/log/mysqld/mysqld.log...it is
empty<br />
> I have already uninstalled and reinstalled a few times and even
installed<br />
> an older version of mysql thinking that was the problem. I also deleted<br
/>
> the files in the mysql directory thinking that the permissions file my<br
/>
> offering some trouble with logging in. I did that before a fresh<br />
> re-installation. Perhpas I corrupted something. Note that the only way
a<br />
> can seem to clear things up after trying to start up the server<br />
> unsuccessfully is with a reboot. I'm sure that's just the newbee
talking.<br />
> Surely there is another method. Anyhow, I'm still hanging and any<br />
> further advice is definitely appreciated. BTW the database is emply as
I<br />
> haven't been able to log in to configure it yet.<br />
><br />
> _______________________________________________<br />
> mythtv-users mailing list<br />
> mythtv-users@mythtv.org<br />
> <a target="_blank"
href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br
/>
></p><p>Scott-</p><p>when you say your "uninstalling" mysql-server
how are you doing it? try something like #yum remove mysqld (or what ever the
packet name is) that will remove the server then you can try and install it
#yum install mysqld</p><p>apt will work also but im much more of a yum
guy</p><p>-Matt</p><br />