Polskie Forum Użytkowników Debiana

Kod: Zaznacz cały

debian:/usr/local/src/mysql# ./configure --prefix=/usr/local/mysqld
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing MySQL system tables...
ERROR: 1582  Duplicate entry '%-test-' for key 'PRIMARY'
070621 22:35:41 [ERROR] Aborting

070621 22:35:41 [Note] ./bin/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:
./bin/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.

The latest information about MySQL is available on the web at
[url]http://www.mysql.com[/url]
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
debian:/usr/local/src/mysql# ./configure --prefix=/usr/local/mysql --with-charset=latin2
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing MySQL system tables...
ERROR: 1582  Duplicate entry '%-test-' for key 'PRIMARY'
070621 22:37:09 [ERROR] Aborting

070621 22:37:09 [Note] ./bin/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:
./bin/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.

The latest information about MySQL is available on the web at
[url]http://www.mysql.com[/url]
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!

Kod: Zaznacz cały

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Kod: Zaznacz cały

/etc/mysql/my.cnf | grep -v '#'

Kod: Zaznacz cały

netstat -lnp | grep mysql

Kod: Zaznacz cały

root      2447  0.0  0.1   2428  1276 ?        S    11:38   0:00 /bin/sh /usr/bin/mysqld_safe
mysql    18001  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
root     27052  0.0  0.0   1384   480 ?        S    11:38   0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
mysql    13636  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql     4476  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql     4880  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql     7218  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql    22585  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql     4861  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql    31869  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql    23371  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql     9645  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my
mysql    28993  0.0  1.6  77948 17108 ?        S    11:38   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/my

Kod: Zaznacz cały

debian:~# /etc/mysql/my.cnf | grep -v '#'
-bash: /etc/mysql/my.cnf: Brak dostępu

Kod: Zaznacz cały

debian:~# netstat -lnp | grep mysql
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN     1                                                                             8001/mysqld
unix  2      [ ACC ]     STREAM     LISTENING     3127     18001/mysqld        /

Kod: Zaznacz cały

/etc/mysql/my.cnf | grep -v '#'

Kod: Zaznacz cały

cat /etc/mysql/my.cnf | grep -v '#'

Kod: Zaznacz cały

debian:~# cat /etc/mysql/my.cnf | grep -v '#'

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock


[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
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
bind-address            = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 8
query_cache_limit       = 1M
query_cache_size        = 16M
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
skip-bdb



[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]

[isamchk]
key_buffer              = 16M



!includedir /etc/mysql/conf.d/