Hi

I have recently installed suse 9.2 (new installation) and tried to do the same. The Apache and PHP worked fine but MySQL still doesn't work. After I issued 'mysql_install_db --usr=mysql" it didn't create the required files under /ver/lib/mysql/ (eg. mysql.sock file is missing). So whenever I try 'mysql -u root' it says "ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)". It was also not possible to start mysql using Run Level Editer.

I have also tried to add mysql under "create and edit user" but it says "error : there is a conflict between entered group name and an existing one". So I have no idea how to proceed.

If you ahve any solution to this please let me know.

Thank you in advance
novicew :?:

PS
by the way suse 9.2 doesn't have phpMySQLAdmin as a standard package.

I had too nothing but problems with the suse rpm for mysql. They changed the dirs, a find / -name mysql will might help to find the appropiate dirs. For me it was the best solution, to deinstall the rpm, get the mysql packages from mysql.org (you can find an explanation here http://dev.mysql.com/doc/mysql/en/index.html )
install them as explained, setting up the apache server and it works.

But check first by using yast, if your mysql-Sever is running (you find this in the runlevel manager, set it on running for runlevels 3 and 5)
check on command line as root with

ps -A

if mysql_server and mysql_client are running (names may differ a little bit from the mentioned)
you can scroll up on command line using shift + page up.