reinstal MySQL

[Roman_S]

zdravim chtel jsem si na stanicu nainstalovat MySql servr už sem jich pár instaloval bez problemu všakted poprvé se me to nepovedlo
instaloval jsem to z rpm balíku. problem je nasledující.


po instalaci mysql když chci zpustit sql servr service mysql start tak to jednou jedninkrát vypíše succes(ale servr stejnak nefunguje) a když dám service mysql restart tak to v pohodě stopne, ale jak ho to má zapnout, pokračuje to v to vypisování teček až to hodí error   viz ukazka.


[root@game mysql-5.0.45-linux-x86_64-glibc23]# service mysql start
Starting MySQL................................... ERROR!

tak jsem chtel mysql preinstalovat ze zdrojovejch kodů a když dám ./configure vypíše mi to tohle:

[root@game mysql-5.0.45-linux-x86_64-glibc23]# ./configure                     

 NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h servr.cz password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./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 ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@game mysql-5.0.45-linux-x86_64-glibc23]# Starting mysqld daemon with databases from /home/player/mysql-5.0.45-linux-x86_64-glibc23/data
STOPPING server from pid file /home/player/mysql-5.0.45-linux-x86_64-glibc23/data/servr.cz.pid
071210 13:19:29  mysqld ended
 a tady to stojí a stojí (


 jo a ještě kdesi v logu jsem videl že to melo problem se zapisem do souboru ale do složky /tmp/


071210 13:19:29  mysqld started
/home/player/mysql-5.0.45-linux-x86_64-glibc23/bin/mysqld: Can't create/write to file '/root/tmp/ibpQBk1J' (Errcode: 13)
071210 13:19:29  InnoDB: Error: unable to create temporary file; errno: 13
071210 13:19:29 [ERROR] /home/player/mysql-5.0.45-linux-x86_64-glibc23/bin/mysqld: Can't create/write to file '/home/player/mysql-5.0.45-linux-x86_64-glibc23/data/servr.cz.pid' (Errcode: 13)
071210 13:19:29 [ERROR] Can't start server: can't create PID file: Permission denied
071210 13:19:29  mysqld ended

prosim vás poradte mi co s tím mám podelat.
zatím se mejte a bye bye

fakt by nikdo nevedel ?