payam@win7:/etc/init.d> sudo ./mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/run/mysql/mysql.sock didn’t appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid’: No such file or directory
You can edit your posts within a time window of 10 minutes.
Installing/configuration attempts the xampp packages may very well have broken your install. I cannot see that. Simply removing /opt should not be done either. Specially since you ran some security script/program. Mysql not starting is no good.
If this is not a production environment, which I thoroughly hope, reinstall. Always first check for openSUSE packages.
My advice: reinstall openSUSE. Then install the Lamp pattern through the software installer. phpMyAdmin can be found through software.opensuse.org: Search Results . Activate mysql, apache2 in the runlevel editor, set a root password in mysql, create an admin user for phpMyAdmin, done.
Extra tips: configure the webroot and mysql database to be out of the root filesystem, i.e. on an other partition.
I’ve reinstalled the external package again back into /opt, and it appears to be working again. How do you remove the LAMP install that I installed through yast? it doesn’t allow me to uncheck the box :S
If I majorly stuff this up, then I’ll reinstall openSUSE. I’ve still got some life left in me before I give in.