MySQL not starting(XAMPP)

[thinkfree]

Downloaded xampp/xampp-linux-1.7.1.tar.gz and extracted it to /opt/ directory. When I use

/opt/lampp/lampp start

I see the following

XAMPP: SELinux is activated. Making XAMPP fit SELinux...
Starting XAMPP for Linux 1.7.1...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Couldn't start MySQL!
XAMPP: Starting ProFTPD...
XAMPP for Linux started.

What's the problem?
localhost page in browser shows

Warning: file_get_contents(lang.tmp) [function.file-get-contents]: failed to open stream: Permission denied in /opt/lampp/htdocs/xampp/index.php on line 2

Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/xampp/index.php:2) in /opt/lampp/htdocs/xampp/index.php on line 4

[daark.child]

Isn't there some sort of log file you can look at? Also why not just install apache, php and mysql from your distros own packages?

[thinkfree]

localhost.localdomain.err shows this

090614 13:18:58 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090614 13:18:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090614 13:18:58 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090614 13:18:59 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/localhost.localdomain.pid ended
090614 13:20:04 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090614 13:20:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090614 13:20:05 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090614 13:20:05 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/localhost.localdomain.pid ended

Same thing happened in Fedora 10, now using fedora11.

[daark.child]

To fix the problem try the following

cd /opt/lampp/bin
./mysql_upgrade --force -u root -p -t "%TEMP%"

Personally I would just use the distributions own packages. Its usually less hassle than trying to do stuff on your own.

[jledhead]

Personally I would just use the distributions own packages. Its usually less hassle than trying to do stuff on your own.

and makes its a lot easier to upgrade when fixes or new versions come out.

[thinkfree]

cd /opt/lampp/bin
./mysql_upgrade --force -u root -p -t "%TEMP%"

./mysql_upgrade --force -u root -p -t "%TEMP%"
Enter password:
Looking for 'mysql' as: ./mysql
Looking for 'mysqlcheck' as: ./mysqlcheck
Running 'mysqlcheck'...
./mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

Unable to get php work if I install them individually

[thinkfree]

Installed apache and php using repositories and now they are working.

[carlos007]

I had that problem an I SOLVED this way:

I had this error:


Starting XAMPP for Linux 1.7.1...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Couldn't start MySQL!
XAMPP: Starting ProFTPD...
XAMPP for Linux started.

I coudn't start mysql cause a mysql instanse was already running.

In the terminal i did:
apt-cache show mysql-server | grep Version
and the terminal show me the mysql version
so I did:
sudo mysql
and I got the prompt: mysql>

That was I installed bacula backup which installed mysql


So I used Synaptic Package Manager to uninstall bacula and mysql (severals packages of bacula and mysql)

Thats all.