Dotaz: Ako spustit MySQL?

[lolo6]

Musim sa takto blbo spytat, ale nejde mi to. Uz som si priinstaloval aj grafiku pre admina, jednoducho nechce v prvom policku server-hostname zobrat nic aj ked ping na tie adresi je funkcny. Viem, ze ho treba nastavit, ale ako?

---

---

Odpovědi

[vencour]

Podle Vašich dotazů se zřejmě ptáte na OpenSuse? Balíčky máte nainstalované, skupiny přidělené?

Sám bych hledal odpověď v gentoo handbooku. Neřekl jste, kde jste se zasek, co vidíte.

[lolo6]

Dik za reakciu na OS som zabudal, pardon OpenSuse 11.1 x86-64. Odporucania prezriem.

[lolo6]

"skupiny pridelene" - ani neviem o com je rec. Server som nikdy nerobil. Tak som pozrel do toho handbooku, az na tie prve preparing, by to slo. Sakra potrebujem ho iba spustit.

Inak dik za reakciu.

[lolo6]

Mimochodom. Co je to v Gentoo "emerge"

[vencour]

Program emerge je něco jako yast/yum/rpm nebo co to tam máte v Suse. Ohledně skupin jsem se sek, mysql jsem instaloval/používal jen u mediawiki, kde byly práva k webu.

[lolo6]

Zypper

[Jendа]

No, nejdřív by to chtělo vědět, o jaké políčko se jedná a potom /etc/init.d/mysql start.

[lolo6]

Příloha:

• MySQL.png (902306 bytů)

Tak,ze policko Server Hostname. (v prilohe). Kde som sa zasekol? No,ked tam dam IP pc pingne ju v pohode, ale Cannot conect.Ked tam dam Localhost pingne v pohode ,ale cannot conect a v konzoli myslim, ze odpoveda podobne.

V podstate pokracujem v tomto http://www.abclinuxu.cz/poradna/linux/show/299805

Lebo chyba je jednoducho v tom, ze ten server nie je spusteny.

A vysledok preco to potrebujem je tu v strede http://www.root.cz/clanky/mythtv-od-zdrojoveho-kodu-az-po-instalaci/

[lolo6]

Este pridam /etc/init.d/mysql start myslim,ze tam treba davat dobry pozor, lebo zacne pytat udaje, meno,heslo a ked sa to nepodari na poprve na po druhe moc sanci nedava.

[Chytrex]

Proč by se tě měl init script na něco ptát? Sice jsem debianista ale myslím si že ani openSuse není tak zvrhlé. Na dotazy jsou postinstall scripty v balíčcích..

[lolo6]

No script sa Ta nebude pytat na nic, to mas pravdu. Ale jeho spustenim, spustis prvy start aplikacie v konzoli a dostanes radu nastaveni. A ku prikladu, nezadas heslo, lebo nechces heslovat a tym si skoncil. Zatvari sa akoby nic a viac sa do neho nedostanes ku prikladu.

[Jendа]

Mrkni do /etc/mysql/my.cnf na bind-address.

[lolo6]

Clovece nemam taky adresar. A si vznika po prvom spusteni. Asi nadych z hlboka a start. I, ked skor myslim, ze to ma vyzerat #start /etc/init.d/mysql. Cely vtip, ze neodpoveda ani ta grafika ale pingy idu bude asi v tom pociatocnom spusteni. Len my nie je jasne, co to tu start KDE 4 vypisoval o MySQL, ked este nebol spusteny , tym padom nakonfigurovany.

Inak dik za reakcie zucastnenym.

[lolo6]

Tak, zazrak sa nekonal

linux-go4m:/home/milanl # /etc/init.d/mysql start

Updating MySQL privilege database...

Looking for 'mysql' in: /usr/bin/mysql

Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck

Running 'mysqlcheck'...

Running 'mysql_fix_privilege_tables'...

ERROR 1005 (HY000) at line 8: Can't create table 'db' (errno: 13)

ERROR 1005 (HY000) at line 13: Can't create table 'host' (errno: 13)

ERROR 1005 (HY000) at line 16: Can't create table 'user' (errno: 13)

ERROR 1005 (HY000) at line 22: Can't create table 'func' (errno: 13)

ERROR 1005 (HY000) at line 25: Can't create table 'tables_priv' (errno: 13)

ERROR 1005 (HY000) at line 27: Can't create table 'columns_priv' (errno: 13)

ERROR 1005 (HY000) at line 30: Can't create table 'help_topic' (errno: 13)

ERROR 1005 (HY000) at line 33: Can't create table 'help_category' (errno: 13)

ERROR 1005 (HY000) at line 36: Can't create table 'help_relation' (errno: 13)

ERROR 1005 (HY000) at line 39: Can't create table 'help_keyword' (errno: 13)

ERROR 1005 (HY000) at line 42: Can't create table 'time_zone_name' (errno: 13)

ERROR 1005 (HY000) at line 45: Can't create table 'time_zone' (errno: 13)

ERROR 1005 (HY000) at line 48: Can't create table 'time_zone_transition' (errno: 13)

ERROR 1005 (HY000) at line 51: Can't create table 'time_zone_transition_type' (errno: 13)

ERROR 1005 (HY000) at line 54: Can't create table 'time_zone_leap_second' (errno: 13)

ERROR 1005 (HY000) at line 57: Can't create table 'proc' (errno: 13)

ERROR 1005 (HY000) at line 60: Can't create table 'procs_priv' (errno: 13)

ERROR 1017 (HY000) at line 76: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 80: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 82: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 83: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 84: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 87: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 88: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 89: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 95: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 100: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 106: Can't find file: './mysql/tables_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 109: Can't find file: './mysql/tables_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 118: Can't find file: './mysql/tables_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 132: Can't find file: './mysql/columns_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 136: Can't find file: './mysql/columns_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 146: Can't find file: './mysql/columns_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 154: Can't find file: './mysql/func.frm' (errno: 13)

ERROR 1017 (HY000) at line 162: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 164: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 175: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 181: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 191: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 194: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 198: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 201: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 202: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 203: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 204: Can't find file: './mysql/func.frm' (errno: 13)

ERROR 1017 (HY000) at line 208: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 212: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 237: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 242: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 256: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 260: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 274: Can't find file: './mysql/func.frm' (errno: 13)

ERROR 1017 (HY000) at line 276: Can't find file: './mysql/func.frm' (errno: 13)

ERROR 1017 (HY000) at line 283: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 288: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 289: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 291: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 292: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 294: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 295: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 300: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 301: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 303: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 304: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 306: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 307: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 312: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 318: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 323: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 324: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 326: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 327: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 329: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 330: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 335: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 336: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 338: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 339: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 341: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 342: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 344: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 345: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 347: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 348: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 353: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 354: Can't find file: './mysql/db.frm' (errno: 13)

ERROR 1017 (HY000) at line 355: Can't find file: './mysql/host.frm' (errno: 13)

ERROR 1017 (HY000) at line 360: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 367: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 369: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 370: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 371: Can't find file: './mysql/user.frm' (errno: 13)

ERROR 1017 (HY000) at line 379: Can't find file: './mysql/procs_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 383: Can't find file: './mysql/procs_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 387: Can't find file: './mysql/procs_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 391: Can't find file: './mysql/procs_priv.frm' (errno: 13)

ERROR 1017 (HY000) at line 399: Can't find file: './mysql/proc.frm' (errno: 13)

ERROR 1017 (HY000) at line 443: Can't find file: './mysql/proc.frm' (errno: 13)

ERROR 1017 (HY000) at line 445: Can't find file: './mysql/proc.frm' (errno: 13)

FATAL ERROR: Upgrade failed

failed

[chrono]

Aj si to spúšťala ako root?

[lolo6]

Spustal, aj, aj.

[vencour]

Podle jednoho linku je v /usr/share/mysql/my-large.conf nějaký template. Tazatel tam musel konfigurák zplodit sám.

Každopádně byste měl vidět něco jako

 # netstat -tanpu | grep mysql
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               NASLOUCHÁ  11534/mysqld      

aneb na portu 3306 poslouchat démona mysqld.

[lolo6]

Stale sa odvolava, ze vo /var/lib/mysql nemoze read mysql.socket. Bodaj by, dal som prehladat cely system a nema taky. Inak objavil som aspon priamo v /etc/my.cnf subor. Vyskusany je aj oficialny postup http://en.opensuse.org/Mysql v grafickom jaste ho nezapne pre chybu a cez riadok stale hlada zmieneny socket.

[vencour]

Co máš přesně v konfiguraci? Když mi mysql neběží ...

 $ ls -l /var/run/mysqld/
celkem 0

a když mi běží ...

 $ ls -l /var/run/mysqld/
celkem 4
-rw-rw---- 1 mysql mysql 6 10. dub 20.24 mysqld.pid
srwxrwxrwx 1 mysql mysql 0 10. dub 20.24 mysqld.sock

v konfiguráku (/etc/mysql/my.cnf) mam mj.

[mysqld]
character-set-server            = utf8
default-character-set           = utf8
user                                            = mysql
port                                            = 3306
socket                                          = /var/run/mysqld/mysqld.sock
pid-file                                        = /var/run/mysqld/mysqld.pid
log-error                                       = /var/log/mysql/mysqld.err
basedir                                         = /usr
datadir                                         = /var/lib/mysql

[lolo6]

Tak, ze milanl@linux-go4m:~> ls -l /var/run/mysqld/

ls: nie je možné pristupovať k /var/run/mysqld/: Adresár alebo súbor neexistuje

milanl@linux-go4m:~> su

Heslo:

linux-go4m:/home/milanl # ls -l /var/run/mysqld/

ls: nie je možné pristupovať k /var/run/mysqld/: Adresár alebo súbor neexistuje

linux-go4m:/home/milanl #

Overene aj fyzicky. Nie je tam.

A teraz maturujem z /etc/my.cnf skusam, priklady /usr/share/mysql - lebo tu je na 90% pes zakopany k chybe "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock". Len co sa tyka servru som uplne v ... Tomu mudrlantovy tu hore co sa pytal ako je zvrhly OpenSuse, by som chcel odkazat, ze sa sem tam v Linuxe aj edituje, odkomentuvava, alebo komentuje.

V googlovani jeden navrhol tam strelit hocjaky sock zo systemu, ale ked to dam do prehladavaca mam ich tu min 1000 a upravit my.cnf

Nemozes mi sem dat TVoj konfigurak my.cnf ako ho mas nastaveny,prosim.

Inak Ti chcem podakovat, ze sa o moj problem zaujimas a musim si vstupit do duse a sem tam sem aj ja pozriet ci nemozem pomoct.

[vencour]

Prosím, k věci.

Mam 2x socket v konfiguráku ...

$ grep socket /etc/mysql/my.cnf 
socket                                          = /var/run/mysqld/mysqld.sock
socket                                          = /var/run/mysqld/mysqld.sock
# using "localhost" in connects uses sockets by default

jak jsi na tom Ty? Navíc: máš tam ten adresář, v kterém by ten soubor měl být? File systém je ok? Selinux apod. nezlobí, tedy že by bránil tvořit apod. soubory? A taky:

$ ls /var/log/mysql/ -l
celkem 8
-rw-rw---- 1 mysql mysql 7414 10. dub 20.24 mysqld.err
-rw-rw---- 1 mysql mysql    0 28. úno 17.03 mysql.err
-rw-rw---- 1 mysql mysql    0 28. úno 17.03 mysql.log

generuje se Ti nějakej log, neni tam něco zajímavýho? Jak koukam, logy přečte skupina mysql, bylo by lepší mít uživatele v té skupině, ať nemusíš na ně s rootem.

[lolo6]

Toto je sucasny z prikladu pre medium my.cnf

milanl@linux-go4m:~> grep socket /etc/my.cnf

socket = /var/lib/mysql/mysql.sock

socket = /var/lib/mysql/mysql.sock

# All interaction with mysqld must be made via Unix sockets or named pipes.

# socket = /var/lib/mysql/mysql.sock

# socket = /var/lib/mysql-databases/mysqld2/mysql.sock

# socket = /var/lib/mysql-databases/mysqld3/mysql.sock

# socket = /var/lib/mysql-databases/mysqld6/mysql.sock

milanl@linux-go4m:~>

Toto je povodny

linux-go4m:/home/milanl # grep socket /home/milanl/mysql/zaloha/my.cnf

socket = /var/lib/mysql/mysql.sock

socket = /var/lib/mysql/mysql.sock

# All interaction with mysqld must be made via Unix sockets or named pipes.

# socket = /var/lib/mysql/mysql.sock

# socket = /var/lib/mysql-databases/mysqld2/mysql.sock

# socket = /var/lib/mysql-databases/mysqld3/mysql.sock

# socket = /var/lib/mysql-databases/mysqld6/mysql.sock

linux-go4m:/home/milanl #

Povodny nie je jednoduchy textak, hoci atributy na citanie ma, citat nejde

linux-go4m:/home/milanl # ls /var/log/mysql/ -l

ls: nie je možné pristupovať k /var/log/mysql/: Adresár alebo súbor neexistuje

linux-go4m:/home/milanl #

No, adresare mame rozdielne log je akurat file:///var/lib/mysql/mysqld.log ale prazdny.Ma odkaz vo /var/log

[lolo6]

Este som zabudol Suse nema vo zvyku branit suborom tvorenymi aplikaciami.

[lolo6]

Tak, ze vyriesene!!! V /etc/sysconfig/mysql scripte povolit multi. Tot cela zahada. Este mi prosim daj nejaku napovedu na skusky. Lebo Na spustenie odpovedal strohym zelenym Done.