Изпечатай

[PERMANENT]

hi
Пробвах да пуста mysql-а така
/etc/rc.d/rc.mysqld start
и ми дава този ерор
root@Rock-man:~# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
070214 23:32:47  mysqld ended
пробвах и с друг mysql но тогава същия този проблем възниква при изпълнението на configure-то
root@Rock-man:~/mysql-standard-5.0.27-linux-i686-glibc23# Starting mysqld daemon with databases from /root/mysql-standard-5.0.27-linux-i686-glibc23/data
STOPPING server from pid file /root/mysql-standard-5.0.27-linux-i686-glibc23/data/Rock-man.pid
070214 23:36:47  mysqld ended
с друго ядро  пак се получава същото.До колкото знам в тези pid фаилове се съхранява id-то  на програмата и точно за това идея си нямам защо става така.Ще се радвам някои да помогне
дистрото е slackware 11

[aminohus]

Виж си правата над папката - /var/run/mysql
трябва да са на потребител mysql.
chown mysql.mysql /var/run/mysql

[VladSun]

Най-вече си виж лог-файла ...
Може би не си инициализирал mysql базата данни...

[PERMANENT]

Смених правата на /var/run/mysql и /var/lib/mysql както и на фсички фаилове вътре но вгадения mysql не тръгна.Както бях писам пробвах да инсталирам друг и при изпълнение на configure-то ми дава съшия проблем.В фаила passwd има потребител mysql
mysql:x:27:0:mysql:/var/run/mysql:/bin/bash
а в group има група
mysql::0:
в shadow работата стои така
mysql:*:9797:0:::::

Цитат

Най-вече си виж лог-файла ... Може би не си инициализирал mysql базата данни...

може ли да дадете малко упочнение за този лог фаил

[VladSun]

Примерен код

locate hostname.err

Като hostname го замести с това дето ти го пише в промпта:
root@hostname:/

След това намери и пусни mysql_install_db, ако ти казва, че не са открити разни таблици.

[PERMANENT]

locate Rock-man.err =>
locate: fatal error: Could not find user database '/var/lib/slocate/slocate.db':  No such file or directory

mysql_install_db(англииския ми куца за това ще го пусна цялото)
=>

Цитат

WARNING: The host 'Rock-man' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Installing all prepared tables Fill help tables 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 rock-man password 'new-password' See the manual for more instructions. NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! 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 [URL=http://shop.mysql.com

[VladSun]

Цитат (PERMANENT @ Фев. 18 2007,14:26)

locate Rock-man.err => locate: fatal error: Could not find user database '/var/lib/slocate/slocate.db':  No such file or directory

Пуни първо
locate -u

[PERMANENT]

сега стана а резултата е
/var/lib/mysql/rock-man.err
/fat/d/Server/www/mysql/data/rock-man.err

/fat/d/Server/www/ - е директорията на стария xampp за windows
не го ползвам но го пазя заедно със старите ми саитчета.
Не разбирам каква е идеята на това но вярвам че ще помогне  '>

edit:
след тази процедура абсолутно нищо не се промени пак става същия проблем

[VladSun]

Е, кажи какво пише в тия логове, де '> - тогава ще помогне '>

[PERMANENT]

'>
/var/lib/mysql/rock-man.err

Примерен код

070218 02:10:09  mysqld started nice: -: No such file or directory 070218 02:10:09  mysqld ended 070218 02:12:40  mysqld started nice: -: No such file or directory 070218 02:12:40  mysqld ended 070218 02:13:31  mysqld started nice: -: No such file or directory 070218 02:13:31  mysqld ended 070218 03:21:42  mysqld started nice: -: No such file or directory 070218 03:21:42  mysqld ended 070218 03:26:25  mysqld started nice: -: No such file or directory 070218 03:26:25  mysqld ended 070218 03:30:19  mysqld started nice: -: No such file or directory 070218 03:30:19  mysqld ended 070218 03:42:22  mysqld started nice: -: No such file or directory 070218 03:42:23  mysqld ended

това е
предишнсшя ми хостнаме беше darkstar и имам фаил
/var/lib/mysql/darkstar.err

срязах го доста защото ще е безумна лудост да го пусна целия
то така и така се повтаря де

Примерен код

070215 18:18:25  mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070215 18:18:26  InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070215 18:18:27  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... 070215 18:18:27  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 070215 18:18:28  InnoDB: Started; log sequence number 0 0 070215 18:18:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 070215 18:18:28  mysqld ended 070215 20:14:23  mysqld started 070215 20:14:24  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... 070215 20:14:24  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 070215 20:14:24  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 070215 20:14:25  InnoDB: Started; log sequence number 0 43655 070215 20:14:25 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 070215 20:14:25  mysqld ended Number of processes running now: 0 070215 22:55:32  mysqld restarted 070215 22:55:32  InnoDB: Started; log sequence number 0 43655 070215 22:55:32 [ERROR] Can't start server : Bind on unix socket: No such file or directory 070215 22:55:32 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? 070215 22:55:32 [ERROR] Aborting 070215 22:55:32  InnoDB: Starting shutdown... 070215 22:55:34  InnoDB: Shutdown completed; log sequence number 0 43655 070215 22:55:34 [Note] /usr/libexec/mysqld: Shutdown complete Number of processes running now: 0 070215 22:56:02  mysqld restarted 070215 22:56:02  InnoDB: Started; log sequence number 0 43655 070215 22:56:02 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 070217 10:14:59  mysqld started nice: -: No such file or directory 070217 10:14:59  mysqld ended

edit:

смятам да инсталирам друг mysql и в инсталацията има фаил
/data/darkstar.err ще го пусна за да кажете какво да направя за да мога да го инстална

Примерен код

070216 11:36:12  mysqld started 070216 11:36:13  InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 070216 11:36:13  mysqld ended 070216 11:38:27  mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070216 11:38:27  InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070216 11:38:28  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... 070216 11:38:28  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 070216 11:38:28  InnoDB: Started; log sequence number 0 0 070216 11:38:28 [ERROR] /root/package/mysql/bin/mysqld: Can't create/write to file '/root/package/mysql/data/darkstar.pid' (Errcode: 13) 070216 11:38:28 [ERROR] Can't start server: can't create PID file: Permission denied 070216 11:38:28  mysqld ended 070216 14:30:33  mysqld started 070216 14:30:33  InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 070216 14:30:33  mysqld ended

[p_penchev]

Здравей,
Имах същия проблем. Виж тази тема, абсолютно всичко което ти трябва за да подкараш mysql под slack11 е описано вътре.
http://www.linux-bg.org/cgi-bin....l=mysql
Успех!