Re: Connecting MySQL in Panther
chueewowee wrote: [raisinspace:/usr/local/mysql] chueewow% Starting mysqld daemon with databases from /usr/local/mysql/data 040612 23:32:05 mysqld ended mysqld isn't starting. See what the error log says, it will likely be in /usr/local/mysql/data --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connecting MySQL in Panther
Hello, I'm new to the list and need help of course. My problems are in connecting to MySQL. I am running Panther 10.38. , MySQL 4.018. I have removed all old files before reinstalling MySQL. I have installed the MySQL Startup Item and it is correctly located. Output from the Terminal is as follows: [raisinspace:~] chueewow% sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server [raisinspace:~] chueewow% /usr/local/mysql/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [raisinspace:~] chueewow% sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server [raisinspace:~] chueewow% cd /usr/local/mysql [raisinspace:/usr/local/mysql] chueewow% sudo ./bin/mysqld_safe [1] 2966 [raisinspace:/usr/local/mysql] chueewow% Starting mysqld daemon with databases from /usr/local/mysql/data 040612 23:32:05 mysqld ended Also, from my HTML browser (SAfari) when : Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /Users/chueewowee/Sites/index.php on line 21 Warning: mysql_select_db(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /Users/chueewowee/Sites/index.php on line 25 Warning: mysql_select_db(): A link to the server could not be established in /Users/chueewowee/Sites/index.php on line 25 Warning: mysql_create_db(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /Users/chueewowee/Sites/index.php on line 29 Warning: mysql_create_db(): A link to the server could not be established in /Users/chueewowee/Sites/index.php on line 29 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Warning: mysql_select_db(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /Users/chueewowee/Sites/index.php on line 37 Warning: mysql_select_db(): A link to the server could not be established in /Users/chueewowee/Sites/index.php on line 37 Can't Select CONTACT Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /Users/chueewowee/Sites/index.php on line 43 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I have sought and tried all kinds of advice. But either it is not clear or working for me. JP JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Uninstall MySQL for Panther?
At 21:31 -0800 3/12/04, John Mistler wrote: First I want to thank all of you guys for responding. I feel a new sense of confidence that I will be able to get this thing going! However, my problems have compounded. We now have a new problem. I took the advice of one archived postings and dragged the four files seemingly installed by the mysql package at the location (in Mac language) users:johnmistler:the four files to the trash. That didn't feel right to me once I did it, so I dragged them back. They were named: 1. cd 2. md5 3. md5 sum 4. mysql Now, when I go to the terminal and type: /usr/local/mysql/bin/mysql I get: tcsh: /usr/local/mysql/bin/mysql: Command not found This suggests to me that the mysql file it is being directed to is not there. However, I can verify that the file mysql exists at this path (in Mac Language): users:johnmistler:mysql It is listed as a document with Zero KB for its size (?). It definitely is one of the files that I dragged back from the trash. Should I attempt to fix all of this, or go ahead with an uninstall? Well, it's maybe a little risky to go ahead and trash all that stuff, but I'd guess that's what you want to do. If the mysql program isn't found as a command (as shown above), it's not doing you any good. You might try this command to see what kind of thing it actually is now: file /usr/local/mysql/bin/mysql If I do need to uninstall, how do I do it? I installed the latest PACKAGE from the MySQL.com site 4.0.18-standard along with the startup item package. Use the rm commands that Scott Haneda suggested in his message. Then reinstall. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Uninstall MySQL for Panther?
I am two days into troubleshooting this. I need some help badly. I installed MySQL 4.0.18 for Mac. I was able to get in at first: Welcome to MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 to server version: 4.0.18-standard then I would type mysql create database mytest; and get: ERROR 1044: Access denied for user: '@localhost' to database 'mytest' I tried all kinds of commands to change the root password, and every single one would result in Access denied for user . . . I would like to install, instead, CompleteMySQL from the serverlogisitics.com site, which has interfaces to help newbies like me. However, it is only at version 4.0.15. So my question is: How can I UNINSTALL the current 4.0.18 version I already have, before installing the other one? Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Uninstall MySQL for Panther?
John Mistler wrote: I installed MySQL 4.0.18 for Mac. I was able to get in at first: I tried all kinds of commands to change the root password, and every single one would result in Access denied for user . . . I would like to install, instead, CompleteMySQL from the serverlogisitics.com site, which has interfaces to help newbies like me. No, no! Be strong, you don't need the training wheels :-) Re-read the doc about grant tables and then restart the server with the `--skip-grant-tables` flag so you can reset the root password. http://www.mysql.com/doc/en/Resetting_permissions.html HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Uninstall MySQL for Panther?
At 18:33 -0800 3/12/04, John Mistler wrote: I am two days into troubleshooting this. I need some help badly. I installed MySQL 4.0.18 for Mac. I was able to get in at first: Welcome to MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 to server version: 4.0.18-standard Please show us the command you entered to start the mysql program. then I would type mysql create database mytest; and get: ERROR 1044: Access denied for user: '@localhost' to database 'mytest' The account name (@localhost) has no username before the '@' character, which indicates that you have connected as the anonymous user. This user has no privileges to create the mytest database. I tried all kinds of commands to change the root password, and every single one would result in Access denied for user . . . Please show what these commands were. No one can help you diagnose the problem without information to go on. I would like to install, instead, CompleteMySQL from the serverlogisitics.com site, which has interfaces to help newbies like me. However, it is only at version 4.0.15. So my question is: How can I UNINSTALL the current 4.0.18 version I already have, before installing the other one? Well ... I'm afraid we cannot tell you that, either, because although you've indicated that you installed MySQL 4.0.18 for Mac, you haven't told us how you installed it. Did you use the PKG distribution? Did you install from source? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Uninstall MySQL for Panther?
First I want to thank all of you guys for responding. I feel a new sense of confidence that I will be able to get this thing going! However, my problems have compounded. We now have a new problem. I took the advice of one archived postings and dragged the four files seemingly installed by the mysql package at the location (in Mac language) users:johnmistler:the four files to the trash. That didn't feel right to me once I did it, so I dragged them back. They were named: 1. cd 2. md5 3. md5 sum 4. mysql Now, when I go to the terminal and type: /usr/local/mysql/bin/mysql I get: tcsh: /usr/local/mysql/bin/mysql: Command not found This suggests to me that the mysql file it is being directed to is not there. However, I can verify that the file mysql exists at this path (in Mac Language): users:johnmistler:mysql It is listed as a document with Zero KB for its size (?). It definitely is one of the files that I dragged back from the trash. Should I attempt to fix all of this, or go ahead with an uninstall? If I do need to uninstall, how do I do it? I installed the latest PACKAGE from the MySQL.com site 4.0.18-standard along with the startup item package. If you guys still think I need to tough it out, what is the next step? Once again (embarrassingly) -- THANK YOU! John on 3/12/04 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote: At 18:33 -0800 3/12/04, John Mistler wrote: I am two days into troubleshooting this. I need some help badly. I installed MySQL 4.0.18 for Mac. I was able to get in at first: Welcome to MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 to server version: 4.0.18-standard Please show us the command you entered to start the mysql program. then I would type mysql create database mytest; and get: ERROR 1044: Access denied for user: '@localhost' to database 'mytest' The account name (@localhost) has no username before the '@' character, which indicates that you have connected as the anonymous user. This user has no privileges to create the mytest database. I tried all kinds of commands to change the root password, and every single one would result in Access denied for user . . . Please show what these commands were. No one can help you diagnose the problem without information to go on. I would like to install, instead, CompleteMySQL from the serverlogisitics.com site, which has interfaces to help newbies like me. However, it is only at version 4.0.15. So my question is: How can I UNINSTALL the current 4.0.18 version I already have, before installing the other one? Well ... I'm afraid we cannot tell you that, either, because although you've indicated that you installed MySQL 4.0.18 for Mac, you haven't told us how you installed it. Did you use the PKG distribution? Did you install from source? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Uninstall MySQL for Panther?
on 03/12/2004 09:31 PM, John Mistler at [EMAIL PROTECTED] wrote: First I want to thank all of you guys for responding. I feel a new sense of confidence that I will be able to get this thing going! However, my problems have compounded. We now have a new problem. I took the advice of one archived postings and dragged the four files seemingly installed by the mysql package at the location (in Mac language) users:johnmistler:the four files to the trash. That didn't feel right to me once I did it, so I dragged them back. They were named: 1. cd 2. md5 3. md5 sum 4. mysql I don't know what those files are, they are not part of where mysql should have installed its stuff, so there should in theory be no hard in removing them. You can remove mysql by doing the following rm -r /usr/local/mysql rm -r /Library/StartupItems/MySQL This will get you back to a clean machine with no mysql, from there, run the installer and this time follow the instructions exactly on how to start mysql as well as how to set the root password to the mysql permissions database. If you still get stuck, drop me a email directly and I can walk you thought it. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installing Mysql on Panther
Hi, I'd like to install mysql on OSX Panther. In my tutorial it suggests to switch Web Sharing off in the preferences but There are many options in the menu there and web sharing off Is not one of them. Any suggestions? Best, Trebor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing Mysql on Panther
On Dec 19, 2003, at 12:58 AM, Trebor Scholz wrote: I'd like to install mysql on OSX Panther. In my tutorial it suggests to switch Web Sharing off in the preferences but There are many options in the menu there and web sharing off Is not one of them. Perhaps they mean to go to the System Preferences, and turn off Web Sharing in the Sharing preference pane. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031106 7:19:56 /usr/libexec/mysqld: Shutdown Complete *--- Then I tried running *- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031106 07:23:11 mysqld ended *- I still get the error on the /var/mysql/'hostname.err' file *-- 031106 07:23:08 mysqld started 031106 7:23:09 InnoDB: Started 031106 7:23:09 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031106 7:23:09 Aborting 031106 7:23:09 InnoDB: Starting shutdown... 031106 7:23:11 InnoDB: Shutdown completed 031106 7:23:11 /usr/libexec/mysqld: Shutdown Complete 031106 07:23:11 mysqld ended *-- Any other ideas? Thanks, :-) Nestor A. Florez Gabriel Ricard [EMAIL PROTECTED] 11/5/2003 4:33:07 PM Are you using Panther client or server? my.cnf is usually in /etc. Have you run mysql_install_db yet? - Gabriel On Wednesday, November 5, 2003, at 05:57 PM, Nestor Florez wrote: Hi guys, I just was given the OK to play with a new server running Mac OS X (Panther) When I give the command (it is recommended to use mysqld_safe instead of mysqld in some website) *--- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031105 13:09:40 mysqld ended *--- I look at the .err file in /var/mysql/ and it looks like this: * 031105 13:09:38 mysqld started 031105 13:09:38 InnoDB: Started 031105 13:09:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031105 13:09:38 Aborting 031105 13:09:38 InnoDB: Starting shutdown... 031105 13:09:40 InnoDB: Shutdown completed 031105 13:09:40 /usr/libexec/mysqld: Shutdown Complete 031105 13:09:40 mysqld ended * I search for the my.cnf and I do not find it, but I know that Mac OS X puts things in different places. Any ideas? Thanks :-) Nestor A. Florez -- 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: Mysql on panther
My OS X does not have my.cnf anywhere on the machine. :-) Nestor A. Florez Gabriel Ricard [EMAIL PROTECTED] 11/5/2003 4:33:07 PM Are you using Panther client or server? my.cnf is usually in /etc. Have you run mysql_install_db yet? - Gabriel On Wednesday, November 5, 2003, at 05:57 PM, Nestor Florez wrote: Hi guys, I just was given the OK to play with a new server running Mac OS X (Panther) When I give the command (it is recommended to use mysqld_safe instead of mysqld in some website) *--- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031105 13:09:40 mysqld ended *--- I look at the .err file in /var/mysql/ and it looks like this: * 031105 13:09:38 mysqld started 031105 13:09:38 InnoDB: Started 031105 13:09:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031105 13:09:38 Aborting 031105 13:09:38 InnoDB: Starting shutdown... 031105 13:09:40 InnoDB: Shutdown completed 031105 13:09:40 /usr/libexec/mysqld: Shutdown Complete 031105 13:09:40 mysqld ended * I search for the my.cnf and I do not find it, but I know that Mac OS X puts things in different places. Any ideas? Thanks :-) Nestor A. Florez -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
Nestor Florez [EMAIL PROTECTED] wrote: I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031106 7:19:56 /usr/libexec/mysqld: Shutdown Complete *--- Then I tried running=20 *- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031106 07:23:11 mysqld ended *- I still get the error on the /var/mysql/'hostname.err' file *-- 031106 07:23:08 mysqld started 031106 7:23:09 InnoDB: Started 031106 7:23:09 Fatal error: Can't open privilege tables: Can't find = file: './mysql/host.frm' (errno: 13) 031106 7:23:09 Aborting 031106 7:23:09 InnoDB: Starting shutdown... 031106 7:23:11 InnoDB: Shutdown completed 031106 7:23:11 /usr/libexec/mysqld: Shutdown Complete 031106 07:23:11 mysqld ended *-- Any other ideas? perror 13 Error code 13: Permission denied MySQL should be owner of the data dir. -- 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]
RE: Mysql on panther
-Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 15:28 My OS X does not have my.cnf anywhere on the machine. :-) Copy/edit on of the my-*.cnf files from the support-files directory in the mysql distribution directory to /etc/my.cnf I just was given the OK to play with a new server running Mac OS X (Panther) When I give the command (it is recommended to use mysqld_safe instead I look at the .err file in /var/mysql/ and it looks like this: * 031105 13:09:38 mysqld started 031105 13:09:38 InnoDB: Started 031105 13:09:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031105 13:09:38 Aborting Make sure you have run the scripts/mysql_install_db script. Also make sure that the mysql data directory has the correct rights for the mysql user: Something like: chown -R mysql:mysql /usr/local/mysql/var chmod -R 770 /usr/local/mysql/var should probably work. - Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
Egor, Where is the datadir locate? :-) Nestor A. Florez Egor Egorov [EMAIL PROTECTED] 11/6/2003 7:40:28 AM Nestor Florez [EMAIL PROTECTED] wrote: I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031106 7:19:56 /usr/libexec/mysqld: Shutdown Complete *--- Then I tried running=20 *- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031106 07:23:11 mysqld ended *- I still get the error on the /var/mysql/'hostname.err' file *-- 031106 07:23:08 mysqld started 031106 7:23:09 InnoDB: Started 031106 7:23:09 Fatal error: Can't open privilege tables: Can't find = file: './mysql/host.frm' (errno: 13) 031106 7:23:09 Aborting 031106 7:23:09 InnoDB: Starting shutdown... 031106 7:23:11 InnoDB: Shutdown completed 031106 7:23:11 /usr/libexec/mysqld: Shutdown Complete 031106 07:23:11 mysqld ended *-- Any other ideas? perror 13 Error code 13: Permission denied MySQL should be owner of the data dir. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
At 8:04 -0800 11/6/03, Nestor Florez wrote: Egor, Where is the datadir locate? :-) The message below says: Starting mysqld daemon with databases from /var/mysql Which indicates that /var/mysql is the datadir. Change location into the directory and have a look around. Try ls -la . to see what the ownerships are. You should also find a subdirectory named mysql, which is where the grant tables are. Nestor A. Florez Egor Egorov [EMAIL PROTECTED] 11/6/2003 7:40:28 AM Nestor Florez [EMAIL PROTECTED] wrote: I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031106 7:19:56 /usr/libexec/mysqld: Shutdown Complete *--- Then I tried running=20 *- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031106 07:23:11 mysqld ended *- I still get the error on the /var/mysql/'hostname.err' file *-- 031106 07:23:08 mysqld started 031106 7:23:09 InnoDB: Started 031106 7:23:09 Fatal error: Can't open privilege tables: Can't find = file: './mysql/host.frm' (errno: 13) 031106 7:23:09 Aborting 031106 7:23:09 InnoDB: Starting shutdown... 031106 7:23:11 InnoDB: Shutdown completed 031106 7:23:11 /usr/libexec/mysqld: Shutdown Complete 031106 07:23:11 mysqld ended *-- Any other ideas? perror 13 Error code 13: Permission denied MySQL should be owner of the data dir. -- 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]
Re: Mysql on panther
There is no my.cnf by default on OS X. Unless you want to override default compiled settings, it's not really needed. But you usually do, so you need to create your own. MySQL comes with some samples you can use. As for your problems. Your directories where everything is located look like where things were placed in OS X 10.1. Apple and the MySQL package installer install everything in the /user/local/ directory. This started with 10.2. That's probably where all your problems are coming from. I would highly recommend removing your current MySQL install and installing it again so that are your files are in the default locations. That will make things much easier going forward, especially if you don't know how changing directory permissions will affect the OS. The graphical package installer for OSX available from mysql website does a good job of setting things up and putting things in the right place. There is also an installer for having MySQL startup automatically when you boot. The startup script adheres to Apple's guidelines including an XML based parameter list file. On Thursday, November 6, 2003, at 10:27 AM, Nestor Florez wrote: My OS X does not have my.cnf anywhere on the machine. :-) Nestor A. Florez -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
[MySQL won't start] Maybe this knowledge base article is useful: http://docs.info.apple.com/article.html?artnum=107537 JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
Thanks to all the help...I got it working!!! Basically, as recommended, I created a my.cnf I also chown my /var/mysql directory to user 'mysql' and I am cooking now Thanks again!! Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql on panther
Hi guys, I just was given the OK to play with a new server running Mac OS X (Panther) When I give the command (it is recommended to use mysqld_safe instead of mysqld in some website) *--- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031105 13:09:40 mysqld ended *--- I look at the .err file in /var/mysql/ and it looks like this: * 031105 13:09:38 mysqld started 031105 13:09:38 InnoDB: Started 031105 13:09:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031105 13:09:38 Aborting 031105 13:09:38 InnoDB: Starting shutdown... 031105 13:09:40 InnoDB: Shutdown completed 031105 13:09:40 /usr/libexec/mysqld: Shutdown Complete 031105 13:09:40 mysqld ended * I search for the my.cnf and I do not find it, but I know that Mac OS X puts things in different places. Any ideas? Thanks :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
Are you using Panther client or server? my.cnf is usually in /etc. Have you run mysql_install_db yet? - Gabriel On Wednesday, November 5, 2003, at 05:57 PM, Nestor Florez wrote: Hi guys, I just was given the OK to play with a new server running Mac OS X (Panther) When I give the command (it is recommended to use mysqld_safe instead of mysqld in some website) *--- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031105 13:09:40 mysqld ended *--- I look at the .err file in /var/mysql/ and it looks like this: * 031105 13:09:38 mysqld started 031105 13:09:38 InnoDB: Started 031105 13:09:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031105 13:09:38 Aborting 031105 13:09:38 InnoDB: Starting shutdown... 031105 13:09:40 InnoDB: Shutdown completed 031105 13:09:40 /usr/libexec/mysqld: Shutdown Complete 031105 13:09:40 mysqld ended * I search for the my.cnf and I do not find it, but I know that Mac OS X puts things in different places. Any ideas? Thanks :-) Nestor A. Florez -- 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]