NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
theindustry
Dec 16, 2010Aspirant
Connecting to mySQL on the Duo?
Hi everyone, After reading on about how to connect to mySQL on the DUO, I tried the following, which throws the below shown output: #mysql -u admin -p ERROR 2002 (HY000): Can't connect to local ...
mfe_
Oct 19, 2011Tutor
Hi,
yesterday my MySQL worked. I installed the MySQL on Addon. Today I got when logging in:
Also starting the mysql daemon didnt changed my issue.
My my.cnf looks like that:
Trying to access the log will result in:
fes-a120d19nas:~# tail /var/log/mysql.log
tail: /var/log/mysql.log: No such file or directory
fes-a120d19nas:~#
Has anyone a Idea what is broken?
yesterday my MySQL worked. I installed the MySQL on Addon. Today I got when logging in:
fes-a120d19nas:~# start-stop-daemon -S -q -b -x /usr/sbin/mysqld -- \
> --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/run/mysqld/mysqld.sock
fes-a120d19nas:~# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
fes-a120d19nas:~# ps -aux | grep mysql
Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
root 7189 0.0 0.5 4256 1200 pts/0 S+ 17:20 0:00 grep mysql
Also starting the mysql daemon didnt changed my issue.
My my.cnf looks like that:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = admin
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
skip-name-resolve
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 0.0.0.0
#skip-networking
innodb_buffer_pool_size = 6M
key_buffer_size = 16k
myisam_sort_buffer_size = 16k
max_connection = 20
#
# * Fine Tuning
#
key_buffer = 16k
max_allowed_packet = 16M
thread_stack = 128K
#
# * Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 32768
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log = /var/log/mysql.log
log = /var/log/mysql/mysql.log
#
# The following can be used as easy to replay backup logs or for replication.
server-id = 2
log-bin = /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size = 16384
server-id=2
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
Trying to access the log will result in:
fes-a120d19nas:~# tail /var/log/mysql.log
tail: /var/log/mysql.log: No such file or directory
fes-a120d19nas:~#
Has anyone a Idea what is broken?
Related Content
NETGEAR Academy

Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!