Изпечатай

[empty]

Когато се опитам да стартирам MySql сървъра ми:
root@TheMachine:~# mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
040922 15:132  mysqld ended

root@TheMachine:~#
И MySql-a не е стартиран.

[tolisoft]

Не че трябва да ти го казвам ама поне виш в лога каква е грешката дето я дава, че да можем да ти помогнем '> Няма как да ти кажем какъв е проблема само по това, което си написал.

[empty]

С риск да ме обявите за пълен тъпанар ще задам следния въпрос:
Каде се намира тоя лог за MySql-a?

[tolisoft]

Зависи каква инсталация си направил:
- дали ти си инсталирал mysql или идва с дистрибуцията ти
- ако идва с дистрибуцията някой който я познава ще помогне
- ама хич не знаете как се търси хелп '>)) посочват се много неща, за да може някой, който иска да помогне да може да го направи.

Ако си го инсталирал с --prefix=/usr/local/mysql ще го търсиш там някаде. Ако идва с дистрибуцията вероятно са го пратили някаде в /var/log ......

[empty]

Идва с дистрибуцията ми:
Slackware 10.0


Във "file:/var/lib/mysql" намерих следния файл "TheMachine.err", a "TheMachine" е името на машината ми.
Та този файл "TheMachine.err" има следното съдържание:

Примерен код

040917 13:04:34  mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 040917 13:04:36  InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 040917 13:04:37  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... 040917 13:04:37  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 040917 13:04:38  InnoDB: Started 040917 13:04:38  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 13:04:38  Aborting 040917 13:04:38  InnoDB: Starting shutdown... 040917 13:04:40  InnoDB: Shutdown completed 040917 13:04:40  /usr/libexec/mysqld: Shutdown Complete 040917 13:04:40  mysqld ended 040917 13:43:14  mysqld started 040917 13:43:15  InnoDB: Started 040917 13:43:15  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 13:43:15  Aborting 040917 13:43:15  InnoDB: Starting shutdown... 040917 13:43:18  InnoDB: Shutdown completed 040917 13:43:18  /usr/libexec/mysqld: Shutdown Complete 040917 13:43:18  mysqld ended 040917 14:34:21  mysqld started 040917 14:34:22  InnoDB: Started 040917 14:34:22  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 14:34:22  Aborting 040917 14:34:22  InnoDB: Starting shutdown... 040917 14:34:24  InnoDB: Shutdown completed 040917 14:34:24  /usr/libexec/mysqld: Shutdown Complete 040917 14:34:24  mysqld ended 040917 18:02:14  mysqld started 040917 18:02:16  InnoDB: Started 040917 18:02:16  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 18:02:16  Aborting 040917 18:02:16  InnoDB: Starting shutdown... 040917 18:02:18  InnoDB: Shutdown completed 040917 18:02:18  /usr/libexec/mysqld: Shutdown Complete 040917 18:02:18  mysqld ended 040917 19:01:01  mysqld started 040917 19:01:04  InnoDB: Started 040917 19:01:04  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 19:01:04  Aborting 040917 19:01:04  InnoDB: Starting shutdown... 040917 19:01:06  InnoDB: Shutdown completed 040917 19:01:06  /usr/libexec/mysqld: Shutdown Complete 040917 19:01:06  mysqld ended 040917 19:28:12  mysqld started 040917 19:28:13  InnoDB: Started 040917 19:28:13  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 19:28:13  Aborting 040917 19:28:13  InnoDB: Starting shutdown... 040917 19:28:15  InnoDB: Shutdown completed 040917 19:28:15  /usr/libexec/mysqld: Shutdown Complete 040917 19:28:15  mysqld ended 040918 10:39:37  mysqld started 040918 10:39:40  InnoDB: Started 040918 10:39:40  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040918 10:39:40  Aborting 040918 10:39:40  InnoDB: Starting shutdown... 040918 10:39:42  InnoDB: Shutdown completed 040918 10:39:42  /usr/libexec/mysqld: Shutdown Complete 040918 10:39:42  mysqld ended 040919 10:44:41  mysqld started 040919 10:44:43  InnoDB: Started 040919 10:44:43  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040919 10:44:43  Aborting 040919 10:44:44  InnoDB: Starting shutdown... 040919 10:44:46  InnoDB: Shutdown completed 040919 10:44:46  /usr/libexec/mysqld: Shutdown Complete 040919 10:44:46  mysqld ended 040920 09:25:36  mysqld started 040920  9:25:38  InnoDB: Started 040920  9:25:38  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040920  9:25:38  Aborting 040920  9:25:39  InnoDB: Starting shutdown... 040920  9:25:41  InnoDB: Shutdown completed 040920  9:25:41  /usr/libexec/mysqld: Shutdown Complete 040920 09:25:41  mysqld ended 040922 10:25:25  mysqld started 040922 10:25:26  InnoDB: Started 040922 10:25:26  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040922 10:25:26  Aborting 040922 10:25:26  InnoDB: Starting shutdown... 040922 10:25:28  InnoDB: Shutdown completed 040922 10:25:28  /usr/libexec/mysqld: Shutdown Complete 040922 10:25:28  mysqld ended 040922 15:12:28  mysqld started 040922 15:12:28  InnoDB: Started 040922 15:12:28  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040922 15:12:28  Aborting 040922 15:12:28  InnoDB: Starting shutdown... 040922 15:12:30  InnoDB: Shutdown completed 040922 15:12:30  /usr/libexec/mysqld: Shutdown Complete 040922 15:12:30  mysqld ended 040922 15:13:00  mysqld started 040922 15:13:00  InnoDB: Started 040922 15:13:00  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040922 15:13:00  Aborting 040922 15:13:00  InnoDB: Starting shutdown... 040922 15:13:02  InnoDB: Shutdown completed 040922 15:13:02  /usr/libexec/mysqld: Shutdown Complete 040922 15:13:02  mysqld ended 040922 15:13:16  mysqld started 040922 15:13:17  InnoDB: Started 040922 15:13:17  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040922 15:13:17  Aborting 040922 15:13:17  InnoDB: Starting shutdown... 040922 15:13:19  InnoDB: Shutdown completed 040922 15:13:19  /usr/libexec/mysqld: Shutdown Complete 040922 15:13:19  mysqld ended

Надявам се това да е въпросния лог.

[tolisoft]

не си си напраил таблиците:
напиши в конзолата
mysql_install_db

[empty]

Ето го резултата:
root@TheMachine:~# mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
040922 16:35:18  /usr/libexec/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h TheMachine password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

root@TheMachine:~#

и като напиша:
root@TheMachine:~# mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
040922 16:35:57  mysqld ended

root@TheMachine:~#

и както виждаш си е пак същата боза.

[tolisoft]

Опа забраи да пратиш лога '>))))))))
аз как да разбера защо гърми сега мога само да предполагам
значи самия демон се пуска с
mysqld_safe --user=mysql &

сега трябва да направиш директориите дето са базите да са собственост на user mysql grupa mysql

дет се вика още не е инсталиран
виж на сайта им кво се праи:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root  .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

[empty]

След изпълнението на всички тези команди пак неще

Примерен код

040917 13:04:34  mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 040917 13:04:36  InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 040917 13:04:37  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... 040917 13:04:37  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 040917 13:04:38  InnoDB: Started 040917 13:04:38  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 13:04:38  Aborting 040917 13:04:38  InnoDB: Starting shutdown... 040917 13:04:40  InnoDB: Shutdown completed 040917 13:04:40  /usr/libexec/mysqld: Shutdown Complete 040917 13:04:40  mysqld ended 040917 13:43:14  mysqld started 040917 13:43:15  InnoDB: Started 040917 13:43:15  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 13:43:15  Aborting 040917 13:43:15  InnoDB: Starting shutdown... 040917 13:43:18  InnoDB: Shutdown completed 040917 13:43:18  /usr/libexec/mysqld: Shutdown Complete 040917 13:43:18  mysqld ended 040917 14:34:21  mysqld started 040917 14:34:22  InnoDB: Started 040917 14:34:22  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 14:34:22  Aborting 040917 14:34:22  InnoDB: Starting shutdown... 040917 14:34:24  InnoDB: Shutdown completed 040917 14:34:24  /usr/libexec/mysqld: Shutdown Complete 040917 14:34:24  mysqld ended 040917 18:02:14  mysqld started 040917 18:02:16  InnoDB: Started 040917 18:02:16  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 18:02:16  Aborting 040917 18:02:16  InnoDB: Starting shutdown... 040917 18:02:18  InnoDB: Shutdown completed 040917 18:02:18  /usr/libexec/mysqld: Shutdown Complete 040917 18:02:18  mysqld ended 040917 19:01:01  mysqld started 040917 19:01:04  InnoDB: Started 040917 19:01:04  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 19:01:04  Aborting 040917 19:01:04  InnoDB: Starting shutdown... 040917 19:01:06  InnoDB: Shutdown completed 040917 19:01:06  /usr/libexec/mysqld: Shutdown Complete 040917 19:01:06  mysqld ended 040917 19:28:12  mysqld started 040917 19:28:13  InnoDB: Started 040917 19:28:13  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040917 19:28:13  Aborting 040917 19:28:13  InnoDB: Starting shutdown... 040917 19:28:15  InnoDB: Shutdown completed 040917 19:28:15  /usr/libexec/mysqld: Shutdown Complete 040917 19:28:15  mysqld ended 040918 10:39:37  mysqld started 040918 10:39:40  InnoDB: Started 040918 10:39:40  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040918 10:39:40  Aborting 040918 10:39:40  InnoDB: Starting shutdown... 040918 10:39:42  InnoDB: Shutdown completed 040918 10:39:42  /usr/libexec/mysqld: Shutdown Complete 040918 10:39:42  mysqld ended 040919 10:44:41  mysqld started 040919 10:44:43  InnoDB: Started 040919 10:44:43  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040919 10:44:43  Aborting 040919 10:44:44  InnoDB: Starting shutdown... 040919 10:44:46  InnoDB: Shutdown completed 040919 10:44:46  /usr/libexec/mysqld: Shutdown Complete 040919 10:44:46  mysqld ended 040920 09:25:36  mysqld started 040920  9:25:38  InnoDB: Started 040920  9:25:38  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040920  9:25:38  Aborting 040920  9:25:39  InnoDB: Starting shutdown... 040920  9:25:41  InnoDB: Shutdown completed 040920  9:25:41  /usr/libexec/mysqld: Shutdown Complete 040920 09:25:41  mysqld ended 040922 10:25:25  mysqld started 040922 10:25:26  InnoDB: Started 040922 10:25:26  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040922 10:25:26  Aborting 040922 10:25:26  InnoDB: Starting shutdown... 040922 10:25:28  InnoDB: Shutdown completed 040922 10:25:28  /usr/libexec/mysqld: Shutdown Complete 040922 10:25:28  mysqld ended 040922 15:12:28  mysqld started 040922 15:12:28  InnoDB: Started 040922 15:12:28  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040922 15:12:28  Aborting 040922 15:12:28  InnoDB: Starting shutdown... 040922 15:12:30  InnoDB: Shutdown completed 040922 15:12:30  /usr/libexec/mysqld: Shutdown Complete 040922 15:12:30  mysqld ended 040922 15:13:00  mysqld started 040922 15:13:00  InnoDB: Started 040922 15:13:00  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040922 15:13:00  Aborting 040922 15:13:00  InnoDB: Starting shutdown... 040922 15:13:02  InnoDB: Shutdown completed 040922 15:13:02  /usr/libexec/mysqld: Shutdown Complete 040922 15:13:02  mysqld ended 040922 15:13:16  mysqld started 040922 15:13:17  InnoDB: Started 040922 15:13:17  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040922 15:13:17  Aborting 040922 15:13:17  InnoDB: Starting shutdown... 040922 15:13:19  InnoDB: Shutdown completed 040922 15:13:19  /usr/libexec/mysqld: Shutdown Complete 040922 15:13:19  mysqld ended 040922 16:35:55  mysqld started 040922 16:35:55  InnoDB: Started 040922 16:35:55  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 040922 16:35:55  Aborting 040922 16:35:55  InnoDB: Starting shutdown... 040922 16:35:57  InnoDB: Shutdown completed 040922 16:35:57  /usr/libexec/mysqld: Shutdown Complete 040922 16:35:57  mysqld ended 040922 16:36:27  mysqld started 040922 16:36:27  InnoDB: Started 040922 16:36:27  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 040922 16:36:27  Aborting 040922 16:36:27  InnoDB: Starting shutdown... 040922 16:36:29  InnoDB: Shutdown completed 040922 16:36:29  /usr/libexec/mysqld: Shutdown Complete 040922 16:36:29  mysqld ended 040922 17:20:25  mysqld started 040922 17:20:25  InnoDB: Started 040922 17:20:25  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 040922 17:20:25  Aborting 040922 17:20:25  InnoDB: Starting shutdown... 040922 17:20:28  InnoDB: Shutdown completed 040922 17:20:28  /usr/libexec/mysqld: Shutdown Complete 040922 17:20:28  mysqld ended 040922 17:21:03  mysqld started 040922 17:21:03  InnoDB: Started 040922 17:21:03  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 040922 17:21:03  Aborting 040922 17:21:03  InnoDB: Starting shutdown... 040922 17:21:06  InnoDB: Shutdown completed 040922 17:21:06  /usr/libexec/mysqld: Shutdown Complete 040922 17:21:06  mysqld ended 040922 17:24:53  mysqld started 040922 17:24:53  InnoDB: Started 040922 17:24:53  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 040922 17:24:53  Aborting 040922 17:24:53  InnoDB: Starting shutdown... 040922 17:24:55  InnoDB: Shutdown completed 040922 17:24:55  /usr/libexec/mysqld: Shutdown Complete 040922 17:24:55  mysqld ended

[tolisoft]

ICQ: 121156262
pishi mi tam i shte te svetna po byrzo

[tolisoft]

Значи подкарахме го по ICQ със следните команди:

mysql_install_db --user=mysql
cd /var/lib
chown -R mysql mysql
chgrp -R mysql mysql
cd ~
mysqld_safe --user=mysql &

и тука си бачка ............

[zeridon]

извинете за тъпият въпрос но чували ли сте RTFM точно в Мто си пише как се инсталира MySQL

Там си пише след инсталация:
#su mysql
#mysql_install_db
след креатването на началната база ви изписква да аднете юзер. За да го направите SQL-a трябва да върви.

Не че аз лично имам много опит с MySQL но от 10те инсталации които съм правил досега не съм имал нито един проблем (8 са на слак) ....

[draco]

От 5 инсталации на Slackware нито 1 път без проблеми.При Slackware 10  : chown  mysql /var/lib/mysql/mysql и всичките филес вътре в дира.Не че така се прави ама тръгна.

[tolisoft]

zeridon извинен си :о)

[tolisoft]

zeridon щом помниш колко инсталации си правил на mysql значи не са много '> аз лично не помня '>