Updating Mysql Privilege Database Failed

This is now the 3rd time I have done a clean install of 10.3 following the how-to posted by falkon here:http://www.howtoforge.com/perfect_se...pensuse10.3_p4 everything goes fine untill it comes to the mysql. here is what has happened so far every time.

svr1:~ # yast2 -i mysql mysql-client mysql-shared perl-DBD-mysql perl-DBI perl-Data-ShowTable libmysqlclient-devel
svr1:~ # chkconfig --add mysql
mysql 0ff 1ff 2n 3n 4ff 5n 6ff
svr1:~ # /etc/init.d/mysql start
Creating MySQL privilege database...
Installing MySQL system tables...
OK
Filling help tables...
OK
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h svr1.mydomain.com password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web athttp://www.mysql.com
Support MySQL by buying support/licenses athttp://shop.mysql.com
Updating MySQL privilege database...
failed


Any help in geting this resolved so I can continue my installation would be greatly appreciated.

Sounds like you have an existing MySQL DB already and perhaps the permissions or ownerships on it are wrong. It would be in /var/lib/mysql. If you don't care about the contents, move it out of the way and let mysql recreate it.

mv /var/lib/mysql /var/lib/mysql.old

then

/etc/init.d/mysql start

this is what I get when doing as you said

svr1:~ # /etc/init.d/mysql start
mkdir: cannot create directory `/var/lib/mysql/.tmp': No such file or directory
chown: cannot access `/var/lib/mysql/.tmp': No such file or directory
chmod: cannot access `/var/lib/mysql/.tmp': No such file or directory
Starting service MySQL done

As far as an exsisting DB im not too sure on that although I doubt it, this is still a fresh install unless suse adds a DB in somewhere along the install that is not showing during the install. I had no problems with earlier version of suse and installing. Now this is driving me crazy and has been 4 days and now 5 fresh installs, the same thing happening each time. :blink:

Perhaps you need to create that directory first:

mkdir /var/lib/mysql
chown mysql:mysql /var/lib/mysql
/etc/init.d/mysql start

Something else you could try. The mysql update script is run out of /etc/init.d/mysql here:

# Run mysql_upgrade on every package install/upgrade. Not allways
# necessary, but doesn't do any harm.
if test -f $datadir/.run-mysql_upgrade ; then

Since this is a new install, it shouldn't have to, so remove /var/lib/mysql/.run-mysql_update before starting mysql.