problems with mysql

[salar_2008]

Hi there
I have installed mysql on my SuSE but for some reasons it just doesn't start up. I have tried to start it from System Service (RunLevel) and also tried from the terminal
runlevel shows a failed message, and the same happens in the terminal...

linux-coyi:/etc/init.d # ./mysql start

it just says:

pdating MySQL privilege database...
failed

i am not an linux expert but i think it has to do with the mysql.socket..

any ideas?!? where can i see some log???

[harner]

I have a feeling you're not telling us everything. Did you put some old database in /var/lib/mysql before you tried starting it? Or did you replace that entire directory? Or is it a fresh install?

Updating Mysql Privilege Database Failed - openSUSE Forums

Google is your friend.

[salar_2008]

hi there
it is a fresh installation. i followed the instructions from this article:
Cool Solutions: Installing Apache, PHP, and MySQL on SUSE Linux Professional

and installed ran the following command for the db installation:
mysql_install_db --user=mysql

but after trying to start the mysql from the runlevel (under Yast >> System) it just doesn't start..

I don't know whether the tutorial I followed is a good one or not, but I was looking for LAMP for SuSE tutorial and found that one.. I have successfully installed APACHE and PHP5, but have the mentioned problem with the mysql.

[harner]

I built many LAMP servers via SLES and openSUSE. Every time I do so, I simply install the Apache2, PHP5, and MySQL packages via YaST>Software management. I then remotely manage the servers via Webmin.


It looks like an okay tutorial, but outdated. What version os suse are you running? That tut is for Suse 9.1 which is a few years old now.

[salar_2008]

sorry for the late answer.
i have been using YaST and but for some reason I cannot start mySQL. That is the problem... Apache2 and PHP are running well..

My distro version is: openSUSE 10.3 (X86-64)

[salar_2008]

it works now

I just uninstalled and re-installed the mysql packages from YaST and now it seems to run without problems.