MySQL FC3

[Arthur Pemberton]

Rick Stevens wrote:

> Arthur Pemberton wrote:
>
>> Dave Foran wrote:
>>
>>> I have a major issue of sorts ;-)
>>>
>>> I have no idea what the password for root is
>>> I have tried a a number of recommended edits to try and either 
>>> delete or
>>> replace the password but all have failed.
>>>
>>> The rpm on FC3 CD will not permit removal as yum has updated the file
>>> routine.  I d/l the currant rpm and it will not allow removal. It says,
>>> this in not installed..
>>>
>>> Any good thoughts short of re-installing everything and that is not a
>>> viable idea..
>>>
>>> I need I think a way to un-install mysql and do a clean install..
>>>
>>> Any thoughts ??
>>> Thanks
>>> Dave
>>>
>>>  
>>>
>> Yah I've had that happen to me before. I think there's a better 
>> solution to what I'm about to suggest, I'll google for it later.
>>
>> # service mysql stop
>> # mv /var/lib/mysql /var/lib/mysql_working
>> # rpm -e MySQL-server      # you may need to erase some other 
>> packages to get this to work
>>
>> then
>>
>> # yum insall MySQL   # if that's what you really want
>> or
>> browse to http://dev.mysql.com/downloads/mysql/4.1.html and download 
>> the necessary RPMS and
>> # rpm -ivh MySQL*.rpm
>>
>> After you get your mysql back up and running, copy back in your 
>> database from /var/lib/mysql_working , ensuring not to copy the mysql 
>> database. Then just resetup your perms for the dbases and tables.
>>
>> You might want to check these links first though#
>> http://lists.mysql.com/mysql/171366
>> http://www.alt-php-faq.org/local/70/
>
>
> If you check the mysql website and do a search, you'll find this:
>
>  In a Unix environment, the procedure for resetting the root password 
> is as follows:
>
>    1.
>
>       Log on to your system as either the Unix root user or as the 
> same user that the mysqld server runs as.
>    2.
>
>       Locate the .pid file that contains the server's process ID. The 
> exact location and name of this file depend on your distribution, 
> hostname, and configuration. Common locations are /var/lib/mysql/, 
> /var/run/mysqld/, and /usr/local/mysql/data/. Generally, the filename 
> has the extension of .pid and begins with either mysqld or your 
> system's hostname.
>
>       You can stop the MySQL server by sending a normal kill (not kill 
> -9) to the mysqld process, using the pathname of the .pid file in the 
> following command:
>
> shell> kill `cat /mysql-data-directory/host_name.pid`
>
>       Note the use of backticks rather than forward quotes with the 
> cat command; these cause the output of cat to be substituted into the 
> kill command.
>    3.
>
>       Create a text file and place the following command within it on 
> a single line:
>
> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
>
>       Save the file with any name. For this example the file will be 
> ~/mysql-init.
>    4.
>
>       Restart the MySQL server with the special 
> --init-file=~/mysql-init option:
>
> shell> mysqld_safe --init-file=~/mysql-init &
>
>       The contents of the init-file are executed at server startup, 
> changing the root password. After the server has started successfully 
> you should delete ~/mysql-init.
>    5.
>
>       You should be able to connect using the new password.
>
>
> Yet another method I suppose. This way looks neat