Can't start mysqld
Greetings I just installed mysql and a few other packages but it gives me these erros: [EMAIL PROTECTED] zabbix-1.4.2]# service mysqld start mysqld: unrecognized service __ [EMAIL PROTECTED] zabbix-1.4.2]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) __ I am using Fedora 7x86 and mysql 5. Someone please help -- A church is a hospital for sinners, not a museum for saints. Abigail Van Buren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start mysqld
did u try this /etc/init.d/mysql start On 11/20/07, sizo nsibande [EMAIL PROTECTED] wrote: Greetings I just installed mysql and a few other packages but it gives me these erros: [EMAIL PROTECTED] zabbix-1.4.2]# service mysqld start mysqld: unrecognized service __ [EMAIL PROTECTED] zabbix-1.4.2]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) __ I am using Fedora 7x86 and mysql 5. Someone please help -- A church is a hospital for sinners, not a museum for saints. Abigail Van Buren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start mysqld
On 20/11/2007, sizo nsibande [EMAIL PROTECTED] wrote: Greetings I just installed mysql and a few other packages but it gives me these erros: [EMAIL PROTECTED] zabbix-1.4.2]# service mysqld start mysqld: unrecognized service __ [EMAIL PROTECTED] zabbix-1.4.2]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) __ I am using Fedora 7x86 and mysql 5. Someone please help -- A church is a hospital for sinners, not a museum for saints. Abigail Van Buren Sorry about that guys, just fixed the problem, seems as though I had not installed the server :) -- A church is a hospital for sinners, not a museum for saints. Abigail Van Buren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: can't start mysqld
Hello. Are you using an official binary? Was there any error messages before crashing? Resolve the stack trace. Follow recomendations from: http://www.mysql.com/doc/en/Crashing.html Jack [EMAIL PROTECTED] wrote: hi,all. i can't start mysqld anymore , it's log reports below: 050503 00:09:58 mysqld started mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16384 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 19215 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x40035158, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x814aecd 0x40035450 (nil) New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Reso lved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 050503 00:09:58 mysqld ended and i try to run mysql_install_db the backtrace is still 0x814aecd .. and i haven't found any one else has met this problem . so any suggestion ? i believe that thereis something wrong with my.cnf or i havn'e set some variable of it, because i have succeed starting the mysqld before my system has been cracked . and don't think that the system has some problem , the system i backup from the system that the mysqld has been started before. see my my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer_size=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-innodb skip-bdb [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid jack -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't start mysqld
hi,all. i can't start mysqld anymore , it's log reports below: 050503 00:09:58 mysqld started mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16384 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 19215 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x40035158, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x814aecd 0x40035450 (nil) New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Reso lved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 050503 00:09:58 mysqld ended and i try to run mysql_install_db the backtrace is still 0x814aecd .. and i haven't found any one else has met this problem . so any suggestion ? i believe that thereis something wrong with my.cnf or i havn'e set some variable of it, because i have succeed starting the mysqld before my system has been cracked . and don't think that the system has some problem , the system i backup from the system that the mysqld has been started before. see my my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer_size=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-innodb skip-bdb [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: I can't start mysqld
In the data directory for MySQL, you should find a file titled hostname.err. What is the contents of that file? -Original Message- From: Hamid Nouri [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 5:07 PM To: [EMAIL PROTECTED] Subject: I can't start mysqld Hi there I have a problem with starting mysqld. I tried to install mysql-4.1 on my debian, but when i want to start mysql daemon it failes. I generated bug report. my.cnf and mysql also attached. Thanks in advance - SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject:synopsis of the problem (one line) Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.1.0-alpha-standard (Official MySQL-standard binary) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: machine, os, target, libraries (multiple lines) System: Linux pinguin 2.4.18-bf2.4 #1 Son Apr 14 09:53:28 CEST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 3 13:31 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 28 2002 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Apr 28 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 28 2002 /usr/lib/libc.so -rw-r--r--1 root root 716080 Jan 13 2002 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc' my.cnf--- # You can copy this to one of: # /etc/mysql/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password = my_password port= 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram [safe_mysqld] err-log = /var/log/mysql/mysql.err [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 # # You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log # for backward compatibility. Both location gets rotated by the cronjob. #log= /var/log/mysql/mysql.log log = /var/log/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-locking # # The skip-networkin option will no longer be set via debconf menu. # You have to manually change it if you want networking i.e. the server # listening on port 3306. The default is disable - for security reasons. skip-networking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication #server-id = 1 #log-bin= /var/log/mysql/mysql-bin.log #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # Read the manual if you want to enable InnoDB! skip-innodb [mysqldump] quick set-variable
I can't start mysqld
Hi there I have a problem with starting mysqld. I tried to install mysql-4.1 on my debian, but when i want to start mysql daemon it failes. I generated bug report. my.cnf and mysql also attached. Thanks in advance - SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject:synopsis of the problem (one line) Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.1.0-alpha-standard (Official MySQL-standard binary) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: machine, os, target, libraries (multiple lines) System: Linux pinguin 2.4.18-bf2.4 #1 Son Apr 14 09:53:28 CEST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 3 13:31 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 28 2002 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Apr 28 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 28 2002 /usr/lib/libc.so -rw-r--r--1 root root 716080 Jan 13 2002 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc' my.cnf--- # You can copy this to one of: # /etc/mysql/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password = my_password port= 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram [safe_mysqld] err-log = /var/log/mysql/mysql.err [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 # # You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log # for backward compatibility. Both location gets rotated by the cronjob. #log= /var/log/mysql/mysql.log log = /var/log/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-locking # # The skip-networkin option will no longer be set via debconf menu. # You have to manually change it if you want networking i.e. the server # listening on port 3306. The default is disable - for security reasons. skip-networking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication #server-id = 1 #log-bin= /var/log/mysql/mysql-bin.log #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # Read the manual if you want to enable InnoDB! skip-innodb [mysqldump] quick set-variable= max_allowed_packet=1M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] set-variable= key_buffer=16M --mysql- #!/bin/sh -e # # MySQL daemon start/stop script. # # Debian version. Based on the original by
Re: I can't start mysqld
On Saturday 18 October 2003 03:07 pm, Hamid Nouri wrote: Hi there I have a problem with starting mysqld. I tried to install mysql-4.1 on my debian, but when i want to start mysql daemon it failes. I generated bug report. my.cnf and mysql also attached. [...] Umm.. What's the error? --Jo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: can't start mysqld
Krichene: I have installed mysql on my Linux redhat 7.2 System. when I try to lauch the mysqld ,the message is [ok] but when i launch service mysql status, i got the folowwing :mysql is dead but subsys is locked and I can't connect to my database Can you help me please Think you Please be so kind to provide more information of your enviroment in order to narrow in the problem. Thanks, Jakob ^-- To Unix or not to Unix. That is the question whether 'tis nobler in the mind to suffer slings and arrows of vast documentation or to take arms against a sea of buggy OS and by raping the support lines end then? ; Contact: \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ \/Jakob Dölling \/EMail: mailto:[EMAIL PROTECTED]/ Treuerzipfel 13 ICQ #: 47326203 /\D-38678 Clausthal /\SMS #: +49-82668-8918663/\ /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ /\Webmaster of http://www.bank-ic.de/ /\ \/\/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't start mysqld
Hello I have installed mysql on my Linux redhat 7.2 System. when I try to lauch the mysqld ,the message is [ok] but when i launch service mysql status, i got the folowwing :mysql is dead but subsys is locked and I can't connect to my database Can you help me please Think you -- Faites un voeu et puis Voila ! www.voila.fr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start mysqld from Source Distro - can't readmessagefile errmsg.sys
I think I have solved this - though what I had to do was weird. In mysql-VERSION/support-files there's a program called comp_err. You need to cd to the share/language directory and run # comp_err errmsg.txt errmsg.sys Then run scripts/mysql_install_db. Why should I have to do this? Sounds like a bug to me, and I've now done this on both SuSE 7.0 and SuSE8.0. Tony Butcher From: Gerald Clark [EMAIL PROTECTED] Organization: Supplier Systems Corporation Date: Fri, 06 Sep 2002 13:30:29 -0500 To: Tony Butcher [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Can't start mysqld from Source Distro - can't read messagefile errmsg.sys You have to create a mysql user and chown -R mysql /usr/local/mysql then run ./scripts/mysql_install_db --user=mysql Tony Butcher wrote: Hi, I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make install go fine, but then when I try to run the mysql_install_db script I get a failure. Here's the error: backup:/usr/local/mysql-4.0.3-beta # ./scripts/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 020906 13:20:20 Can't read from messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys' 020906 13:20:20 Aborting Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script! It complains that it can't read the messagfile errmsg.sys, but I know it's there! Here it is: backup:/usr/local/mysql-4.0.3-beta # l /usr/local/mysql/share/mysql/english/errmsg.sys -rw-r--r-- 1 root mysql 12183 Sep 2 17:34 /usr/local/mysql/share/mysql/english/errmsg.sys Is anyone else getting this? Any ideas how to get round it? Thanks! Tony Butcher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't start mysqld from Source Distro - can't read messagefileerrmsg.sys
Hi, I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make install go fine, but then when I try to run the mysql_install_db script I get a failure. Here's the error: backup:/usr/local/mysql-4.0.3-beta # ./scripts/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 020906 13:20:20 Can't read from messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys' 020906 13:20:20 Aborting Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script! It complains that it can't read the messagfile errmsg.sys, but I know it's there! Here it is: backup:/usr/local/mysql-4.0.3-beta # l /usr/local/mysql/share/mysql/english/errmsg.sys -rw-r--r-- 1 root mysql 12183 Sep 2 17:34 /usr/local/mysql/share/mysql/english/errmsg.sys Is anyone else getting this? Any ideas how to get round it? Thanks! Tony Butcher
Re: Can't start mysqld from Source Distro - can't read messagefile errmsg.sys
You have to create a mysql user and chown -R mysql /usr/local/mysql then run ./scripts/mysql_install_db --user=mysql Tony Butcher wrote: Hi, I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make install go fine, but then when I try to run the mysql_install_db script I get a failure. Here's the error: backup:/usr/local/mysql-4.0.3-beta # ./scripts/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 020906 13:20:20 Can't read from messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys' 020906 13:20:20 Aborting Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script! It complains that it can't read the messagfile errmsg.sys, but I know it's there! Here it is: backup:/usr/local/mysql-4.0.3-beta # l /usr/local/mysql/share/mysql/english/errmsg.sys -rw-r--r-- 1 root mysql 12183 Sep 2 17:34 /usr/local/mysql/share/mysql/english/errmsg.sys Is anyone else getting this? Any ideas how to get round it? Thanks! Tony Butcher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't start mysqld from Source Distro - can't readmessagefile errmsg.sys
Sorry, user mysql and group mysql already exist, and permissions were already set correctly. It didn't work. Any more ideas? Thanks again. Tony From: Gerald Clark [EMAIL PROTECTED] Organization: Supplier Systems Corporation Date: Fri, 06 Sep 2002 13:30:29 -0500 To: Tony Butcher [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Can't start mysqld from Source Distro - can't read messagefile errmsg.sys You have to create a mysql user and chown -R mysql /usr/local/mysql then run ./scripts/mysql_install_db --user=mysql Tony Butcher wrote: Hi, I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make install go fine, but then when I try to run the mysql_install_db script I get a failure. Here's the error: backup:/usr/local/mysql-4.0.3-beta # ./scripts/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 020906 13:20:20 Can't read from messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys' 020906 13:20:20 Aborting Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script! It complains that it can't read the messagfile errmsg.sys, but I know it's there! Here it is: backup:/usr/local/mysql-4.0.3-beta # l /usr/local/mysql/share/mysql/english/errmsg.sys -rw-r--r-- 1 root mysql 12183 Sep 2 17:34 /usr/local/mysql/share/mysql/english/errmsg.sys Is anyone else getting this? Any ideas how to get round it? Thanks! Tony Butcher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: system error 1067 - can't start mysqld
Hello, This is a classical problem ... when you install mysql into an other path than c:/mysql/ , you remove it and reinstall into an other directory. At first you must verify the my.ini file into c:/winnt/ . If mysql has been installed into an other directory than c:/mysql/ you can verify basedir and datadir paths in c:/winnt/my.ini file. If mysql is installed in c:/mysql/ , c:/winnt/my.ini must be deleted. After that, in a command schell type: cd your mysql directory cd bin mysqld-nt --remove mysqld-nt --install NET START mysql and now everything should be OK. Bye,Jerome Alexander Hampel wrote: Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Thank you, A:lex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
system error 1067 - can't start mysqld
Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Thank you, A:lex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't Start Mysqld
Hey I installed the MySQL pkg from http://pkg.nl.cobalt.com a couple of weeks ago and I went through steps just like on the site. That all went ok but since then I have been busy and forgot what I changed the root pass to. Is there any way to recover this? If not what is the best thing to do to get mysql back up and running. Thanks for the help. Ok I have tried both things on this page and both don't work. I can't seem to get mysql to start. http://list.cobalt.com/pipermail/cobalt-users/2000-October/023700.html I have also tried other suggestions given to me by others (ie changing permissions) but still the same thing Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended I don't have any databases setup yet so I am not worried about loseing them. Juse worried about screwing Chiliasp up. Anything will help. Thanks again Todd Todd Woolums Wescris Solutions http://www.wescris.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't start mysqld
On Tue, Jan 30, 2001 at 01:09:14AM +0100, [EMAIL PROTECTED] wrote: Description: Can't start mysqld. In /var/mysql/hostname.err, there is a line saying "getpwnam: Undefined error: 0" How-To-Repeat: /usr/local/bin/safe_mysqld Hm. What user have you configured MySQL to run as? Does that user exist? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php