forum.lissyara.su

Код: Выделить всё

 /usr/local/etc/rc.d/mysql-server start
Starting mysql.

Код: Выделить всё

ps -aux | grep mysql
root   87565  0,0  0,1  3496  1136   1  S+   21:43     0:00,00 grep mysql

Код: Выделить всё

mysql_install_db
Installing MySQL system tables...
110629 21:44:19 [Warning] option 'thread_cache_size': unsigned value 16777216 adjusted to 16384
110629 21:44:19 [ERROR] ./libexec/mysqld: unknown variable 'default-character-set=cp1251'
110629 21:44:19 [ERROR] Aborting

110629 21:44:19 [Note] ./libexec/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
./data for more information.

You can try to start the mysqld daemon with:

    shell> ./libexec/mysqld --skip-grant &

and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> ./bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in ./data that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the ./bin/mysqlbug script!

Код: Выделить всё

[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
bind-address = 127.0.0.1
socket = /tmp/mysql.sock
#skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
skip-networking
skip-innodb
#skip-bdb
server-id       = 1
log            = /var/log/mysql.log

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

Код: Выделить всё

 mysql_install_db
Installing MySQL system tables...
110630  9:44:58 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
110630  9:44:58 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
OK
Filling help tables...
110630  9:44:58 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
110630  9:44:58 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
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 hostserv.vem-43.ru password 'new-password'

Alternatively you can run:
./bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

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!

Код: Выделить всё

 /usr/local/etc/rc.d/mysql-server start
Starting mysql.

Код: Выделить всё

 mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
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

Код: Выделить всё

110630 09:51:14 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
110630  9:51:14 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
110630  9:51:14 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-f
110630  9:51:14 [Note] Plugin 'InnoDB' is disabled.
^G/usr/local/libexec/mysqld: File '/var/log/mysql.log' not found (Errcode: 13)
110630  9:51:14 [ERROR] Could not use /var/log/mysql.log for logging (error 13). Turning logging off for the whole duration of the MySQL server
110630  9:51:14 [ERROR] Unknown/unsupported storage engine: InnoDB
110630  9:51:14 [ERROR] Aborting

110630  9:51:14 [Note] /usr/local/libexec/mysqld: Shutdown complete

110630 09:51:14 mysqld_safe mysqld from pid file /var/db/mysql/hostserv.vem-43.ru.pid ended
110630 09:55:55 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
110630  9:55:55 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
110630  9:55:55 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-f
110630  9:55:55 [Note] Plugin 'InnoDB' is disabled.
^G/usr/local/libexec/mysqld: File '/var/log/mysql.log' not found (Errcode: 13)
110630  9:55:55 [ERROR] Could not use /var/log/mysql.log for logging (error 13). Turning logging off for the whole duration of the MySQL server
110630  9:55:55 [ERROR] Unknown/unsupported storage engine: InnoDB
110630  9:55:55 [ERROR] Aborting

110630  9:55:55 [Note] /usr/local/libexec/mysqld: Shutdown complete

110630 09:55:55 mysqld_safe mysqld from pid file /var/db/mysql/hostserv.vem-43.ru.pid ended
110630 10:00:49 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
110630 10:00:49 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
110630 10:00:49 [Note] Plugin 'InnoDB' is disabled.
110630 10:00:49 [ERROR] Unknown/unsupported storage engine: InnoDB
110630 10:00:49 [ERROR] Aborting

110630 10:00:49 [Note] /usr/local/libexec/mysqld: Shutdown complete

110630 10:00:49 mysqld_safe mysqld from pid file /var/db/mysql/hostserv.vem-43.ru.pid ended