aliasnameless DD-WRT Novice
Joined: 23 Jan 2014 Posts: 3
|
Posted: Wed Nov 05, 2014 17:49 Post subject: Помогите с настройкой MySQL |
|
Доброго времени суток.
Имеется роутер tp-link n600 с прошивкой DD-WRT v24-sp2 (12/12/13) std
Настроен optware, установлены и настроены transmisson и dlna.Все работает на ура!
Сейчас пытаюсь настроить mysql (очень нужна синхронизация медиатеки xbmc).
Установил пакет:
Code: | opkg install mysql-server |
Далее пишу:
Code: | mysql_install_db --defaults-file=/opt/etc/my.cnf --force --basedir=/opt/usr
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:
/opt/usr/bin/mysqladmin -u root password 'new-password'
/opt/usr/bin/mysqladmin -u root -h curlys-nas password 'new-password'
Alternatively you can run:
/opt/usr/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 /opt/usr ; /opt/usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /opt/usr/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /opt/usr/scripts/mysqlbug script! |
Просит установить пароль, ок
Code: | mysqladmin -u root password 'new-password'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp' (146)'
Check that mysqld is running and that the socket: '/tmp' exists! |
Не могу понять откуда сокет /tmp ???
В /opt/etc/my.cnf прописан другой сокет
Code: | [client]
port = 3306
socket = /var/run/mysqld.sock
password = "my_password"
[mysqld]
user = root
socket = /var/run/mysqld.sock
port = 3306
basedir = /opt/usr
############ Don't put this on the NAND #############
# Figure out where you are going to put the databases
# And run mysql_install_db --force
datadir = /opt/data/web/mysql/
######### This should also not go on the NAND #######
tmpdir = /opt/data/web/mysql/tmp/
skip-external-locking
bind-address = 127.0.0.1
# Fine Tuning
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
#expire_logs_days = 10
#max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
|
Прошу помощи, возможно я с самого начала начал делать что то не так??? |
|