Portál AbcLinuxu, 10. května 2025 13:55

Dotaz: MySQL a nahly problem pri startu

17.4.2006 20:40 wr
MySQL a nahly problem pri startu
Přečteno: 208×
Odpovědět | Admin
Dobry den, v my.cnf jsem nastavil default character set a default collation a v logu se mi objevilo:
060417 19:19:04  mysqld started
/usr/libexec/mysqld, Version: 4.1.11-log. started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
060417 19:19:04  InnoDB: Started; log sequence number 0 43674
060417 19:19:04 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060417 19:19:04 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060417 19:19:04 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060417 19:19:04 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
060417 19:19:04 [Warning] './mysql/tables_priv' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060417 19:19:04 [Warning] './mysql/columns_priv' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060417 19:19:04 [Warning] './mysql/func' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
/usr/libexec/mysqld: ready for connections.
Version: '4.1.11-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution 
Zde je par informaci o mem systemu:
my.cnf
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log=/var/log/mysqld.log # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 default-character-set = utf8 default-collation = utf8_general_ci [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ------ # ps aux|grep mysqld root 9376 0.0 0.3 4376 1228 pts/2 S 19:41 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid mysql 9409 0.0 4.8 125256 18540 pts/2 Sl 19:41 0:00 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock root 9648 0.0 0.1 3780 764 pts/2 S+ 20:05 0:00 grep mysqld ------ # mysqladmin version Server version 4.1.11-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Predem diky za radu.
Nástroje: Začni sledovat (0) ?Zašle upozornění na váš email při vložení nového komentáře.

Odpovědi

17.4.2006 20:54 Libor Klepac | skóre: 45 | Mýto
Rozbalit Rozbalit vše Re: MySQL a nahly problem pri startu
Odpovědět | | Sbalit | Link | Blokovat | Admin
a jaky je tam problem? mysql bezi, akorat si stezuje, ze nemate nastavene vychozi kodovani pro tabulky v db mysql a jako vychozi kodovani pro server mate neco, co muze mit ruzny pocet bytu na vyjadreni jednoho znaku

upgradoval jste z mysql < 4.1 ? ...mozna by to chtelo upravit tabulky, v debianu je na to skript mysql_fix_privilege_tables
Urine should only be green if you're Mr. Spock.

Založit nové vláknoNahoru

Tiskni Sdílej: Linkuj Jaggni to Vybrali.sme.sk Google Del.icio.us Facebook

ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.