Dotaz: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

[lolo6]

Bohuzial musim pokracovat vo vlakne Ako spustit MySQL? Kde sa podarilo vyriesit spustenie? V podstate som pouzil toto : Ignore the previous comment; it's my.conf. If you haven't got a copy in /etc, there are samples in /usr/share/mysql which you can select, edit and then copy to /etc.

mysql_multi should not be running in a standard setup; I presume you have edited /etc/sysconfig/mysql to start it, in which case you probably need to edit /usr/share/mysql/my-large.conf and copy it to /etc as my.conf

Otherwise, edit /etc/sysconfig/mysql to turn it off and see what happens.

Ale reciprocne, lebo my.cnf bolo nativne nastavene na medium, tak chcelo povolit multi-support.

Po tomto sa mysql, spustil? Vyzeralo to, ze ano. Ale po zadani akeho kolvek prikazu o snahu pokracovat dostanem vypis:

Enter current password for root (enter for none): ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

linux-go4m:/home/milanl # mysqladmin -u root flush-privileges password 'root' mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Po konzultacii s odbornikom sa mysql.sock ma vygenerovat vo /var/run ale nie je tam.

Ma s tym niekto prosim skusenost co s tym. Za reakcie dakujem

Odpovědi

[Carth_Onasi]

Co ti pise (nebo jestli vubec bezi mysqld) ti startu sluzby?

[lolo6]

rcmysql start Done

Tym ma vystarane. Log prazdny.

Ale je to uz lepsie, predtym to bolo samy error a cannot create.

Ak chces specificky vypis. Povedz si prikaz. grep neviem teraz dat som na XP, ale tiez nic zaujimave tam nie je(jeden riadok pid atd...)

[lolo6]

Tak, ze

milanl@linux-go4m:~> ps aux | grep mysql

milanl 7274 0.0 0.0 4464 812 pts/1 S+ 12:54 0:00 grep mysql

linux-go4m:/home/milanl # chkconfig --add mysql

mysql 0:off 1:off 2:on 3:on 4:off 5:on 6:off

linux-go4m:/home/milanl # rcmysql status

Reporting MySQL servers

No groups to be reported (check your GNRs) dead

linux-go4m:/home/milanl # mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current password for the root user. If you've just installed MySQL, and you haven't set the root password yet, the password will be blank, so you should just press enter here.

Enter current password for root (enter for none):

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

Enter current password for root (enter for none):

Inak dik za reakciu a uvitam nejaky napad.

[vencour]

Když pozbydu práv pro roota, používam radu z wiki aneb

mysqld_safe --skip-grant-tables &
mysql -u root
show databases;
use mysql;
update user set password=PASSWORD("") where User='root';
flush privileges;
quit
/etc/init.d/mysql start
mysql -u root -p

(jak koukam, už tam onen postup neni, na tom linku ... no, dbf moc nepoužívam, tak jen mam takové poznámky schované, postup i s linkem.

[lolo6]

Ten prvy prikaz riesi moju situaciu ciastocne. Vyvola mysql.sock, ale po restarte systemu sa strati.

linux-go4m:/home/milanl # ps aux | grep mysql

root 8122 0.0 0.0 4464 812 pts/2 S+ 14:39 0:00 grep mysql

linux-go4m:/home/milanl # mysqld_safe --skip-grant-tables & [1] 8312

linux-go4m:/home/milanl # nohup: ignoring input and redirecting stderr to stdout

Starting mysqld daemon with databases from /var/lib/mysql

linux-go4m:/home/milanl # mysql -u root -p < /usr/share/doc/packages/mythtv-0_22-docs/database/mc.sql

Enter password: ERROR 1290 (HY000) at line 2: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

linux-go4m:/home/milanl # ps aux | grep mysql

root 8312 0.0 0.0 11660 1688 pts/2 S 14:43 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables mysql 8340 0.0 0.9 136428 20092 pts/2 Sl 14:43 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/linux-go4m.site.pid --skip-external-locking --port=3306 --socket=/var/lib/mysql/mysql.sock --skip-grant-tables root 23803 0.0 0.0 4464 812 pts/2 S+ 14:48 0:00 grep mysql

linux-go4m:/home/milanl #

A ako vidno moju poziadavku takto vyriesit nevie. Ale vygeneroval aspon adresar mythconverg s suborom opt.db

[lolo6]

Tak, ze nikdo znaly hlbsie zakutia MySQL?

[NN]

Jaky zakouti ? Proste provozujes pochybnou distribuci, na kterou nejde nainstalovat ani obycejna databaze, coz je normajne otazka 5 minut.

NN

[lolo6]

100 bodov. Rozbehat DVB sat kartu, na windovsoch trva zo vsetkym asi 10 minut. Pri Tejto filozofii mozme prejst rovno tam a bude pokoj. Dik za prispevok. Vezmem si ponaucenie.

[lolo6]

A tak, na okraj. MySQL sa Suse neinstaluje, nesie ho zakladna instalacia nativne.

[lolo6]

Tak, rozmyslam, ze ci nie je riesenie v tomto adresari plnom templateov a pomocnych skriptov. Ved len tie my.cnf sa nastavuju podla pozadovanej velkosti.

milanl@linux-go4m:~> cd /usr/share/mysql

milanl@linux-go4m:/usr/share/mysql> ls

binary-configure hungarian

my-small.cnf polish

czech charsets

mysqld_multi.server portuguese

danish italian

mysql_fix_privilege_tables.sql romanian

dutch japanese

mysql-log-rotate russian

english korean mysql.server serbian errmsg.txt mi_test_all

mysql_system_tables_data.sql slovak

estonian mi_test_all.res

mysql_system_tables.sql spanish

fill_help_tables.sql my-huge.cnf

mysql_test_data_timezone.sql swedish

french my-innodb-heavy-4G.cnf

ndb-config-2-node.ini ukrainian

german my-large.cnf norwegian

greek my-medium.cnf norwegian-ny

milanl@linux-go4m:/usr/share/mysql>