1. Install
versions.
2. Running.
[/CODE]
3. Permissions
Kod:
4. Other
Please help...
#portsnam fetch extract update...
#cd /usr/ports/database/mysql**-server/
<-- I checked the all versions.
#make install clean....
2. Running.
#cd /usr/local/etc/rc.d/
#./mysql-server.sh
Code:
Starting mysql.
#./mysql-server.sh stop
Code:
mysql not running? (check /var/db/mysql//domena.pid).
3. Permissions
Kod:
# ls -ld /var/db/mysql
Code:
drwxrwxrwx 5 mysql mysql 512 Nov 30 18:29 /var/db/mysql
#ls -ld /var/tmp
Code:
drwxr-xr-t 3 root wheel 1024 Nov 30 18:25 /var/tmp
#ls -ld /tmp
Code:
drwxr-xr-t 9 root wheel 1024 Nov 30 18:25 /tmp
4. Other
mysql_install_db
(run root.)
Code:
Installing MySQL system tables...
OK
Filling help tables...
OK
# mysql_install_db --user=mysql --datadir=/var/db/mysql
Code:
Installing MySQL system tables...
ERROR: 1004 Can't create file '/var/tmp/#sql786_1_0.frm' (errno: 13)
101130 19:31:50 [ERROR] Aborting
101130 19:31:50 [Note] /usr/local/libexec/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/db/mysql for more information.
Code:
#mysql_upgrade
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 '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
Code:
#mysqld_safe
Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/domena.pid
101130 18:48:13 mysqld ended
Code:
#cd /var/db/mysql
pic domena.pl.err
mysqld started
/usr/local/libexec/mysqld: Can't create/write to file '/var/tmp/ibb83jeL' (Errcode: 13)
101130 18:48:12 InnoDB: Error: unable to create temporary file; errno: 13
101130 18:48:12 [ERROR] bdb: /var/db/mysql: Permission denied
101130 18:48:12 [ERROR] bdb: /var/db/mysql/log.0000000001: Permission denied
101130 18:48:12 [ERROR] bdb: PANIC: Permission denied
101130 18:48:12 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
101130 18:48:12 [ERROR] bdb: fatal region error detected; run recovery
101130 18:48:12 [ERROR] bdb: /var/db/mysql: Permission denied
101130 18:48:13 [ERROR] Can't start server : Bind on unix socket: Permission denied
101130 18:48:13 [ERROR] Do you already have another mysqld server
running on socket: /tmp/mysql.sock ?
101130 18:48:13 [ERROR] Aborting
101130 18:48:13 [Note] /usr/local/libexec/mysqld: Shutdown complete
101130 18:48:13 mysqld ended
Code:
# ls -ld /var/db/mysql
drwx------ 4 mysql 88 512 Nov 30 20:49 /var/db/mysql
Please help...