1. Do a clean uninstall including removing /etc/sysconfig/mysql if it exists.
2. Download these packages: http://download.opensuse.org/repositories/openSUSE:/11.0/standard/i586/mysql-5.0.51a-27.1.i586.rpm http://download.opensuse.org/repositories/openSUSE:/11.0/standard/i586/mysql-client-5.0.51a-27.1.i586.rpm http://download.opensuse.org/repositories/openSUSE:/11.0/standard/i586/libmysqlclient15-5.0.51a-27.1.i586.rpm 3. Install them (I prefer to use the commandline and run the command *zypper in *mysql*.rpm.* It will automatically pull in all the dependencies.) 4. Run SuSEconfig 5. Run *rcmysql start* 6. Profit! "Happiness makes up in height what it lacks in length" -- Robert Frost 2009/7/1 Richard Zulu <[email protected]> > Hey, > I downloaded an mysql rpm package on my suse 11.0 because i had made > a clean uninstall of the previous version and my yast couldn't > download the version from repository cos it didn't exist. I installed > the package and then run rcmysql start, however it shows up with the > following error: > > Will update MySQL now, if you encounter any problems, please read following > file > : > /usr/share/doc/packages/mysql/README.SuSE > Running protected MySQL... > Upgrading MySQL... > Looking for 'mysql' as: /usr/bin/mysql > Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck > Running 'mysqlcheck'... > Running 'mysqlcheck'... > mysql.columns_priv > Error : Can't find file: './mysql/columns_priv.frm' (errno: 13) > status : Operation failed > mysql.db > Error : Can't find file: './mysql/db.frm' (errno: 13) > status : Operation failed > mysql.event > Error : Can't find file: './mysql/event.frm' (errno: 13) > status : Operation failed > mysql.func > Error : Can't find file: './mysql/func.frm' (errno: 13) > status : Operation failed > ................................... > Running 'mysql_fix_privilege_tables'... > ERROR 1005 (HY000) at line 8: Can't create table 'db' (errno: 13) > ERROR 1005 (HY000) at line 13: Can't create table 'host' (errno: 13) > ERROR 1005 (HY000) at line 16: Can't create table 'user' (errno: 13) > ERROR 1005 (HY000) at line 22: Can't create table 'func' (errno: 13) > ERROR 1005 (HY000) at line 25: Can't create table 'plugin' (errno: 13) > ERROR 1017 (HY000) at line 31: Can't find file: './mysql/plugin.frm' > (errno: 13) > ERROR 1017 (HY000) at line 32: Can't find file: './mysql/tmp_plugin.frm' > (errno: > 13) > ERROR 1017 (HY000) at line 33: Can't find file: './mysql/tmp_plugin.frm' > (errno: > 13) > ERROR 1017 (HY000) at line 34: Can't find file: './mysql/tmp_plugin.frm' > (errno: > 13) > ERROR 1017 (HY000) at line 35: Can't find file: './mysql/tmp_plugin.frm' > (errno: > 13) > ERROR 1017 (HY000) at line 36: Can't find file: './mysql/plugin.frm' > (errno: 13) > ERROR 1051 (42S02) at line 37: Unknown table 'tmp_plugin' > > Who might help me here,i tried changing ownership to mysql but in vain. > > -- > Richard Zulu > Faculty of Computing and Information Technology > Makerere University > P.o Box 7062 > Kampala Uganda > > Directorate of ICT Support > Network Operations Center > Makerere University > P.o Box 7062 > Kampala Uganda > [email protected] > _______________________________________________ > LUG mailing list > [email protected] > http://kym.net/mailman/listinfo/lug > %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ > > The above comments and data are owned by whoever posted them (including > attachments if any). The List's Host is not responsible for them in any way. > --------------------------------------- > >
_______________________________________________ LUG mailing list [email protected] http://kym.net/mailman/listinfo/lug %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ The above comments and data are owned by whoever posted them (including attachments if any). The List's Host is not responsible for them in any way. ---------------------------------------
