Can't open privilege tables
Using 4.0.20 on Slack 10.0 New setup. mysql_install_db was run. On startup, the error log shows the following error message: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) It would appear the paths are not being set. - Need advice on what to do next. URLs of documentation would be appreciated as well. - When I ran mysql_install_db, part of the message displayed at that time was: To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system And I'm sorry to say, but I don't know what that means. duh Again, advice and clarification of these instructions are welcome. Thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables
Hello. [EMAIL PROTECTED] gleb]$ perror 13 OS error code 13: Permission denied Check that you have correct permissions set on MySQL datadir. See: http://dev.mysql.com/doc/mysql/en/mysql-install-db.html Tim Johnson [EMAIL PROTECTED] wrote: Using 4.0.20 on Slack 10.0 New setup. mysql_install_db was run. On startup, the error log shows the following error message: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) It would appear the paths are not being set. - Need advice on what to do next. URLs of documentation would be appreciated as well. - When I ran mysql_install_db, part of the message displayed at that time was: To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system And I'm sorry to say, but I don't know what that means. duh Again, advice and clarification of these instructions are welcome. Thanks tim -- 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]
Re: Can't open privilege tables/mysql.sock
* Gleb Paharenko [EMAIL PROTECTED] [050711 07:17]: Hello Gleb: Check that you have correct permissions set on MySQL datadir. See: http://dev.mysql.com/doc/mysql/en/mysql-install-db.html I will add to the comments above. I had to set the owner and group to mysql as per my redhat setup. More problems tho: == When invoking mysql, I get the following error message: Can't connect to local MySQL server through socket at 'var/lib/run/mysql/mysql.sock' hmm! mysql.sock was created at var/lib/mysql. owner=mysql, permissions=777 So again, is there paths/permissions problems? The following is in /etc/my.cnf -- [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid - Thank you for your help so far. Further support greatly appeciated. :-) Further pointers to docs invited! Regards Tim Using 4.0.20 on Slack 10.0 New setup. mysql_install_db was run. On startup, the error log shows the following error message: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) It would appear the paths are not being set. - Need advice on what to do next. URLs of documentation would be appreciated as well. - When I ran mysql_install_db, part of the message displayed at that time was: To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system And I'm sorry to say, but I don't know what that means. duh Again, advice and clarification of these instructions are welcome. Thanks tim -- 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] -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables/mysql.sock
Tim Johnson wrote: * Gleb Paharenko [EMAIL PROTECTED] [050711 07:17]: Hello Gleb: Check that you have correct permissions set on MySQL datadir. See: http://dev.mysql.com/doc/mysql/en/mysql-install-db.html I will add to the comments above. I had to set the owner and group to mysql as per my redhat setup. More problems tho: == When invoking mysql, I get the following error message: Can't connect to local MySQL server through socket at 'var/lib/run/mysql/mysql.sock' hmm! mysql.sock was created at var/lib/mysql. owner=mysql, permissions=777 So again, is there paths/permissions problems? Since this is where your my.cnf says to put it, it would be a problem if it was not there. If you are going to override the default location of the socket for the server, you will also need to add an entry for the client. [mysql] socket=/var/lib/mysql/mysql.sock The following is in /etc/my.cnf -- [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid - Thank you for your help so far. Further support greatly appeciated. :-) Further pointers to docs invited! Regards Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables/mysql.sock
hmm! mysql.sock was created at var/lib/mysql. owner=mysql, permissions=777 So again, is there paths/permissions problems? Since this is where your my.cnf says to put it, it would be a problem if it was not there. If you are going to override the default location of the socket for the server, you will also need to add an entry for the client. [mysql] socket=/var/lib/mysql/mysql.sock ... of course ... duh That's what I needed. (the my.cnf was copied from a RH 9.0 partition with mysql 3.23.58) Well done! thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
Hello. Usually such error occurs on Windows boxes. If you can apply recomendations for Windows to FreeBSD :), look at: http://dev.mysql.com/doc/mysql/en/Windows_troubleshooting.html Can you upgrade to 4.0.22 or 4.1.7? Ricardo David Martins [EMAIL PROTECTED] wrote: Hi I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried to run mysqld_safe to add a root password but i can't seem to run the safe command because it shuts down immediately. The following error is presented to me: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) I would like it to load the latin1.conf charset. I can't find any variable that influences this choice. Probably there is something not configured or the configuration isn't supported. Anyway I would like to know how to choose this. I installed the binary freebsd package which is suppose to be very reliable to a quick start. Thanks --=20 Ricardo David Martins ___= __ AVISO Esta mensagem (incluindo quaisquer anexos) pode conter informa=E7=E3o confidencial para uso exclusivo do destinat=E1rio. Se n=E3o for o destinat=E1rio pretendido, n=E3o dever=E1 usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado. DISCLAIMER This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You. ___= __ -- 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]
Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
Hi I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried to run mysqld_safe to add a root password but i can't seem to run the safe command because it shuts down immediately. The following error is presented to me: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) I would like it to load the latin1.conf charset. I can't find any variable that influences this choice. Probably there is something not configured or the configuration isn't supported. Anyway I would like to know how to choose this. I installed the binary freebsd package which is suppose to be very reliable to a quick start. Thanks -- Ricardo David Martins _ AVISO Esta mensagem (incluindo quaisquer anexos) pode conter informação confidencial para uso exclusivo do destinatário. Se não for o destinatário pretendido, não deverá usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado. DISCLAIMER This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You. _ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
Have you run mysql_install_db yet? Have you read the freebsd platform notes http://dev.mysql.com/doc/mysql/en/FreeBSD.html and the post-install instructions http://dev.mysql.com/doc/mysql/en/Post-installation.html? If not, I'd suggest starting there. If that doesn't help, write back with some more details, such as: Is this your first attempt to start the server after install? When you say, the binary freebsd package, which do you mean, one of the two from mysql.com, or the packages from freebsd.org? You mention configuration. What, if any, configuration have you done? (Mysql ought to start fine with default settings.) Michael Ricardo David Martins wrote: Hi I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried to run mysqld_safe to add a root password but i can't seem to run the safe command because it shuts down immediately. The following error is presented to me: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) I would like it to load the latin1.conf charset. I can't find any variable that influences this choice. Probably there is something not configured or the configuration isn't supported. Anyway I would like to know how to choose this. I installed the binary freebsd package which is suppose to be very reliable to a quick start. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: Could not start MySQL after reinstall - Can't open privilege tables: Table 'mysql.host' doesn't exist
Since the database I created was not critical, I could simply throw it away. Therefore, delete the whole MySql installation directory and unzip the alpha release zip file again to create the installation directory tree. However, the following error persists: Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist Everything should be wiped out I thought. Does MySQL saves some data somewhere other than the installation directory? More help, please? Michael Wu -Original Message- From: Robert J Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 4:52 PM To: michael_wu[¡±d¡±?1F] Cc: [EMAIL PROTECTED] Subject: Re: Could not start MySQL after reinstall - Can't open privilege tabl es: Table 'mysql.host' doesn't exist Check permissions on the mysql\data directory and files/folders below for the MySQL process/user (sorry for not knowing the right Windows terminology, I'm not a Windows user). HTH, Robert J Taylor [EMAIL PROTECTED] michael_wu[§d§»¹F] wrote: Hello, I run into a problem after re-installing mySQL 4.1.1 today. When I tried to start the service on my Windows2K, I got the following error: 040527 15:37:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist Can some one tell me how to solve the problem? Thanks in advance! Michael Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FW: Could not start MySQL after reinstall - Can't open privilege tables: Table 'mysql.host' doesn't exist
Did you change the permissions for the files to include read/write/change for the user/account MySQL uses on your system? This doesn't require deleting, as far as I recall Windows permissions... Oh, can you verify that the file host under directory mysql DOES exist? If so, it's really most likely a permissions problem. MICHAEL_WU wrote: Since the database I created was not critical, I could simply throw it away. Therefore, delete the whole MySql installation directory and unzip the alpha release zip file again to create the installation directory tree. However, the following error persists: Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist Everything should be wiped out I thought. Does MySQL saves some data somewhere other than the installation directory? More help, please? Michael Wu -Original Message- From: Robert J Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 4:52 PM To: michael_wu[¡±d¡±?1F] Cc: [EMAIL PROTECTED] Subject: Re: Could not start MySQL after reinstall - Can't open privilege tabl es: Table 'mysql.host' doesn't exist Check permissions on the mysql\data directory and files/folders below for the MySQL process/user (sorry for not knowing the right Windows terminology, I'm not a Windows user). HTH, Robert J Taylor [EMAIL PROTECTED] michael_wu[§d§»¹F] wrote: Hello, I run into a problem after re-installing mySQL 4.1.1 today. When I tried to start the service on my Windows2K, I got the following error: 040527 15:37:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist Can some one tell me how to solve the problem? Thanks in advance! Michael Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables: Out of memory error
At 11:14 -0700 9/25/03, [EMAIL PROTECTED] wrote: Description: bin/mysqld_safe --user=mysql fails with the following error (from data/host.err file) 030925 10:58:58 mysqld started 030925 10:58:59 InnoDB: Started 030925 10:58:59 Fatal error: Can't open privilege tables: Out of memory (Needed 2976468256 bytes) 030925 10:58:59 Aborting How-To-Repeat: startup of mysqld_safe fails for version 4.0.15; running concurrent with mysqld 3.23.54a using the same data files Try it when you have 3.23.54a shut down and see if 4.0.15 starts up properly. using different socket and port Fix: none known yet Submitter-Id: submitter ID Originator: Jim Rapp Organization: UCSD Academic Computing Services MySQL support: [none | licence | email support | extended email support ] Synopsis: can't start mysqld 4.0.15 (using binary installation for Solaris 5.8 64-bit) Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.15-standard (Official MySQL-standard binary) C compiler:gcc (GCC) 3.3 C++ compiler: gcc (GCC) 3.3 Environment: G E N E R A LI N F O R M A T I O N DESCRIPTION VALUE Host Nameinsci14.ucsd.edu Host Aliases insci14 loghost Host Address(es) 132.239.56.230 Host ID 80fec484 Serial Number2164180100 Manufacturer Sun (Sun Microsystems) Manufacturer (Short) Sun Manufacturer (Full) Sun Microsystems System Model Enterprise 450 Model 4300 Main Memory 512 MB Virtual Memory 455 MB ROM Version OBP 3.20.0 2000/10/24 10:47 Number of CPUs 4 CPU Type sparcv9+vis CPU Speed296 MHz App Architecture sparc Kernel Architecture sun4u Kernel Bit Size 64 OS Name SunOS OS Version 5.8 OS Distribution Solaris 8 7/01 s28s_u5wos_08 SPARC Libc Namelibc Libc Version 1 Kernel Version SunOS Release 5.8 Version Generic_108528-23 64-bit Boot TimeTue Sep 23 07:11:52 2003 PDT Current Time Thu Sep 25 11:11:51 2003 PDT System: SunOS insci14.ucsd.edu 5.8 Generic_108528-23 sun4u sparc SUNW,Ultra-4 Architecture: sun4 Some paths: /bin/perl /usr/ccs/bin/make /opt/SUNWspro/bin/cc Compilation info: CC='gcc' CFLAGS='-m64' CXX='gcc' CXXFLAGS='-m64' LDFLAGS='' ASFLAGS='' LIBC: -rw-r--r-- 1 root bin 1788708 Jul 29 14:57 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 20 2002 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1157900 Jul 29 14:57 /lib/libc.so.1 -rw-r--r-- 1 root bin 1788708 Jul 29 14:57 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 20 2002 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1157900 Jul 29 14:57 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' 'CFLAGS=-m64' 'CXXFLAGS=-m64' '--enable-assembler' '--with-named-z-libs=no' '--with-named-curses-libs=-lcurses' '--disable-shared' '--with-embedded-server' '--with-innodb' 'CC=gcc' 'CXX=gcc' -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't open privilege tables: Out of memory error
Description: bin/mysqld_safe --user=mysql fails with the following error (from data/host.err file) 030925 10:58:58 mysqld started 030925 10:58:59 InnoDB: Started 030925 10:58:59 Fatal error: Can't open privilege tables: Out of memory (Needed 2976468256 bytes) 030925 10:58:59 Aborting How-To-Repeat: startup of mysqld_safe fails for version 4.0.15; running concurrent with mysqld 3.23.54a using the same data files using different socket and port Fix: none known yet Submitter-Id: submitter ID Originator:Jim Rapp Organization: UCSD Academic Computing Services MySQL support: [none | licence | email support | extended email support ] Synopsis: can't start mysqld 4.0.15 (using binary installation for Solaris 5.8 64-bit) Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.15-standard (Official MySQL-standard binary) C compiler:gcc (GCC) 3.3 C++ compiler: gcc (GCC) 3.3 Environment: G E N E R A LI N F O R M A T I O N DESCRIPTION VALUE Host Nameinsci14.ucsd.edu Host Aliases insci14 loghost Host Address(es) 132.239.56.230 Host ID 80fec484 Serial Number2164180100 Manufacturer Sun (Sun Microsystems) Manufacturer (Short) Sun Manufacturer (Full) Sun Microsystems System Model Enterprise 450 Model 4300 Main Memory 512 MB Virtual Memory 455 MB ROM Version OBP 3.20.0 2000/10/24 10:47 Number of CPUs 4 CPU Type sparcv9+vis CPU Speed296 MHz App Architecture sparc Kernel Architecture sun4u Kernel Bit Size 64 OS Name SunOS OS Version 5.8 OS Distribution Solaris 8 7/01 s28s_u5wos_08 SPARC Libc Namelibc Libc Version 1 Kernel Version SunOS Release 5.8 Version Generic_108528-23 64-bit Boot TimeTue Sep 23 07:11:52 2003 PDT Current Time Thu Sep 25 11:11:51 2003 PDT System: SunOS insci14.ucsd.edu 5.8 Generic_108528-23 sun4u sparc SUNW,Ultra-4 Architecture: sun4 Some paths: /bin/perl /usr/ccs/bin/make /opt/SUNWspro/bin/cc Compilation info: CC='gcc' CFLAGS='-m64' CXX='gcc' CXXFLAGS='-m64' LDFLAGS='' ASFLAGS='' LIBC: -rw-r--r-- 1 root bin 1788708 Jul 29 14:57 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 20 2002 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1157900 Jul 29 14:57 /lib/libc.so.1 -rw-r--r-- 1 root bin 1788708 Jul 29 14:57 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 20 2002 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1157900 Jul 29 14:57 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' 'CFLAGS=-m64' 'CXXFLAGS=-m64' '--enable-assembler' '--with-named-z-libs=no' '--with-named-curses-libs=-lcurses' '--disable-shared' '--with-embedded-server' '--with-innodb' 'CC=gcc' 'CXX=gcc' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
Hi Heikki, Thank you for confirming what I was also thinking about. I realised that when specifying datadir=/usr/local/mysql that the server doesnt start up. Knowing this I also realised that I still have some need to learn ;-). I already have some more questions, but I will go back to studies first before posting anything silly ;-). Anyway thank you for the reply. Best regards Nils Valentin Tokyo/Japan 2003 6 4 21:09Heikki Tuuri : Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, June 04, 2003 7:05 AM Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist Sorry, I should have given more details.=20 Its Mysql 4.1 alpha on a Suse Linux system Version 8.1. =2E..and yes, the mysql.host table and the other 5 exist and are well alive= ;-). If I replace my.cnf with a version skipping innodb then it perfectly starts= =20 up, so it must be related to innodb, perhaps my.cnf and/or mysql itself. the problem is in your my.cnf or the access rights of the person running mysqld. The error means mysqld cannot access the file host.frm in the mysql subdir under the datadir. I suggest specifying the datadir explicitly in your my.cnf. Best regards Nils Valentin Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ Hi Mysql list members, I added a Innodb database to the existing MyISAM databases and now MySQL doesnt start up. From the InnoDB logfile I saw this error message Can't open privilege tables: Table 'mysql.host' doesn't exist Does any body know what this error comes from ? innodb logfile extract. 030603 16:46:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 80 MB InnoDB: Database physically writes the file full: wait... 030603 16:46:31 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 80 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 030603 16:46:48 InnoDB: Started 030603 16:46:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030603 16:46:49 mysqld ended . 030604 09:30:28 mysqld started 030604 9:30:47 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030604 9:30:48 InnoDB: Flushing modified pages from the buffer pool... 030604 9:30:49 InnoDB: Started 030604 9:30:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030604 09:30:49 mysqld ended Any reply much appreciated. -- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =2D-=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
Nils, most probably you have some other difference in the my.cnf files. Regards, Heikki - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 6:22 PM Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist Hi Heikki, Thank you for the reply. I understand that this is related to the host.frm. Thank you very much. The part which I don't get is why would a standard my.cnf file (skipping innodb) start up and the my.cnf file containing the innodb settings give me such an error ? I understood your advice and I am in process of repairing this, however I would really appreciate if I could also technically understand why this is. This case I can learn and step up ;-) Do you mind explaining why this is ? Best regards Nils Valentin 2003 6 4 21:09Heikki Tuuri : Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, June 04, 2003 7:05 AM Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist Sorry, I should have given more details.=20 Its Mysql 4.1 alpha on a Suse Linux system Version 8.1. =2E..and yes, the mysql.host table and the other 5 exist and are well alive= ;-). If I replace my.cnf with a version skipping innodb then it perfectly starts= =20 up, so it must be related to innodb, perhaps my.cnf and/or mysql itself. the problem is in your my.cnf or the access rights of the person running mysqld. The error means mysqld cannot access the file host.frm in the mysql subdir under the datadir. I suggest specifying the datadir explicitly in your my.cnf. Best regards Nils Valentin Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ Hi Mysql list members, I added a Innodb database to the existing MyISAM databases and now MySQL doesnt start up. From the InnoDB logfile I saw this error message Can't open privilege tables: Table 'mysql.host' doesn't exist Does any body know what this error comes from ? innodb logfile extract. 030603 16:46:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 80 MB InnoDB: Database physically writes the file full: wait... 030603 16:46:31 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 80 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 030603 16:46:48 InnoDB: Started 030603 16:46:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030603 16:46:49 mysqld ended . 030604 09:30:28 mysqld started 030604 9:30:47 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030604 9:30:48 InnoDB: Flushing modified pages from the buffer pool... 030604 9:30:49 InnoDB: Started 030604 9:30:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030604 09:30:49 mysqld ended Any reply much appreciated. -- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =2D-=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
Hi Heikki, Thank you for the reply. I understand that this is related to the host.frm. Thank you very much. The part which I don't get is why would a standard my.cnf file (skipping innodb) start up and the my.cnf file containing the innodb settings give me such an error ? I understood your advice and I am in process of repairing this, however I would really appreciate if I could also technically understand why this is. This case I can learn and step up ;-) Do you mind explaining why this is ? Best regards Nils Valentin 2003 6 4 21:09Heikki Tuuri : Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, June 04, 2003 7:05 AM Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist Sorry, I should have given more details.=20 Its Mysql 4.1 alpha on a Suse Linux system Version 8.1. =2E..and yes, the mysql.host table and the other 5 exist and are well alive= ;-). If I replace my.cnf with a version skipping innodb then it perfectly starts= =20 up, so it must be related to innodb, perhaps my.cnf and/or mysql itself. the problem is in your my.cnf or the access rights of the person running mysqld. The error means mysqld cannot access the file host.frm in the mysql subdir under the datadir. I suggest specifying the datadir explicitly in your my.cnf. Best regards Nils Valentin Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ Hi Mysql list members, I added a Innodb database to the existing MyISAM databases and now MySQL doesnt start up. From the InnoDB logfile I saw this error message Can't open privilege tables: Table 'mysql.host' doesn't exist Does any body know what this error comes from ? innodb logfile extract. 030603 16:46:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 80 MB InnoDB: Database physically writes the file full: wait... 030603 16:46:31 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 80 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 030603 16:46:48 InnoDB: Started 030603 16:46:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030603 16:46:49 mysqld ended . 030604 09:30:28 mysqld started 030604 9:30:47 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030604 9:30:48 InnoDB: Flushing modified pages from the buffer pool... 030604 9:30:49 InnoDB: Started 030604 9:30:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030604 09:30:49 mysqld ended Any reply much appreciated. -- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =2D-=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't open privilege tables: Table 'mysql.host' doesn't exist
Hi Mysql list members, I added a Innodb database to the existing MyISAM databases and now MySQL doesnt start up. From the InnoDB logfile I saw this error message Can't open privilege tables: Table 'mysql.host' doesn't exist Does any body know what this error comes from ? innodb logfile extract. 030603 16:46:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 80 MB InnoDB: Database physically writes the file full: wait... 030603 16:46:31 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 80 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 030603 16:46:48 InnoDB: Started 030603 16:46:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030603 16:46:49 mysqld ended . 030604 09:30:28 mysqld started 030604 9:30:47 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030604 9:30:48 InnoDB: Flushing modified pages from the buffer pool... 030604 9:30:49 InnoDB: Started 030604 9:30:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030604 09:30:49 mysqld ended Any reply much appreciated. -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
Sorry, I should have given more details. Its Mysql 4.1 alpha on a Suse Linux system Version 8.1. ...and yes, the mysql.host table and the other 5 exist and are well alive ;-). If I replace my.cnf with a version skipping innodb then it perfectly starts up, so it must be related to innodb, perhaps my.cnf and/or mysql itself. Best regards Nils Valentin 2003 6 4 12:36Nils Valentin : Hi Mysql list members, I added a Innodb database to the existing MyISAM databases and now MySQL doesnt start up. From the InnoDB logfile I saw this error message Can't open privilege tables: Table 'mysql.host' doesn't exist Does any body know what this error comes from ? innodb logfile extract. 030603 16:46:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 80 MB InnoDB: Database physically writes the file full: wait... 030603 16:46:31 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 80 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 030603 16:46:48 InnoDB: Started 030603 16:46:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030603 16:46:49 mysqld ended . 030604 09:30:28 mysqld started 030604 9:30:47 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030604 9:30:48 InnoDB: Flushing modified pages from the buffer pool... 030604 9:30:49 InnoDB: Started 030604 9:30:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030604 09:30:49 mysqld ended Any reply much appreciated. -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, June 04, 2003 7:05 AM Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist Sorry, I should have given more details.=20 Its Mysql 4.1 alpha on a Suse Linux system Version 8.1. =2E..and yes, the mysql.host table and the other 5 exist and are well alive= ;-). If I replace my.cnf with a version skipping innodb then it perfectly starts= =20 up, so it must be related to innodb, perhaps my.cnf and/or mysql itself. the problem is in your my.cnf or the access rights of the person running mysqld. The error means mysqld cannot access the file host.frm in the mysql subdir under the datadir. I suggest specifying the datadir explicitly in your my.cnf. Best regards Nils Valentin Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ Hi Mysql list members, I added a Innodb database to the existing MyISAM databases and now MySQL doesnt start up. From the InnoDB logfile I saw this error message Can't open privilege tables: Table 'mysql.host' doesn't exist Does any body know what this error comes from ? innodb logfile extract. 030603 16:46:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 80 MB InnoDB: Database physically writes the file full: wait... 030603 16:46:31 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 80 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 030603 16:46:48 InnoDB: Started 030603 16:46:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030603 16:46:49 mysqld ended . 030604 09:30:28 mysqld started 030604 9:30:47 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030604 9:30:48 InnoDB: Flushing modified pages from the buffer pool... 030604 9:30:49 InnoDB: Started 030604 9:30:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030604 09:30:49 mysqld ended Any reply much appreciated. -- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =2D-=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
