Topic: MySql installation problems

[Pinoc]

As an old windows user i tried to uninstall mysql on my sme 7 and now i have some big problems getting it installed again.
Can anyone help me how to reinstall mysql again ?
Because i lost my password i thougt the solution was to reinstall - it's not a good solution - please help me.
Is there som automated scripts that can do the job ?

Allan - from Denmark

[pfloor]

"Because i lost my password i thougt the solution was to reinstall "

There is no "user known" password for mysql.  It is 41 characters long and is set and stored by the system and should NEVER be changed.  You don't need to know it to log into mysql from the command line.

If you are running rc2 you can use the following commands to reset the mysql password back to it's original state.

# cd /var/service/mysqld
# runsvctrl d .
# expand-template /root/.my.cnf
# expand-template /var/service/mysqld/set.password
# /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
# runsvctrl u .

After you have fixed the password...DON'T EVER CHANGE IT AGAIN.

[CharlieBrady]

As an old windows user i tried to uninstall mysql on my sme 7 and now i have some big problems getting it installed again.

How did you uninstall it? We really need to know that to know how much needs to be done to reinstall it.

[Pinoc]

I waas using the rpm -e packagename

For erasing - I guess a new complete install would be the solution.



Allan

[CharlieBrady]

I waas using the rpm -e packagename

Please do not obfuscate your reporting. I'm guessing you mean that you did:

rpm -e mysql

If so, I would expect you would see something like:

[root@test7 ~]# rpm -e mysql
error: Failed dependencies:
        libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
        libmysqlclient.so.14 is needed by (installed) dovecot-0.99.14-1.2.el4.rf.i386
        libmysqlclient.so.14 is needed by (installed) mysql-server-4.1.12-3.RHEL4.1.i386
        libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.12.i386
        libmysqlclient_r.so.14 is needed by (installed) mysql-server-4.1.12-3.RHEL4.1.i386
        mysql = 4.1.12-3.RHEL4.1 is needed by (installed) mysql-server-4.1.12-3.RHEL4.1.i386
        mysql >= 3.23 is needed by (installed) turba-h3-2.0.4-02sme01.noarch
        mysql is needed by (installed) rt-3.4.5-1.noarch
        mysql is needed by (installed) e-smith-horde-1.12.0-02.noarch
        mysql is needed by (installed) e-smith-mysql-1.12.0-05.noarch
[root@test7 ~]#

The package would not have been removed and there would be no damage to repair.

So I repeat my question - how did you (really) remove mysql?

For erasing - I guess a new complete install would be the solution.

That would be one solution, but certainly not the only one.

[Pinoc]

Well i'not sure anymore - i did so many different things and i have no experience of Linux.
Another group told me to type this : rpm -qa | grep mysql
which gives this result :
php-mysql-4.3.9-3.12
mysql-4.1.12-3.RHEL4.1

I sure messed it up - need to reinstall complete SME ?


Allan

[Pinoc]

rpm -e perl-DBD-MySQL mysql-3.23.52-3

Maybe - not sure - sorry


Allan