Изпечатай

[p_penchev]

Не мога да си пусна mysql. Опитвам се да го пусна със mysqd_safe --user=mysql&.
Оправил съм правата на /var/lib/mysql и /var/run/mysql.
Дава следната грешка.
 internal error 2002:Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Кажете моля какво да правя?
Slackware 11
10x предварително!

[NikDaPhreak]

moin,
ако ползваш MySQL пакета на Slackware - пробвай с /etc/rc.d/rc.mysql start или просто го стартирай без опцията --user. MySQL сам ще смени потребителя след като стартира.

[p_penchev]

Дава абсолютно същият проблем.

[NikDaPhreak]

какво пише във /var/lib/mysql/*.err?
Имаше простичко решение, ама пусто да остане не се сещам... прекалено много кръв вместо кафе в главата ми тая сутрин....

[p_penchev]

061217 11:07:05  mysqld started
061217 11:07:05  InnoDB: Started; log sequence number 0 43655
061217 11:07:05 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:07:05 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:07:05 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:07:05  mysqld ended

[p_penchev]

061217 09:47:39  mysqld ended

061217 09:49:22  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
061217  9:49:23  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
061217  9:49:23  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
061217  9:49:24  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
061217  9:49:24  InnoDB: Started; log sequence number 0 0
061217  9:49:24 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217  9:49:24 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217  9:49:24 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
061217 09:49:24  mysqld ended

061217 09:50:30  mysqld started
061217  9:50:30  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
061217  9:50:30  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
061217  9:50:30  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
061217  9:50:31  InnoDB: Started; log sequence number 0 43655
061217  9:50:31 [Note] /usr/libexec/mysql/mysqld: ready for connections.
Version: '5.0.27'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
061217 10:04:57 [Note] /usr/libexec/mysql/mysqld: Normal shutdown

061217 10:04:57  InnoDB: Starting shutdown...
061217 10:04:59  InnoDB: Shutdown completed; log sequence number 0 43655
061217 10:04:59 [Note] /usr/libexec/mysql/mysqld: Shutdown complete

061217 10:04:59  mysqld ended

061217 10:53:57  mysqld started
061217 10:53:59  InnoDB: Started; log sequence number 0 43655
061217 10:53:59 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 10:53:59 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 10:53:59 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
061217 10:53:59  mysqld ended

061217 10:59:19  mysqld started
061217 10:59:19  InnoDB: Started; log sequence number 0 43655
061217 10:59:19 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 10:59:19 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 10:59:19 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
061217 10:59:19  mysqld ended

061217 11:04:21  mysqld started
061217 11:04:21  InnoDB: Started; log sequence number 0 43655
061217 11:04:21 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:04:21 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:04:21 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:04:21  mysqld ended

061217 11:07:05  mysqld started
061217 11:07:05  InnoDB: Started; log sequence number 0 43655
061217 11:07:05 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:07:05 [ERROR] /usr/libexec/mysql/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:07:05 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
061217 11:07:05  mysqld ended

[NikDaPhreak]

мдам... простичко е...
mysql_install_db

[p_penchev]

И това съм направил. Ве(е взимам да се отчайвам)...

[NikDaPhreak]

ок. Инсталацията като гледам е прясна. Направи следното:
rm -rf /var/lib/mysql/*
mysql_install_db
chown -R mysql:mysql /var/lib/mysql
/etc/rc.d/rc.mysqld start

А ако ти се рови:
ls -la /var/lib/mysql
Готов съм да се обзаложа, че
chown -R mysql:mysql /var/lib/mysql
ще свърши работа ;-)

[lisik]

Цитат (NikDaPhreak @ Дек. 17 2006,13:00)

ок. Инсталацията като гледам е прясна. Направи следното: rm -rf /var/lib/mysql/* mysql_install_db chown -R mysql:mysql /var/lib/mysql /etc/rc.d/rc.mysqld start А ако ти се рови: ls -la /var/lib/mysql Готов съм да се обзаложа, че chown -R mysql:mysql /var/lib/mysql ще свърши работа ;-)

мда.
никога не съм имал проблем с MySQL под Slackware.
само дето след приключа като инсталацията на Слакуер правя:
1. su
2. su mysql
3. mysql_install_db
4. exit
5. restart na mysqld както го е описал NikDaPhreak
така не е нужно да се правят chown и т.н.
Най-вероятно си (p_penchev) оплескал нещата в началото и сега... '>

[p_penchev]

rm -rf /var/lib/mysql/*
mysql_install_db
chown -R mysql:mysql /var/lib/mysql
/etc/rc.d/rc.mysqld start
или пък mysqld_safe --user=mysql
потребител mysql e активиран, обаче mysql не тръгва.
Дава ми тази грешка в брайзера:
 internal error 2002:Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock'

А това е в /var/lib/mysql/*.err

070110 22:02:20  mysqld ended

070110 22:02:21  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
070110 22:02:21  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070110 22:02:22  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
070110 22:02:22  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070110 22:02:22  InnoDB: Started; log sequence number 0 0
070110 22:02:22 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/tmp/mysql.sock'  port: 0  Source distribution
070110 22:04:08 [Note] /usr/libexec/mysqld: Normal shutdown

070110 22:04:08  InnoDB: Starting shutdown...
070110 22:04:10  InnoDB: Shutdown completed; log sequence number 0 43655
070110 22:04:10 [Note] /usr/libexec/mysqld: Shutdown complete

070110 22:04:10  mysqld ended

070110 22:04:15  mysqld started
070110 22:04:15  InnoDB: Started; log sequence number 0 43655
070110 22:04:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
============
Какво да правя?