RE: Startup Error
Richard, In my instructions, the chowns are as follows: shell> chown -R root /usr/local/mysql/. shell> chown -R mysql /usr/local/mysql/data shell> chgrp -R mysql /usr/local/mysql/. Note no slash after data. However, you have world read and write on the data folder anyway The mysql folder is a link into /root/mysql-max-4.1.14-pc-linux-gnu-i686 My guess is that the tomcat user can't create a file in /root/ mysql-max-4.1.14-pc-linux-gnu-i686/data What do you get if you do: ls -l /root/mysql-max-4.1.14-pc-linux-gnu-i686 Can tomcat write into this? Andy _ From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: 20 September 2005 12:00 To: 'Andy Eastham' Subject: RE: Startup Error [EMAIL PROTECTED] mysql]# ls -l /usr/local/mysql lrwxrwxrwx1 root root 40 Sep 19 09:00 /usr/local/mysql -> /root/mysql-max-4.1.14-pc-linux-gnu-i686 Richard Johnson 212-589-6503 [EMAIL PROTECTED] -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 4:58 AM To: Johnson, Richard (NY Int) Subject: RE: Startup Error Richard, What output do you get from: ls -l /usr/local/mysql Andy > -Original Message- > From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] > Sent: 19 September 2005 19:57 > To: 'mysql@lists.mysql.com' > Subject: RE: Startup Error > > Still getting the following errors after running the chown's below... > > Here is what the ls -l result window shows... > > mysql]# ls -l /usr/local/mysql/data > total 20536 > -rw-rw1 mysqlmysql10485760 Sep 19 > 10:05 ibdata1 > -rw-rw1 mysqlmysql 5242880 Sep 19 > 10:05 ib_logfile0 > -rw-rw1 mysqlmysql 5242880 Sep 19 > 09:33 ib_logfile1 > drwxr-x---2 mysqlmysql4096 Sep 19 > 09:30 mysql > > The error log shows.. > > 050919 14:44:36 mysqld started > 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data: > Permission denied > 050919 14:44:36 [ERROR] bdb: > /usr/local/mysql/data/log.01: Permission denied > 050919 14:44:36 [ERROR] bdb: PANIC: Permission denied > 050919 14:44:36 [ERROR] bdb: PANIC: DB_RUNRECOVERY: > Fatal error, run database recovery > 050919 14:44:36 [ERROR] bdb: fatal region error detected; run recovery > 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data: > Permission denied > 050919 14:44:36 InnoDB: Started; log sequence number 0 43634 > 050919 14:44:36 [ERROR] Can't init databases > 050919 14:44:36 [ERROR] Aborting > > 050919 14:44:36 InnoDB: Starting shutdown... > 050919 14:44:38 InnoDB: Shutdown completed; log sequence number 0 43634 > 050919 14:44:38 [Note] /usr/local/mysql/bin/mysqld: > Shutdown complete > > 050919 14:44:38 mysqld ended > > Richard Johnson > 212-589-6503 > [EMAIL PROTECTED] > > -Original Message- > From: J.R. Bullington [mailto:[EMAIL PROTECTED] > Sent: Monday, September 19, 2005 11:49 AM > To: mysql@lists.mysql.com > Subject: RE: Startup Error > > Well, as you can see in the first few lines, you have a Permission Denied > problem. > > This means that your /data/ folder doesn't have the write permissions to > it > via the mysql user. > > Try running the permission scripts again, but this time use the full shell > names. > > shell> chown -R root /usr/local/mysql/. > shell> chown -R mysql /usr/local/mysql/data/. > shell> chgrp -R mysql /usr/local/mysql/. > > Then check to make sure that user has write permission to the folders: > > shell> ls -l /usr/local/mysql/data > > It should say something similar to: > > shell> ls -l /usr/local/mysql/data > total 63868 > drwx--2mysqlmysql > -rw-rw----1mysqlmysql- > bin.000 > . > . > -rw-rw1mysqlmysql.err > > > > J.R. > > > _ > > From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] > Sent: Monday, September 19, 2005 11:35 AM > To: 'J.R. Bullington' > Subject: RE: Startup Error > > > > Here are the contents of the file > > 050919 09:33:52 mysqld started > 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied > 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data/log.01: > Permission denied > 050919 9:33:52 [ERROR] bdb: PANIC: Permission denied > 050919 9:33:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run > database recovery > 050919 9:33:52 [ERROR] bdb: fatal region error detected; run recovery > 050919 9:33:5
RE: Startup Error
Still getting the following errors after running the chown's below... Here is what the ls -l result window shows... mysql]# ls -l /usr/local/mysql/data total 20536 -rw-rw1 mysqlmysql10485760 Sep 19 10:05 ibdata1 -rw-rw1 mysqlmysql 5242880 Sep 19 10:05 ib_logfile0 -rw-rw1 mysqlmysql 5242880 Sep 19 09:33 ib_logfile1 drwxr-x---2 mysqlmysql4096 Sep 19 09:30 mysql The error log shows.. 050919 14:44:36 mysqld started 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 14:44:36 [ERROR] bdb: PANIC: Permission denied 050919 14:44:36 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 14:44:36 [ERROR] bdb: fatal region error detected; run recovery 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 14:44:36 InnoDB: Started; log sequence number 0 43634 050919 14:44:36 [ERROR] Can't init databases 050919 14:44:36 [ERROR] Aborting 050919 14:44:36 InnoDB: Starting shutdown... 050919 14:44:38 InnoDB: Shutdown completed; log sequence number 0 43634 050919 14:44:38 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 14:44:38 mysqld ended Richard Johnson 212-589-6503 [EMAIL PROTECTED] -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 11:49 AM To: mysql@lists.mysql.com Subject: RE: Startup Error Well, as you can see in the first few lines, you have a Permission Denied problem. This means that your /data/ folder doesn't have the write permissions to it via the mysql user. Try running the permission scripts again, but this time use the full shell names. shell> chown -R root /usr/local/mysql/. shell> chown -R mysql /usr/local/mysql/data/. shell> chgrp -R mysql /usr/local/mysql/. Then check to make sure that user has write permission to the folders: shell> ls -l /usr/local/mysql/data It should say something similar to: shell> ls -l /usr/local/mysql/data total 63868 drwx--2mysqlmysql -rw-rw1mysqlmysql-bin.000 . . -rw-rw1mysqlmysql.err J.R. _ From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 11:35 AM To: 'J.R. Bullington' Subject: RE: Startup Error Here are the contents of the file 050919 09:33:52 mysqld started 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:33:52 [ERROR] bdb: fatal region error detected; run recovery 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050919 9:33:52 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050919 9:33:53 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... 050919 9:33:53 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 050919 9:33:53 InnoDB: Started; log sequence number 0 0 050919 9:33:53 [ERROR] Can't init databases 050919 9:33:53 [ERROR] Aborting 050919 9:33:53 InnoDB: Starting shutdown... 050919 9:33:55 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:33:55 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 09:33:55 mysqld ended 050919 09:46:55 mysqld started 050919 9:46:55 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:46:56 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:46:56 [ERROR] bdb: PANIC: Permission denied 050919 9:46:56 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:46:56 [ERROR] bdb: fatal region error detected; run recovery 050919 9:46:56 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:46:56 InnoDB: Started; log sequence number 0 43634 050919 9:46:56 [ERROR] Can't init databases 050919 9:46:56 [ERROR] Aborting 050919 9:46:56 InnoDB: Starting shutdown... 050919 9:46:58 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:46:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
RE: Startup Error
Well, as you can see in the first few lines, you have a Permission Denied problem. This means that your /data/ folder doesn't have the write permissions to it via the mysql user. Try running the permission scripts again, but this time use the full shell names. shell> chown -R root /usr/local/mysql/. shell> chown -R mysql /usr/local/mysql/data/. shell> chgrp -R mysql /usr/local/mysql/. Then check to make sure that user has write permission to the folders: shell> ls -l /usr/local/mysql/data It should say something similar to: shell> ls -l /usr/local/mysql/data total 63868 drwx--2mysqlmysql -rw-rw1mysqlmysql-bin.000 . . -rw-rw1mysqlmysql.err J.R. _ From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 11:35 AM To: 'J.R. Bullington' Subject: RE: Startup Error Here are the contents of the file 050919 09:33:52 mysqld started 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:33:52 [ERROR] bdb: fatal region error detected; run recovery 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050919 9:33:52 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050919 9:33:53 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... 050919 9:33:53 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 050919 9:33:53 InnoDB: Started; log sequence number 0 0 050919 9:33:53 [ERROR] Can't init databases 050919 9:33:53 [ERROR] Aborting 050919 9:33:53 InnoDB: Starting shutdown... 050919 9:33:55 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:33:55 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 09:33:55 mysqld ended 050919 09:46:55 mysqld started 050919 9:46:55 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:46:56 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:46:56 [ERROR] bdb: PANIC: Permission denied 050919 9:46:56 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:46:56 [ERROR] bdb: fatal region error detected; run recovery 050919 9:46:56 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:46:56 InnoDB: Started; log sequence number 0 43634 050919 9:46:56 [ERROR] Can't init databases 050919 9:46:56 [ERROR] Aborting 050919 9:46:56 InnoDB: Starting shutdown... 050919 9:46:58 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:46:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 09:46:58 mysqld ended 050919 09:56:10 mysqld started 050919 9:56:10 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:56:10 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:56:10 [ERROR] bdb: PANIC: Permission denied 050919 9:56:10 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:56:10 [ERROR] bdb: fatal region error detected; run recovery 050919 9:56:10 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:56:10 InnoDB: Started; log sequence number 0 43634 050919 9:56:10 [ERROR] Can't init databases 050919 9:56:10 [ERROR] Aborting 050919 9:56:10 InnoDB: Starting shutdown... 050919 9:56:12 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:56:12 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 09:56:12 mysqld ended 050919 10:05:33 mysqld started 050919 10:05:34 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 10:05:34 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 10:05:34 [ERROR] bdb: PANIC: Permission denied 050919 10:05:34 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 10:05:34 [ERROR] bdb: fatal region error detected; run recovery 050919 10:05:34 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 10:05:34 InnoDB: Started; log sequence number 0 43634 050919 10:05:34 [ERROR] Can't init databases 050919 10:05:34 [ERROR] Abo
Re: Startup Error
Johnson, Richard (NY Int) wrote: Hi there Total Newbie here.Any idea why I am getting these error messages [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/ RJLINUX.rj.johnson.net.pid 050919 10:05:36 mysqld ended Here are the steps I followed to loading mysql onto my linux box.. 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 & Richard Johnson There should be an error log (hostname.err) in your data directory (/usr/local/mysql/data/). What does it say? Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Startup Error
Check your <>.err logs located in the /data/ directory. This will tell you why you can't start the server. J.R. -Original Message- From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 10:38 AM To: 'mysql@lists.mysql.com' Subject: Startup Error Hi there Total Newbie here.Any idea why I am getting these error messages [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/ RJLINUX.rj.johnson.net.pid 050919 10:05:36 mysqld ended Here are the steps I followed to loading mysql onto my linux box.. 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 & Richard Johnson 212-589-6503 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Startup Error
Hi there Total Newbie here.Any idea why I am getting these error messages [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/ RJLINUX.rj.johnson.net.pid 050919 10:05:36 mysqld ended Here are the steps I followed to loading mysql onto my linux box.. 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 & Richard Johnson 212-589-6503 [EMAIL PROTECTED]
RE: multiple server versions on 1 box startup error#
Have you set it up so that these instances run on different ports and different sockets? If you are not using mysqld multi you will have to specify which mysql/bin/safe_mysqld you want to start on the command line. -Original Message- From: sean c peters To: [EMAIL PROTECTED] Sent: 8/12/04 5:33 PM Subject: multiple server versions on 1 box startup error# I am trying to run two different MySQL server versions on the same solaris machine. I already have a 4.0.2 running, and i have successfully installed 4.1.3 beta. I ran mysql_install_db successfully (after setting LD_LIBRARY_PATH), but when i try to run >mysqld_safe --user=mysql & I get the error: A mysqld process already exists [1]+ Exit 1 ./mysqld_safe --user=mysql This is certainly true, because my 4.0.2 is running, but i dont understand why this is a problem. I am running the mysqld_safe for version 4.1.3, and when i built 4.1.3 i used the configure options: (among others) --prefix=/usr/loca/mysql-4.1.3 --with-tcp-port=3306 --with-unix-socket-path=/tmp/mysql-4.1.3.sock --datadir=/var/mysql-4.1.3 And these options are all different from the 4.0.2 configuration. So i assumed that things would run ok. The only thing i can think of is that the /vaar/mysql-4.1.3/my.cnf is not being read correctly. Perhaps i have an error in it, but i'd think that mysqld_safe would let me know. If its not being read, then some options from my default /etc/my.cnf are not being overridden, and that could be the problem. Here is the info on the /var/mysql-4.1.3/my.cnf file: -rw-r--r-- 1 root other 2042 Aug 12 18:08 my.cnf and the permissions & ownership are identical to that for /etc/my.cnf I am at a loss thanks much. sean peters [EMAIL PROTECTED] -- 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]
RE: multiple server versions on 1 box startup error#
Hi Sean, Have you checked the pid file? Have you given it a unique path for this server? Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: sean c peters [mailto:[EMAIL PROTECTED] Sent: Friday, 13 August 2004 8:03 AM To: [EMAIL PROTECTED] Subject: multiple server versions on 1 box startup error# I am trying to run two different MySQL server versions on the same solaris machine. I already have a 4.0.2 running, and i have successfully installed 4.1.3 beta. I ran mysql_install_db successfully (after setting LD_LIBRARY_PATH), but when i try to run >mysqld_safe --user=mysql & I get the error: A mysqld process already exists [1]+ Exit 1 ./mysqld_safe --user=mysql This is certainly true, because my 4.0.2 is running, but i dont understand why this is a problem. I am running the mysqld_safe for version 4.1.3, and when i built 4.1.3 i used the configure options: (among others) --prefix=/usr/loca/mysql-4.1.3 --with-tcp-port=3306 --with-unix-socket-path=/tmp/mysql-4.1.3.sock --datadir=/var/mysql-4.1.3 And these options are all different from the 4.0.2 configuration. So i assumed that things would run ok. The only thing i can think of is that the /vaar/mysql-4.1.3/my.cnf is not being read correctly. Perhaps i have an error in it, but i'd think that mysqld_safe would let me know. If its not being read, then some options from my default /etc/my.cnf are not being overridden, and that could be the problem. Here is the info on the /var/mysql-4.1.3/my.cnf file: -rw-r--r-- 1 root other 2042 Aug 12 18:08 my.cnf and the permissions & ownership are identical to that for /etc/my.cnf I am at a loss thanks much. sean peters [EMAIL PROTECTED] -- 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]
multiple server versions on 1 box startup error#
I am trying to run two different MySQL server versions on the same solaris machine. I already have a 4.0.2 running, and i have successfully installed 4.1.3 beta. I ran mysql_install_db successfully (after setting LD_LIBRARY_PATH), but when i try to run >mysqld_safe --user=mysql & I get the error: A mysqld process already exists [1]+ Exit 1 ./mysqld_safe --user=mysql This is certainly true, because my 4.0.2 is running, but i dont understand why this is a problem. I am running the mysqld_safe for version 4.1.3, and when i built 4.1.3 i used the configure options: (among others) --prefix=/usr/loca/mysql-4.1.3 --with-tcp-port=3306 --with-unix-socket-path=/tmp/mysql-4.1.3.sock --datadir=/var/mysql-4.1.3 And these options are all different from the 4.0.2 configuration. So i assumed that things would run ok. The only thing i can think of is that the /vaar/mysql-4.1.3/my.cnf is not being read correctly. Perhaps i have an error in it, but i'd think that mysqld_safe would let me know. If its not being read, then some options from my default /etc/my.cnf are not being overridden, and that could be the problem. Here is the info on the /var/mysql-4.1.3/my.cnf file: -rw-r--r-- 1 root other 2042 Aug 12 18:08 my.cnf and the permissions & ownership are identical to that for /etc/my.cnf I am at a loss thanks much. sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql-administrator startup error
I just installed the administrator alpha binaries on my Sun Java Desktop system (SuSe 8 Linux), and I get the following error at startu: ./mysql-administrator-bin: error while loading shared libraries: libsigc-1.2.so.5: cannot open shared object file: No such file or directory I did a find from root and did not locate any file closely resembling the name 'libsigc*'. Does this mean I should download and build the source? TIA. = Thanks. Kevin -- Enjoy Life, Drink and Code Java! __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb firsttime startup error
"Kev" <[EMAIL PROTECTED]> wrote: > I just ran mysql 4.0.15 on a Mac for the first time and got the following in > my .err file: > > > > InnoDB: a new database to be created! > 040128 7:40:24 InnoDB: Setting file ./ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > 040128 7:40:25 InnoDB: Log file ./ib_logfile0 did not exist: new to be > created > InnoDB: Setting log file ./ib_logfile0 size to 20 MB > InnoDB: Database physically writes the file full: wait... > 040128 7:40:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be > created > InnoDB: Setting log file ./ib_logfile1 size to 20 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 > 040128 7:41:08 InnoDB: Started > 040128 7:41:08 Fatal error: Can't open privilege tables: Table > 'mysql.host' doesn't exist > 040128 7:41:08 Aborting > > 040128 7:41:08 InnoDB: Starting shutdown... > 040128 7:41:11 InnoDB: Shutdown completed > 040128 7:41:11 /Library/MySQL/libexec/mysqld: Shutdown Complete > > 040128 07:41:11 mysqld ended This error isn't related to the InnoDB. It means that you doesn't have privilege tables or MySQL doesn't have permission on the data dir. Check if privilege table files exist in the directory of the database mysql. If so, check permissions on the files and data dir. If files don't exist, you should run mysql_install_db script to install grant tables. How do I create the mysql.host file and where should it be located? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
Innodb firsttime startup error
I just ran mysql 4.0.15 on a Mac for the first time and got the following in my .err file: InnoDB: a new database to be created! 040128 7:40:24 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 040128 7:40:25 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 20 MB InnoDB: Database physically writes the file full: wait... 040128 7:40:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 20 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 040128 7:41:08 InnoDB: Started 040128 7:41:08 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040128 7:41:08 Aborting 040128 7:41:08 InnoDB: Starting shutdown... 040128 7:41:11 InnoDB: Shutdown completed 040128 7:41:11 /Library/MySQL/libexec/mysqld: Shutdown Complete 040128 07:41:11 mysqld ended How do I create the mysql.host file and where should it be located?
Re: Startup error on 4.0.15
Try commenting out the entry in the file /Library/MySQL/var/my.cnf If it does not exist, copy one of the files from /Library/MySQL/dist/my-small,medium,large.cnf renamed to the above location, or, to /etc/my.cnf Though, you may want to try uninstalling the package and reinstalling it again, just to be sure, as that'innodb_buffer_pool_size = 70M' entry seems valid. -- Adam Goldstein White Wolf Networks http://whitewlf.net On Jan 26, 2004, at 9:07 PM, Kev wrote: I just installed the server logistics package of mysql 4.0.15 and am getting the following error entry in the error log on attempting to start the server: 040126 20:43:45 mysqld started /Library/MySQL/libexec/mysqld: ERROR: unknown variable 'innodb_buffer_pool_size = 70M' 040126 20:43:45 mysqld ended The directory referenced in the error message only contains the mysqld file: Kevins-Computer:/Library/MySQL/libexec kevinbarry$ ls mysqld Kevins-Computer:/Library/MySQL/libexec kevinbarry$ where is the innodb file reference being picked up? What am I missing? There is not config file in the error directory, is that the problem? I upgraded from 3.0.x to 4.0.17 on Linux over the weekend and the install went easier than it has thus far on Mac OS X!!! go figure. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Startup error on 4.0.15
I just installed the server logistics package of mysql 4.0.15 and am getting the following error entry in the error log on attempting to start the server: 040126 20:43:45 mysqld started /Library/MySQL/libexec/mysqld: ERROR: unknown variable 'innodb_buffer_pool_size = 70M' 040126 20:43:45 mysqld ended The directory referenced in the error message only contains the mysqld file: Kevins-Computer:/Library/MySQL/libexec kevinbarry$ ls mysqld Kevins-Computer:/Library/MySQL/libexec kevinbarry$ where is the innodb file reference being picked up? What am I missing? There is not config file in the error directory, is that the problem? I upgraded from 3.0.x to 4.0.17 on Linux over the weekend and the install went easier than it has thus far on Mac OS X!!! go figure.
Re: re: startup error
Hello Maximo, Wednesday, October 16, 2002, 8:05:23 PM, you wrote: MM> nscd?? nscd - A Name Service Caching Daemon It's a DNS-something for glibc.. MM> I searched for that program and did not find it in linux. MM> How would you go about fixing that problem? It will be fixed in 3.23.53a that will come ASAP MM> Could you give us a more detailed explanation? >>Run nscd and then run MySQL server. >> >>3.23.53 was built with another glibc that has no nss staticlly linked >>in. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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: startup error
Zack, Wednesday, October 16, 2002, 5:56:11 PM, you wrote: ZWK> I followed the directions in the Mysql documentation, but I can't get it ZWK> to fire up properly. I dl the binary distribution ZWK> mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz ZWK> Mysql 3.23.53 ZWK> Redhat 8.0 ZWK> When I start it from safe_mysqld I get in the .err log ZWK> Fatal error: 'Can't change to run as user 'mysql'; Please check that the ZWK> user exists! ZWK> The mysql user does exist :-) ZWK> How do I fix this please? Run nscd and then run MySQL server. 3.23.53 was built with another glibc that has no nss staticlly linked in. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
startup error
I followed the directions in the Mysql documentation, but I can't get it to fire up properly. I dl the binary distribution mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz Mysql 3.23.53 Redhat 8.0 When I start it from safe_mysqld I get in the .err log Fatal error: 'Can't change to run as user 'mysql'; Please check that the user exists! The mysql user does exist :-) How do I fix this please? Zack - 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: MySQL startup error
Neville, Monday, June 03, 2002, 1:44:25 PM, you wrote: NL> This is the error message that I get NL> NL> Can't connect to local MySQL server through socket NL> '/var/lib/mysql/mysql.sock' (2) NL> NL> Could ayone please show me how to sort this out NL> I had MySQL running before this. This has happened NL> all of a sudden. perror 2 Error code 2: No such file or directory If you MySQL server is running, it may happen because 1. you don't have permissions on that file/dir 2. your socket file is located in other place - check where mysql.sock is located and specify path to the socket with --socket option. 3. Somebody deleted socket file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
MySQL startup error
This is the error message that I get Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could ayone please show me how to sort this out I had MySQL running before this. This has happened all of a sudden. - 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: Server startup error on Linux
Rance, Saturday, March 23, 2002, 1:27:37 AM, you wrote: RH> Egor: RH> Yes, im sure that the host.xxx tables are in the directory I specified to RH> the mysql_install_db script. RH> One thing to note.. RH> This is a software package for my distro... I did not compile from source so RH> I dont know what options were used in the compile process. RH> It may be that the server is unable to look in the dir where the files RH> are... if this is the case then this would explain why the server cant find RH> the host.xxx databases. RH> I have tried to run safe_mysqld --datadir=/path/to/data RH> but that doesnt help RH> Do you think I should just uninstall the package, and download the sources RH> and start over? RH> Im at the end of my rope with this, Its just dumb to me that the server cant RH> find something that I can find, even after I tell it where to look. RH> There must be something more wrong that just a simple chown command, or file RH> permissions or something like that. Rance, it's best to uninstall your MySQL server and install from scratch the binary package from http://www.mysql.com. RH> Thoughts? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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: Server startup error on Linux
Egor: Yes, im sure that the host.xxx tables are in the directory I specified to the mysql_install_db script. One thing to note.. This is a software package for my distro... I did not compile from source so I dont know what options were used in the compile process. It may be that the server is unable to look in the dir where the files are... if this is the case then this would explain why the server cant find the host.xxx databases. I have tried to run safe_mysqld --datadir=/path/to/data but that doesnt help Do you think I should just uninstall the package, and download the sources and start over? Im at the end of my rope with this, Its just dumb to me that the server cant find something that I can find, even after I tell it where to look. There must be something more wrong that just a simple chown command, or file permissions or something like that. Just my opinion. Thoughts? >From: Egor Egorov <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Server startup error on Linux >Date: Fri, 22 Mar 2002 20:32:00 +0200 > >Rance, >Friday, March 22, 2002, 4:53:41 PM, you wrote: > >RH> here goes (not that it will give you any better information than I did >RH> already but since you asked...) > >RH> <<>> >RH> 020318 14:30:48 mysqld started >RH> 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't >exist >RH> 020318 14:30:49 mysqld ended >RH> <<>> > >RH> because I have about 18 similar blocks in my .err file for each time I >tried >RH> to start the server to see if I fixed the problem coping the entire >.err >RH> file didnt make any sense. > >RH> Again, this is after running the mysql_install_db and verifing that >RH> permissions to the files created by mysql_install_db are correct. > >RH> --skip-grant-tables will allow the server to start, but a normal start >is >RH> impossible > >Rance, are you sure that table 'host' really exists? >Take a look at mysql datadir if there are the grant tables like >'host.frm', 'host.MYD', 'host.MYI'. > >RH> Rance _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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: Server startup error on Linux
Rance, Friday, March 22, 2002, 4:53:41 PM, you wrote: RH> here goes (not that it will give you any better information than I did RH> already but since you asked...) RH> <<>> RH> 020318 14:30:48 mysqld started RH> 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist RH> 020318 14:30:49 mysqld ended RH> <<>> RH> because I have about 18 similar blocks in my .err file for each time I tried RH> to start the server to see if I fixed the problem coping the entire .err RH> file didnt make any sense. RH> Again, this is after running the mysql_install_db and verifing that RH> permissions to the files created by mysql_install_db are correct. RH> --skip-grant-tables will allow the server to start, but a normal start is RH> impossible Rance, are you sure that table 'host' really exists? Take a look at mysql datadir if there are the grant tables like 'host.frm', 'host.MYD', 'host.MYI'. RH> Rance -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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: Server startup error on Linux
Ok Egor, here goes (not that it will give you any better information than I did already but since you asked...) <<>> 020318 14:30:48 mysqld started 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 020318 14:30:49 mysqld ended <<>> because I have about 18 similar blocks in my .err file for each time I tried to start the server to see if I fixed the problem coping the entire .err file didnt make any sense. Again, this is after running the mysql_install_db and verifing that permissions to the files created by mysql_install_db are correct. --skip-grant-tables will allow the server to start, but a normal start is impossible Rance >From: Egor Egorov <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Server startup error on Linux >Date: Fri, 22 Mar 2002 15:38:03 +0200 > >Rance, >Thursday, March 21, 2002, 9:30:26 PM, you wrote: > >RH> I issued the chown command as indicated by Andreas >RH> but it doesnt help >RH> I still get the "Table mysql.hosts doesnt exist" > >RH> I know that all the tables created by mysql_install_db are infact owned >by >RH> mysql >RH> but the server daemon still cant find them > >Give me complete output of the error message - show us the >contents of the .err file > >RH> what next? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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: Server startup error on Linux
Rance, Thursday, March 21, 2002, 9:30:26 PM, you wrote: RH> I issued the chown command as indicated by Andreas RH> but it doesnt help RH> I still get the "Table mysql.hosts doesnt exist" RH> I know that all the tables created by mysql_install_db are infact owned by RH> mysql RH> but the server daemon still cant find them Give me complete output of the error message - show us the contents of the .err file RH> what next? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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: Server startup error on Linux
I issued the chown command as indicated by Andreas but it doesnt help I still get the "Table mysql.hosts doesnt exist" I know that all the tables created by mysql_install_db are infact owned by mysql but the server daemon still cant find them what next? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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: server startup error on linux
> I assume that the mysql daemon is looking for one of those > owned by mysql. > > The server will start if I send the --skip-grant-tables option > > Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there and type: chown -Rf mysql:mysql * to change ownership of databases and tables. Note that mysql:mysql is user:group and if the mysql-user and/or group is different from 'mysql' you should change it. :wq //andreas http://phpwizard.dk (in Danish only) sql, query - 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: server startup error on linux
> I assume that the mysql daemon is looking for one of those > owned by mysql. > > The server will start if I send the --skip-grant-tables option > > Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there and type: chown -Rf mysql:mysql * to change ownership of databases and tables. Note that mysql:mysql is user:group and if the mysql-user and/or group is different from 'mysql' you should change it. :wq //andreas http://phpwizard.dk (in Danish only) - 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: server startup error
The group is not really important, as long as mysql owns the data directory and its contents. You can check /etc/group and see if you have a mysql group, or a group to which mysql is a member. Rance Hall wrote: > Folks: > > I think you are on the right track with that Gerald.. > > I deleted all the files in my data directory (they were just the ones > that mysql_install_db creates) and then ran mysql_install_db --user=mysql > > This time, nothing was created, no files, or anything, cant even find > an error message that would say why. > > So since I know that the server is running under safe_mysqld > --user=mysql it couldnt find the files cause under that account name > apparently they dont exist. > > The mysql user is part of what group, so I can chown the dir, and > start again? > > > Gerald Clark wrote > >> Does mysql own the mysql database directory, and all its files? >> >> You should have run it as >> mysql_install_db --user=mysql >> >> Rance Hall wrote: >> >>> >>> Hello all >>> >>> I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at >>> that computer now, so that could be wrong slighly) install pkg >>> >>> I have installed it, and I can get it to run with the >>> --skip-grant-tables option. >>> >>> When I try to run safe_mysqld without the skip option I get the >>> following error: Table 'mysql.host' doesn't exist >>> >>> Now, I ran the mysql_install_db script and it made a bunch of >>> databases including two called host.xxx >>> >>> Question, what is the proper syntax for a creation of the mysql.host >>> table so that I can create it and get past this error. >>> >>> If anyone else has any experience with this, could this be a bug in >>> the install_db script? >>> >>> Thanks for all your help >>> >>> Rance >> > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > - 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
server startup error on linux
Ok, I guess Im gonna have to do this again I have a Slackware 8.0 distro with the apache, php, and mysql install pkgs off of the cd I am logged in as root (not su'ed to root) and run the mysql_install_db script I run it with or without the --user=mysql qualifier in either case the databases are corrected, and the file permissions and ownership show that root owns all the database files with read and write access to the owner and the group. running safe_mysqld with or without the --user=mysql qualifier results in the same error "Table mysql.host doesnt exist" There are two tables created by the mysql_install_db script that are called host.xxx I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Help. Rance _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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: server startup error
Folks: I think you are on the right track with that Gerald.. I deleted all the files in my data directory (they were just the ones that mysql_install_db creates) and then ran mysql_install_db --user=mysql This time, nothing was created, no files, or anything, cant even find an error message that would say why. So since I know that the server is running under safe_mysqld --user=mysql it couldnt find the files cause under that account name apparently they dont exist. The mysql user is part of what group, so I can chown the dir, and start again? Gerald Clark wrote >Does mysql own the mysql database directory, and all its files? > >You should have run it as >mysql_install_db --user=mysql > >Rance Hall wrote: > >> >>Hello all >> >>I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at >>that computer now, so that could be wrong slighly) install pkg >> >>I have installed it, and I can get it to run with the >>--skip-grant-tables option. >> >>When I try to run safe_mysqld without the skip option I get the >>following error: Table 'mysql.host' doesn't exist >> >>Now, I ran the mysql_install_db script and it made a bunch of >>databases including two called host.xxx >> >>Question, what is the proper syntax for a creation of the mysql.host >>table so that I can create it and get past this error. >> >>If anyone else has any experience with this, could this be a bug in >>the install_db script? >> >>Thanks for all your help >> >>Rance _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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: server startup error
Does mysql own the mysql database directory, and all its files? You should have run it as mysql_install_db --user=mysql Rance Hall wrote: > > Hello all > > I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at > that computer now, so that could be wrong slighly) install pkg > > I have installed it, and I can get it to run with the > --skip-grant-tables option. > > When I try to run safe_mysqld without the skip option I get the > following error: Table 'mysql.host' doesn't exist > > Now, I ran the mysql_install_db script and it made a bunch of > databases including two called host.xxx > > Question, what is the proper syntax for a creation of the mysql.host > table so that I can create it and get past this error. > > If anyone else has any experience with this, could this be a bug in > the install_db script? > > Thanks for all your help > > Rance > > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > > - > 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
server startup error
Hello all I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at that computer now, so that could be wrong slighly) install pkg I have installed it, and I can get it to run with the --skip-grant-tables option. When I try to run safe_mysqld without the skip option I get the following error: Table 'mysql.host' doesn't exist Now, I ran the mysql_install_db script and it made a bunch of databases including two called host.xxx Question, what is the proper syntax for a creation of the mysql.host table so that I can create it and get past this error. If anyone else has any experience with this, could this be a bug in the install_db script? Thanks for all your help Rance _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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
startup error
I just installed mysql-3.23.43-sun-solaris2.7-sparc, but I can not get it to start up. Here's the error I'm getting: >./bin/safe_mysqld --log --log-update & Starting mysqld daemon with databases from /koz/mysql-3.23.43-sun-solaris2.7-sparc/data ./bin/safe_mysqld: /koz/mysql-3.23.43-sun-solaris2.7-sparc/data/devnfs.err: cannot create Any help you could give me would be great! Thanks, Cstyle - 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
