Форум MySQL

ustanovil na FreeBSD 6.0 MySQL 4.1.13 s portov . chto delat ? novichok ya v etom dele, esli chto hotelos by uznavat po poodrobney vse. Zaranee blagodaren!!!!

umet# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
umet#
umet# mysqld_safe &
[1] 825
umet# Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/umet.workgroup.pid
060524 10:22:07 mysqld ended

[1] Done mysqld_safe

mysql_install_db
Installing all prepared tables
Fill help tables

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:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h umet.workgroup password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/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 https://order.mysql.com
umet#

Вы mysql_install_db - запускали имеется ли что-нибудь в /var/db/mysql?

zapuskal, eto komanda vypolnena

potom ya ,
umet# mysqld_safe &
[1] 1019
umet# Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/umet.workgroup.pid
060524 14:14:55 mysqld ended

potom ya otkryl file
ee /var/db/mysql/umet.workgroup.pid

tam bylo

060523 14:27:52 mysqld started
060523 14:27:52 [ERROR] bdb: /var/db/mysql: Permission denied
060523 14:27:52 [ERROR] bdb: /var/db/mysql/log.0000000001: Permission denied
060523 14:27:52 [ERROR] bdb: PANIC: Permission denied
060523 14:27:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database reco
060523 14:27:52 [ERROR] bdb: fatal region error detected; run recovery
060523 14:27:52 [ERROR] bdb: /var/db/mysql: Permission denied
060523 14:27:52 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 ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
060523 14:27:52 mysqld ended


nu i ya dal prava  chown -R mysql:mysql  /var/db/mysql


potom zapustil mysql
i vse zarabotalo

Вообще права должны автоматически выставляться mysql_install_db - только там нужно параметр какой-то указывать.