Титла: Mysql проблем
Публикувано от: p_penchev в Dec 17, 2006, 09:54
Не мога да си пусна 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 предварително!
Оправил съм правата на /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 предварително!
Титла: Mysql проблем
Публикувано от: NikDaPhreak в Dec 17, 2006, 10:52
moin,
ако ползваш MySQL пакета на Slackware - пробвай с /etc/rc.d/rc.mysql start или просто го стартирай без опцията --user. MySQL сам ще смени потребителя след като стартира.
ако ползваш MySQL пакета на Slackware - пробвай с /etc/rc.d/rc.mysql start или просто го стартирай без опцията --user. MySQL сам ще смени потребителя след като стартира.
Титла: Mysql проблем
Публикувано от: p_penchev в Dec 17, 2006, 11:00
Дава абсолютно същият проблем.
Титла: Mysql проблем
Публикувано от: NikDaPhreak в Dec 17, 2006, 11:16
какво пише във /var/lib/mysql/*.err?
Имаше простичко решение, ама пусто да остане не се сещам... прекалено много кръв вместо кафе в главата ми тая сутрин....
Имаше простичко решение, ама пусто да остане не се сещам... прекалено много кръв вместо кафе в главата ми тая сутрин....
Титла: Mysql проблем
Публикувано от: p_penchev в Dec 17, 2006, 11:35
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
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
Титла: Mysql проблем
Публикувано от: p_penchev в Dec 17, 2006, 11:36
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
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
Титла: Mysql проблем
Публикувано от: NikDaPhreak в Dec 17, 2006, 11:47
мдам... простичко е...
mysql_install_db
mysql_install_db
Титла: Mysql проблем
Публикувано от: p_penchev в Dec 17, 2006, 11:55
И това съм направил. Ве(е взимам да се отчайвам)...
Титла: Mysql проблем
Публикувано от: NikDaPhreak в Dec 17, 2006, 12: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
ще свърши работа ;-)
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 проблем
Публикувано от: lisik в Dec 17, 2006, 12:16
| Цитат (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) оплескал нещата в началото и сега...
Титла: Mysql проблем
Публикувано от: p_penchev в Dec 17, 2006, 12:35
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
============
Какво да правя?
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
============
Какво да правя?