Installation Instructions for MySQL for Mac OS X Panther
Does anyone know where I can find in-depth, precise instructions to install MySQL on Mac OS X Panther client? - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Instructions for MySQL for Mac OS X Panther
Just download the install package from the mysql website. Instructions for configuring it (i.e. setting root password) are the same for all platforms. But, if you really need handholding, head over to entropy.ch. On Feb 16, 2005, at 3:43 PM, Asad Habib wrote: Does anyone know where I can find in-depth, precise instructions to install MySQL on Mac OS X Panther client? - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- 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: Installation Instructions for MySQL for Mac OS X Panther
Does anyone know where I can find in-depth, precise instructions to install MySQL on Mac OS X Panther client? - Asad Just get the binary for OSX and follow the readme its simple. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Linking Embedded MySQL on Mac OS X
I am having the same problem that someone else posted about back in December and I didn't see any responses for: http://lists.mysql.com/mysql/156346 Specifically, I am trying to link with libmysqld.a on Mac OS X and am getting 16 undefined link errors such as fixsfdi, floatdisf, udivdi3, moddi3, etc. I have inferred from various google searches that most of these are linked in with a library called libkern on other *nix systems. However, the libkern.h on Mac doesn't list these particular methods and I don't know which library I should include. Regardless of whether you use CodeWarrior, XCode, gcc, or whatever, can anyone point me in the right direction? Thanks, Eric --- Eric Sword Group Logic, Inc. [EMAIL PROTECTED] 800.476.8781 (800.GROUP81) http://www.grouplogic.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Weird bug in MySQL and Mac OS X 10.3
I've had some very weird issues that I've posted about here in the past, but no one was able to help. I posted a bug report on mysql.com and have received some advice on how to suppress the problems I was having. The problem seems to be exploited when running a slave server on OSX 10.3.x; although, by the looks of it, the bug could show up in the master server as well. For more information, please refer the to bug report here: http://bugs.mysql.com/bug.php?id=2030 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: So, how do you REALLY install MySQL in Mac OS X (Panther)?!
Hi Daniel, You are not alone in your quest to successfully start the mysqld server on a Mac OSX platform. I am having similiar difficulty on my ibook... --- On Thu 01/22, Daniel Lahey [EMAIL PROTECTED] wrote: From: Daniel Lahey [mailto: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Wed, 21 Jan 2004 22:39:39 -0800 Subject: So, how do you REALLY install MySQL in Mac OS X (Panther)?! Ok, I've read the release notes, the manual, the threads on this brmailing list, installed/removed/re-installed about 5 times, tried br4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc br867MHz, 768MB RAM). When I run configure, it tells me everything is brhunky-dory and that I should just be happy and run mysqld. I try to brrun mysqld and it immediately aborts and tells me that /tmp/mysql.sock brisn't set up. If I try to run mysqladmin -u root password password brjust like the manual tells me to, it aborts as above and tells me to brrun mysqld (or mysqld_safe). The manual tells me I can just click on brthe dmg file and follow the instructions. I've done that for both the brdistribution and the startup item several times (and re-started several brtimes in between). I've read the manual about security and the root bruser account as the message instructed me to do. No help. I even brtried to compile the control center using the instructions I found for brthat, installed Qt as instructed, compiled it (I think, the brinstructions for that were along the lines of: Now just compile it and bryou're all done! Hah! Do you hear me? Hah, I say.) The brinstructions don't tell me where to install it or how to test for a brvalid installation. When I try to compile CC it says install Qt brfirst. I did. 3 times. In 3 different places. Copied all of the brinclude and lib files all over the freakin' hard drive to try to make brit happy. Not happy.brbrOk, now, are there REAL instructions for installing some working brversion of MySQL on a Mac somewhere? What do I REALLY have to do? Has brsomeone actually documented the entire process or does the brdocumentation consist of the vague, scattered hints I've been able to brfind? I'd love to check out MySQL, but do I have to learn a secret brhandshake or pledge allegiance to Open Source or something?brbrThanks for any help. Sorry to rant, but I've been working on this for brthree days now.brbr- DanbrbrP.S. Any notes on using it with Xcode would be appreciated, too.brbrbr-- brMySQL General Mailing ListbrFor list archives: http://lists.mysql.com/mysqlbrTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]brbr ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!
I successfully used the packages from Server Logistics for this task, installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my 10.3.2 Panther G4. http://www.serverlogistics.com/mysql.php - Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!
I think this is the package I used. The one that I used actually wrote and init script so if you reboot mysql will start automagically. I think this is the one. Joe On Thursday, January 22, 2004, at 08:51 AM, Eve Atley wrote: I successfully used the packages from Server Logistics for this task, installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my 10.3.2 Panther G4. http://www.serverlogistics.com/mysql.php - Eve -- 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: So, how do you REALLY install MySQL in Mac OS X (Panther)?!
This one actually installs a preference pane that allow you to manipulate settings, start/stop server, and change root password. It's quite nice. - Eve -Original Message- From: sulewski [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 7:25 AM To: Eve Atley Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?! I think this is the package I used. The one that I used actually wrote and init script so if you reboot mysql will start automagically. I think this is the one. Joe On Thursday, January 22, 2004, at 08:51 AM, Eve Atley wrote: I successfully used the packages from Server Logistics for this task, installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my 10.3.2 Panther G4. http://www.serverlogistics.com/mysql.php - Eve -- 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: So, how do you REALLY install MySQL in Mac OS X (Panther)?!
wow! That is nice On Thursday, January 22, 2004, at 01:28 PM, Eve Atley wrote: This one actually installs a preference pane that allow you to manipulate settings, start/stop server, and change root password. It's quite nice. - Eve -Original Message- From: sulewski [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 7:25 AM To: Eve Atley Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?! I think this is the package I used. The one that I used actually wrote and init script so if you reboot mysql will start automagically. I think this is the one. Joe On Thursday, January 22, 2004, at 08:51 AM, Eve Atley wrote: I successfully used the packages from Server Logistics for this task, installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my 10.3.2 Panther G4. http://www.serverlogistics.com/mysql.php - Eve -- 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: So, how do you REALLY install MySQL in Mac OS X (Panther)?!
At 22:39 -0800 1/21/04, Daniel Lahey wrote: Ok, I've read the release notes, the manual, the threads on this mailing list, installed/removed/re-installed about 5 times, tried 4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc 867MHz, 768MB RAM). When I run configure, it tells me everything is hunky-dory and that I should just be happy and run mysqld. I try to run mysqld and it immediately aborts and tells me that /tmp/mysql.sock isn't set up. If I try to run mysqladmin -u root Exact command used to start mysqld, and exact text of the error messages, please -- not a text description of what happened. password password just like the manual tells me to, it aborts as above and tells me to run mysqld (or mysqld_safe). The manual tells me I can just That makes sense. mysqladmin has to connect to the server. If the server isn't running, none of the client programs will work. click on the dmg file and follow the instructions. I've done that for both the distribution and the startup item several times (and re-started several times in between). I've read the manual about security and the root user account as the message instructed me to do. No help. I even tried to compile the control center using the instructions I found for that, installed Qt as instructed, compiled it (I think, the instructions for that were along the lines of: Now just compile it and you're all done! Hah! Do you hear me? Hah, I say.) The instructions don't tell me where to install it or how to test for a valid installation. When I try to compile CC it says install Qt first. I did. 3 times. In 3 different places. Copied all of the include and lib files all over the freakin' hard drive to try to make it happy. Not happy. Ok, now, are there REAL instructions for installing some working version of MySQL on a Mac somewhere? What do I REALLY have to do? Has someone actually documented the entire process or does the documentation consist of the vague, scattered hints I've been able to find? I'd love to check out MySQL, but do I have to learn a secret handshake or pledge allegiance to Open Source or something? Thanks for any help. Sorry to rant, but I've been working on this for three days now. - Dan P.S. Any notes on using it with Xcode would be appreciated, too. -- 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: So, how do you REALLY install MySQL in Mac OS X (Panther)?!
I installed MySql 4.0.x on MacOs 10.2.x and it works fine. There are some problems of permissions: check /tmp and mysql data directory. Santino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!
Daniel Lahey wrote: Ok, I've read the release notes, the manual, the threads on this mailing list, installed/removed/re-installed about 5 times, tried 4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc 867MHz, 768MB RAM). When I run configure, it tells me everything is hunky-dory and that I should just be happy and run mysqld. I try to run mysqld and it immediately aborts and tells me that /tmp/mysql.sock isn't set up. If I try to run mysqladmin -u root password password just like the manual tells me to, it aborts as above and tells me to run mysqld (or mysqld_safe). The manual tells me I can just click on the dmg file and follow the instructions. I've done that for both the distribution and the startup item several times (and re-started several times in between). I've read the manual about security and the root user account as the message instructed me to do. No help. I even tried to compile the control center using the instructions I found for that, installed Qt as instructed, compiled it (I think, the instructions for that were along the lines of: Now just compile it and you're all done! Hah! Do you hear me? Hah, I say.) The instructions don't tell me where to install it or how to test for a valid installation. When I try to compile CC it says install Qt first. I did. 3 times. In 3 different places. Copied all of the include and lib files all over the freakin' hard drive to try to make it happy. Not happy. Ok, now, are there REAL instructions for installing some working version of MySQL on a Mac somewhere? What do I REALLY have to do? Has someone actually documented the entire process or does the documentation consist of the vague, scattered hints I've been able to find? I'd love to check out MySQL, but do I have to learn a secret handshake or pledge allegiance to Open Source or something? Thanks for any help. Sorry to rant, but I've been working on this for three days now. - Dan P.S. Any notes on using it with Xcode would be appreciated, too. Dan, I started with mysql 4.0.15 on 10.2.1 and am currently running 4.0.17 on 10.3.2, so the good news is that this should be possible for you. I can imagine your frustration at this point, but you haven't provided enough information to diagnose the problem. I can tell that the server, mysqld, is failing to start for you, so none of the steps after that (mysqladmin, for example) will work until that problem is fixed, as they all require a running server. Because it is often the problem, and easy to fix, I'll go out on a limb and guess the problem may be the permissions on your /tmp directory. (At least one of the Mac OS X updates incorrectly sets the permissions on /tmp.) MySQL runs as the mysql user, so that user must have permission to create the socket (/tmp/mysql.sock) in /tmp. In the terminal, try this cd /tmp ls -l The second line of output from ls (the one with ./) should look like this drwxrwxrwt 5 root wheel 170 22 Jan 17:00 ./ If it does not, you should run sudo chmod 1777 . then try to start mysql (sudo mysqld_safe) again. As I said, that was just a guess. If that's not it, we'll need more information to properly diagnose the problem. The first thing to do is look at the error log. I expect you have mysql installed in /usr/local/mysql, with data and log files in /usr/local/mysql/data. In the data directory there should be a file named hostname.err (where hostname is the name of your computer). This file should contain a line or two explaining why mysql failed to start up. If you need further help, tell us what error message you get when you try mysqld_safe (copy/paste), what hostname.err says, what version of mysql, and what version of OS X you have. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
So, how do you REALLY install MySQL in Mac OS X (Panther)?!
Ok, I've read the release notes, the manual, the threads on this mailing list, installed/removed/re-installed about 5 times, tried 4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc 867MHz, 768MB RAM). When I run configure, it tells me everything is hunky-dory and that I should just be happy and run mysqld. I try to run mysqld and it immediately aborts and tells me that /tmp/mysql.sock isn't set up. If I try to run mysqladmin -u root password password just like the manual tells me to, it aborts as above and tells me to run mysqld (or mysqld_safe). The manual tells me I can just click on the dmg file and follow the instructions. I've done that for both the distribution and the startup item several times (and re-started several times in between). I've read the manual about security and the root user account as the message instructed me to do. No help. I even tried to compile the control center using the instructions I found for that, installed Qt as instructed, compiled it (I think, the instructions for that were along the lines of: Now just compile it and you're all done! Hah! Do you hear me? Hah, I say.) The instructions don't tell me where to install it or how to test for a valid installation. When I try to compile CC it says install Qt first. I did. 3 times. In 3 different places. Copied all of the include and lib files all over the freakin' hard drive to try to make it happy. Not happy. Ok, now, are there REAL instructions for installing some working version of MySQL on a Mac somewhere? What do I REALLY have to do? Has someone actually documented the entire process or does the documentation consist of the vague, scattered hints I've been able to find? I'd love to check out MySQL, but do I have to learn a secret handshake or pledge allegiance to Open Source or something? Thanks for any help. Sorry to rant, but I've been working on this for three days now. - Dan P.S. Any notes on using it with Xcode would be appreciated, too. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with mySQL and Mac OS X
Hi, I've recently been having some problems with mySQL on one of my OS X computers. It was working perfectly until I upgraded from OS 10.2.6 to OS 10.2.8, and now mysqld refuses to start up, showing the following -- [EMAIL PROTECTED] mysql]$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 031220 01:08:05 mysqld ended [EMAIL PROTECTED] mysql]$ -- The error log shows the following: -- 031220 01:08:05 mysqld started 031220 1:08:05 Can't start server : Bind on unix socket: Permission denied 031220 1:08:05 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 031220 1:08:05 Aborting -- I've tried reinstalling mySQL, I've repaired permissions, I've also done some fairly radical things with permissions, but to no avail. If anyone has any suggestions, I'd be incredibly grateful. I'm running mySQL (standard) 4.1.1a for MacOS X, running under MacOS 10.2.8. Thanks for any help, -Jon --- http://www.jonpearse.net[EMAIL PROTECTED] Some people come into our lives and quickly go. Some stay for a while and leave footprints on our hearts. And we are never, ever the same. --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with mySQL and Mac OS X
I'm running mysql 4.0.17 on Mac OS X 10.2.8 without problems. My first guess would be that the upgrade reset the permissions on /tmp, so now the mysql user doesn't have permission to create mysql.sock. Try cd /tmp sudo chmod 1777 . then see if mysqld will start. (While you're in /tmp, make sure there isn't an old mysql.sock still sitting there.) Michael Jon Pearse wrote: Hi, I've recently been having some problems with mySQL on one of my OS X computers. It was working perfectly until I upgraded from OS 10.2.6 to OS 10.2.8, and now mysqld refuses to start up, showing the following -- [EMAIL PROTECTED] mysql]$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 031220 01:08:05 mysqld ended [EMAIL PROTECTED] mysql]$ -- The error log shows the following: -- 031220 01:08:05 mysqld started 031220 1:08:05 Can't start server : Bind on unix socket: Permission denied 031220 1:08:05 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 031220 1:08:05 Aborting -- I've tried reinstalling mySQL, I've repaired permissions, I've also done some fairly radical things with permissions, but to no avail. If anyone has any suggestions, I'd be incredibly grateful. I'm running mySQL (standard) 4.1.1a for MacOS X, running under MacOS 10.2.8. Thanks for any help, -Jon --- http://www.jonpearse.net[EMAIL PROTECTED] Some people come into our lives and quickly go. Some stay for a while and leave footprints on our hearts. And we are never, ever the same. --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setting up MySQL on Mac OS X
I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. Any hints? Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting up MySQL on Mac OS X
iH you may find this site helpful in getting MySQL running for the first time http://www.entropy.ch/software/macosx/mysql/ also recommend that you spend some time learning how to be root, unix permissions, etc - hcir On Thursday, Aug 21, 2003, at 22:53 America/Anchorage, Bob Goldberg wrote: I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting up MySQL on Mac OS X
Once you get everything up and running, and get the basics of MySQL down, here are some tools that can make database administration on the Mac a little simpler in terms of doing every day things, like creating databases, tables, searching, sorting and exporting: Cocoa MySQL- http://versiontracker.com/dyn/moreinfo/macosx/17838 I use Cocoa MySQL every day. It crashes occasionally (it's still in the beta version), but I find it easy-to-use. YourSQL - http://versiontracker.com/dyn/moreinfo/macosx/18018 Very similar interface to Cocoa MySQL Navicat - http://versiontracker.com/dyn/moreinfo/macosx/13371 I haven't used this one as much, but it looks like it might be good. Also, in the way of learning MySQL, I'd recommend Larry Ullman's _MySQL_ on Peach Pit press (ISBN 0-321-12731-5). It's an easy read and it will get you up and running quickly. I refer to this daily as well. Good luck! On Friday, August 22, 2003, at 09:12 AM, Rich Allen wrote: iH you may find this site helpful in getting MySQL running for the first time http://www.entropy.ch/software/macosx/mysql/ also recommend that you spend some time learning how to be root, unix permissions, etc - hcir On Thursday, Aug 21, 2003, at 22:53 America/Anchorage, Bob Goldberg wrote: I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff.
Re: Setting up MySQL on Mac OS X
Bob Goldberg [EMAIL PROTECTED] wrote: I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. What exactly error did you get? As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. Database 'mysql' is created by mysql_install_db script. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. Any hints? -- 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: Setting up MySQL on Mac OS X
G'day Bob I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. There is an alternative installation you might want to consider. Go to www.serverlogistics.com and download complete MySQL. Whilst there, also get Complete Apache2 and Complete PHP:) All these packages are 'double click' installers and the Apache and MySQL come with preference panes for turning them on and off and basic configuration. They also install in non-apple locations so they aren't affected by system updates. Very clear documentation as well. I can't recommend them highly enough. I agree about CocoaMySQL - I too use it every day and it is very capable. It can't do permissions from the GUI but if you're only doing minor development/learning this won't affect you. A small tip for a neat little word processor called (formerly) Hydra which is native OSX, has PHP and HTML syntax highlighting and 'static' line numbering for debugging. It can also be used collaboratively with Rendevous. http://hydra.globalse.org/ You might also want to look at JaneBuilder www.seejanecode.com for a neat app that writes pretty good PHP/MySQL with very little trouble. cheers kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Todd and Guys, Your advice helped me too. I think either Apple screwed up when set up /tmp directory to be writeable by root only or since MySQL package has bug or shall be installed ONLY as root user. - Nicos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Nicos, Actually, MySQL should be installed by an administrator, but it should be executed by root, which would permit the writing to the tmp dir. Meaning everytime you kick off MySQL server, you'll need to do so as root. This is usually how I dow it: cd /usr/local/mysql sudo echo sudo ./bin/mysqld_safe --user=mysql [Note: You'll need to do this on an account with administrator access. When you type sudo echo, you'll need to type your OS X user password.] My boy Marc has a slam'in site for MySQL on OS X http://www.entropy.ch. Since MySQL nor Apple have a startup script for MySQL (to kick off the DB at boot), I use the one he's generated - see his site for more details. Regards, Adam On Thursday, August 7, 2003, at 10:54 PM, Nicos Kekchidis wrote: Todd and Guys, Your advice helped me too. I think either Apple screwed up when set up /tmp directory to be writeable by root only or since MySQL package has bug or shall be installed ONLY as root user. - Nicos -- 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]
Can't start MySQL on Mac OS X
Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
If you did not shutdown the server prior to the upgrade, you could have left mysqld running, even after its socket was removed. Use ps to see if mysqld is still running, and kill it if necessary. Todd O'Bryan wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- 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: Can't start MySQL on Mac OS X
OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- 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: Can't start MySQL on Mac OS X
Check your permissions in /usr/local/mysql, I think the package leaves some incorrectly set. The exact problem is usually logged in /usr/local/mysql/data/hostname.err this file is invaluable Cheers! --s On Wednesday, July 2, 2003, at 09:24 AM, Todd O'Bryan wrote: OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem reinstalling MySQL on Mac OS X
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, thanks for reporting this. I assume, you used the MySQL package from mysql.com? On Thu, 6 Mar 2003, Perry Arnold wrote: I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X machine (version 10.2.4) and I couldn't get it to start up. When I run bin/mysqld_safe, I kept getting the error Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist [note: I later figured out that I *think* I'm getting this error because my machine does not have a recognizable hostname (i.e. you can't look it up via normal DNS)]. Hmm, this case is currently not properly handled, indeed. Thanks for the hint! mysql_install_db simply aborts, if the host name cannot be resolved, but the error does not get fed back to the installer itself... After mucking around for quite a while without much success, I decided to start over and reinstall from scratch. So, I deleted my mysql directory and reinstalled from the Package. Now, when I try to run bin/mysqld_safe, I get the following error: InnoDB: Operating system error number 13 in a file operation. It looks like when you reinstall from the package, it skips the step where it changes file permissions of the data directory and its subdirectories. How-To-Repeat: On a fresh MacOS X 10.2.4 system, (1) install the 4.0.11-gamma package, (2) delete the mysql directories (the /usr/local/mysql link and /usr/local/mysql-standard-4.0.11-gamma-apple-darwin6.4-powerpc directory), (3) install the 4.0.11 package again, (4) run bin/mysqld_safe. Fix: Change the file permissions of the data directory and its subdirectories. Ideally, this would be fixed within the Package installer, but a release note or something would work as well. This is interesting. Are you sure you removed all mysql directories in /usr/local? The installation package includes a postinstall script, that does the following: [SNIP] if cd /usr/local/mysql ; then if [ ! -f data/mysql/db.frm ] ; then ./scripts/mysql_install_db fi if [ -d data ] ; then chown -R mysql data fi else exit $? fi [SNIP] /usr/local/mysql is a symlink, pointing to the real installation directory and is included in the package itself. So if you really removed all files, the ownerships should have been set up correctly. Unfortunately it's very hard to debug this problem, since the Package Installer does not offer any logging functionality... After looking through your mail again, I wonder how you tried to start MySQL. Did you use sudo mysqld_safe, as described in the docs? If you try it as a normal user (omitting sudo, the directory permissions and ownerships indeed will give you a permission denied error message. This is intentional! Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+eJjQSVDhKrJykfIRAu9eAJ9AWiSgVNOB9e3LMMxzllQ2VTNESQCfa/mg /FXb3eaPfsHvOtK0zfPXqsg= =glQe -END PGP SIGNATURE- - 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
Problem reinstalling MySQL on Mac OS X
Description: I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X machine (version 10.2.4) and I couldn't get it to start up. When I run bin/mysqld_safe, I kept getting the error Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist [note: I later figured out that I *think* I'm getting this error because my machine does not have a recognizable hostname (i.e. you can't look it up via normal DNS)]. After mucking around for quite a while without much success, I decided to start over and reinstall from scratch. So, I deleted my mysql directory and reinstalled from the Package. Now, when I try to run bin/mysqld_safe, I get the following error: InnoDB: Operating system error number 13 in a file operation. It looks like when you reinstall from the package, it skips the step where it changes file permissions of the data directory and its subdirectories. How-To-Repeat: On a fresh MacOS X 10.2.4 system, (1) install the 4.0.11-gamma package, (2) delete the mysql directories (the /usr/local/mysql link and /usr/local/mysql-standard-4.0.11-gamma-apple-darwin6.4-powerpc directory), (3) install the 4.0.11 package again, (4) run bin/mysqld_safe. Fix: Change the file permissions of the data directory and its subdirectories. Ideally, this would be fixed within the Package installer, but a release note or something would work as well. Submitter-Id: Perry Arnold/[EMAIL PROTECTED] Originator: Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: MacOS Installation Bug Severity: serious Priority: low Category: mysql Class: sw-bug Release:mysql-4.0.11-gamma-standard (Official MySQL-standard binary) C compiler:gcc (GCC) 3.1 20020420 (prerelease) C++ compiler: gcc (GCC) 3.1 20020420 (prerelease) Environment: PowerMac Dual 1.25Ghz/OS X 10.2.4 System: Darwin localhost 6.4 Darwin Kernel Version 6.4: Wed Jan 29 18:50:42 PST 2003; root:xnu/xnu-344.26.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs Thread model: posix Apple Computer, Inc. GCC version 1175, based on gcc version 3.1 20020420 (prerelease) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Mar 3 18:32 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--disable-shared' '--with-innodb' 'CC=gcc' 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' 'CXX=gcc' - 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
Urgent help needed ! --- mySQL on Mac OS X
greetings nug we ar estuck in a project to connect to mySQL running on Mac OS X, through TCP/IP, please suggest regards, ram -- +--+ Mac Solutions http://www.macsolutionsindia.com +91 98102 70848 ram @ macsolutionsindia.com MSN: [EMAIL PROTECTED] support @ macsolutionsindia.com +--+ Simplifying solutions for you... Macintosh, Windows, Client/Server, Web - 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 on Mac OS X S 10.2
Well, I think I ALMOST have figured out how to get the Apple installed MySQL running on Mac OS X Server 10.2 (not an XServe). I have it running but still have some issues: (Apple installs the mysql in /usr/share as opposed to /usr/local... as far as I can tell.) I am having trouble with 2 things: 1) Apple has also already created a user named mysql -this can be seen in the NetInfo Manager, no where else that I am aware of. This user's passwd is listed in NetInfo as * (an asterisk)... I do not know what that means unless it means one has not been set, i.e., anything. So that is one question I have, about the password and how to check it AND how to set it. Also, should I do a chown -R on Mysql/* to the user: mysql ? (Once I know or have set its passwd?) 2) Then I would like to know what to do to make THAT user the one who starts mysqld, instead of the mysql Root user which I am doing manually if I had to reboot. Thanks a lot for any help, TR - 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: logging into mysql on mac os x
The command is th same on just about all systems: mysql -u username -p You would then be prompted for the password. These are mysql username and passwords, not os level users. Typically the user would be root, meaning the mysql root user, not OSX root user. MySQL has to be running too. safe_mysqld What error message are you getting? On Monday, October 21, 2002, at 04:10 PM, Davinder wrote: Any ideas? what is the commands to log in? -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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
logging into mysql on mac os x
Hi everyone, I'm a newbie to mysql and i'm trying to log into the mysql monitor from the terminal in mac os x (10.2.1). I was able to do it when i installed the system but for the life of me i can not figure out how to go back into it. Whenever i type the commands the articles i read say it never opens. I look in other books, type what they say and doesn't work. Any ideas? what is the commands to log in? Please help! and thank you in advance! Davinder Davinder [EMAIL PROTECTED] http://www.mahal.org - 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: Problem: MySQL Client Mac OS X 10.2 (Jaguar: Build 6C106)
On 26/7/02 6:07 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Binary builds often break when tried with a newer version of Mac OS X than the one they were built on. Can you try building from source? I tried building with the following configure options: ./configure --without-server --prefix=/usr/local/mysql All goes well. However when I try to 'make' it fails with the following error: g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -o mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a ../libmysql/.libs/libmysqlclient.a -lz -lm -lz -lm ld: Undefined symbols: _tgoto _tputs _tgetent _tgetflag _tgetnum _tgetstr make[2]: *** [mysql] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 This is using the Build 6C106 Developer Tools. I'm afraid I don't have a clue as to what the problem is but maybe some one else who knows a bit more may be able to shed some light on the situation. Cheers, Ian - 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
Problem: MySQL Client Mac OS X 10.2 (Jaguar: Build 6C106)
Hi, Is anybody else having a problem using the MySQL client with Mac OS X 10.2 (Jaguar: Build 6C106)? When I try to connect to the server on 'localhost' I get the following: dyld: ./bin/mysql Undefined symbols: ./bin/mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap If I then try to connect to the same server from another machine I get the following: ERROR 2003: Can't connect to MySQL server on server ip address (61) A socket problem of some sort??? The strange thing is I can connect using 'phpMyAdmin' without a problem from both machines. Just for the record I'm using binary of MySQL 3.23.51 obtained from http://www.entropy.ch. Any ideas? Cheers, Ian - 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: Problem: MySQL Client Mac OS X 10.2 (Jaguar: Build 6C106)
At 13:24 +0100 7/26/02, Ian Fieldhouse wrote: Hi, Is anybody else having a problem using the MySQL client with Mac OS X 10.2 (Jaguar: Build 6C106)? When I try to connect to the server on 'localhost' I get the following: dyld: ./bin/mysql Undefined symbols: ./bin/mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap If I then try to connect to the same server from another machine I get the following: ERROR 2003: Can't connect to MySQL server on server ip address (61) A socket problem of some sort??? The strange thing is I can connect using 'phpMyAdmin' without a problem from both machines. Just for the record I'm using binary of MySQL 3.23.51 obtained from http://www.entropy.ch. Binary builds often break when tried with a newer version of Mac OS X than the one they were built on. Can you try building from source? Any ideas? Cheers, Ian - 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
Enabling MySQL on Mac OS X Server
Does anyone know if these instructions actually work? (they didn't for me) http://cerebus.sandiego.edu/~jerry/UnixTips/mysql.html I'd like to fix them up so I and others never have to seek this out again, tall order? Who can help me? after I followed these the server didn't start. I had to use the --force option to install the default dbases. I will say that my particular problem may be due to my lack setting my host name correctly. I have very recently installed OS X Server (10.1.4) just so I could try this on a clean system. I don't understand too much about host names, here's what I do know: I have host names that I get from dynydns.org, e.g., mbase.dyndns.org. the Domain Name Servers in my Network settings are pointed to my provider's DNS numbers. I have many of these host and I know which one the main one is. This setup works great and I have had MySQL running on this before and similarly on OS X client. I simply want to to use/enable the MySQL that comes with OS X Server. I have written Apple about exactly the same. Thanks Lloyd - 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 on Mac OS X
on 12/5/2002 9:21 pm, Phil Dobbin at [EMAIL PROTECTED] wrote: Well, I finally got in but now I get a 1044 error: [localhost:~] phil% mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 37 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql Any thoughts on this one? Basically I need to access the user tables but it will not let me any further than here. Hi Phil, Try [localhost:~] phil% mysql -u root -p (the default root password is left blank). David B. - 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 on Mac OS X
I'm still trying to get MySQL running on Mac OS X and previously after installation when MySQL was running, I was getting 1045/6 errors and now, after a re-boot, MySQL is not running (I didn't add the start-up script because of the constant permissions errors I was getting). When I try to enter mysql I get: [localhost:~] phil% mysql -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Also when I try to start up (using ./bin/safe_mysqld --user=mysql ) I get: 20512 00:13:18 mysqld restarted rm: /usr/local/mysql/data/localhost.pid: Permission denied ../bin/safe_mysqld: permission denied: /usr/local/mysql/data/localhost.err [235] tee: /usr/local/mysql/data/localhost.err: Permission denied ad infinitum (I eventually have to sudo kill -9 PID to stop it). I've added a ~/.my.cnf file (per instructions in the MySQL manaul) but that makes no difference. Could someone advise me on which file I have to edit to enable start up and use of MySQL (huge_cnf?)? Also, I'm using Marc Liyange's Entropy installation. Has anybody used his uninstall script and, if so, how safe was it (it looks like I may have to uninstall and start again)? Regards, Phil. - 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 on Mac OS X
At 13:36 +0100 5/12/02, Phil Dobbin wrote: I'm still trying to get MySQL running on Mac OS X and previously after installation when MySQL was running, I was getting 1045/6 errors and now, after a re-boot, MySQL is not running (I didn't add the start-up script because of the constant permissions errors I was getting). When I try to enter mysql I get: [localhost:~] phil% mysql -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Also when I try to start up (using ./bin/safe_mysqld --user=mysql ) I get: 20512 00:13:18 mysqld restarted rm: /usr/local/mysql/data/localhost.pid: Permission denied ../bin/safe_mysqld: permission denied: /usr/local/mysql/data/localhost.err [235] tee: /usr/local/mysql/data/localhost.err: Permission denied ad infinitum (I eventually have to sudo kill -9 PID to stop it). I've added a ~/.my.cnf file (per instructions in the MySQL manaul) but that makes no difference. Could someone advise me on which file I have to edit to enable start up and use of MySQL (huge_cnf?)? Also, I'm using Marc Liyange's Entropy installation. Has anybody used his uninstall script and, if so, how safe was it (it looks like I may have to uninstall and start again)? Doesn't look like a configuration file problem, looks like a file ownership problem. The server needs to be able to access its files. Try (as root): # cd /usr/local # chown -R mysql mysql My guess is that the mysql hierarchy is owned by root, and that when you specify --user=mysql to run the server, it can't write to root-owned directories. Regards, Phil. - 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 on Mac OS X
On 12/5/02 at 12:18, [EMAIL PROTECTED] (Paul DuBois) wrote: At 13:36 +0100 5/12/02, Phil Dobbin wrote: [...] 20512 00:13:18 mysqld restarted rm: /usr/local/mysql/data/localhost.pid: Permission denied ../bin/safe_mysqld: permission denied: /usr/local/mysql/data/localhost.err [235] tee: /usr/local/mysql/data/localhost.err: Permission denied ad infinitum (I eventually have to sudo kill -9 PID to stop it). I've added a ~/.my.cnf file (per instructions in the MySQL manaul) but that makes no difference. Could someone advise me on which file I have to edit to enable start up and use of MySQL (huge_cnf?)? Also, I'm using Marc Liyange's Entropy installation. Has anybody used his uninstall script and, if so, how safe was it (it looks like I may have to uninstall and start again)? Doesn't look like a configuration file problem, looks like a file ownership problem. The server needs to be able to access its files. Try (as root): # cd /usr/local # chown -R mysql mysql My guess is that the mysql hierarchy is owned by root, and that when you specify --user=mysql to run the server, it can't write to root-owned directories. I got finally got it started by doing: su mysql password xx mysql% cd /usr/local/mysql mysql% ./bin/safe_mysqld --user=mysql but now I get 1045 error messages when I try to access mysql whether as me or root: [localhost:~] phil% mysqladmin reload ../bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'phil@localhost' (Using password: YES)' [localhost:~] phil% mysqladmin -u root -p create database_name Enter password: ../bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [localhost:~] phil% This is just a small selection of the error messages I'm getting. I've added a ~/.my.cnf file but to no avail and studied the appropriate pages of the manual but I cannot connect to mysql. Any further help appreciated (the original lines you suggested I used when I installed). Regards, Phil. - 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 on Mac OS X
On 12/5/02 at 18:40, [EMAIL PROTECTED] (Phil Dobbin) wrote: I got finally got it started by doing: su mysql password xx mysql% cd /usr/local/mysql mysql% ./bin/safe_mysqld --user=mysql but now I get 1045 error messages when I try to access mysql whether as me or root: [localhost:~] phil% mysqladmin reload .../bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'phil@localhost' (Using password: YES)' [localhost:~] phil% mysqladmin -u root -p create database_name Enter password: .../bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [localhost:~] phil% Well, I finally got in but now I get a 1044 error: [localhost:~] phil% mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 37 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql Any thoughts on this one? Basically I need to access the user tables but it will not let me any further than here. Regards, Phil. - 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 on Mac OS X
Hi. I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into /usr/local/) but now I'm having what I believe is a common permission problem. When trying to add a database I get the following error: [localhost:~] phil% mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql I couldn't find anything in the archives so I wondered, could somebody let me know the workaround I need to do on the permissions to get me started? Any help appreciated. Regards, Phil. - 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 on Mac OS X
on my box the following helped: (su to root) chown -R mysql /usr/local/mysql/var (check if this is the path to your mysql var ) (exit root) that should do it. also check in the user and host table if a connection from localhost is allowed for the specific user.. Cheers, Sven On Monday, May 6, 2002, at 07:42 PM, Phil Dobbin wrote: Hi. I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into /usr/local/) but now I'm having what I believe is a common permission problem. When trying to add a database I get the following error: [localhost:~] phil% mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql I couldn't find anything in the archives so I wondered, could somebody let me know the workaround I need to do on the permissions to get me started? Any help appreciated. Regards, Phil. - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Mac OS X
On 6/5/02 at 19:53, [EMAIL PROTECTED] (Sven Bentlage) wrote: on my box the following helped: (su to root) chown -R mysql /usr/local/mysql/var (check if this is the path to your mysql var ) (exit root) that should do it. also check in the user and host table if a connection from localhost is allowed for the specific user.. Having looked, I have no /usr/local/mysql/var. The installation instructions (from Marc Liyanage's excellent website) were as follows (in part): sudo chown -R mysql /usr/local/mysql/* followed by: sudo ./bin/safe_mysqld --user=mysql Also, how do I check the user/host table? Thanks for your help, Regards, Phil. On Monday, May 6, 2002, at 07:42 PM, Phil Dobbin wrote: Hi. I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into /usr/local/) but now I'm having what I believe is a common permission problem. When trying to add a database I get the following error: [localhost:~] phil% mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql I couldn't find anything in the archives so I wondered, could somebody let me know the workaround I need to do on the permissions to get me started? Any help appreciated. Regards, Phil. - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Mac OS X
Phil, Monday, May 06, 2002, 1:42:28 PM, you wrote: PD I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into /usr/local/) but now I'm having what I believe is a common permission problem. When trying to add a database I PD get the following error: PD [localhost:~] phil% mysql PD Welcome to the MySQL monitor. Commands end with ; or \g. PD Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch PD Type 'help;' or '\h' for help. Type '\c' to clear the buffer. PD mysql create database CONTACT; PD ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' PD I couldn't find anything in the archives so I wondered, could somebody let me know the workaround I need to do on the permissions to get me started? By default anonymous user ('') has permissions only on the database 'test'. You should have permissions to create databases. You can find a lot of info about MySQL privilege system in our manual: http://www.mysql.com/doc/P/r/Privilege_system.html http://www.mysql.com/doc/U/s/User_Account_Management.html PD Any help appreciated. PD Regards, PD Phil. -- 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
building latest mysql on mac os x
I've been watching the mysql.com downloads page for a while and it doesn't seem like there's a build of 3.23.49 coming soon. The manual on mysql.com talks about a 3.23.50, is that the latest source distribution? What is 3.23.49a, which is listed for the downloads? I'd like to get a build of 3.23.50 or .49a, whichever is more stable, on OS X soon. So if there isn't one available then I guess I'll build it myself. Are there any known issues with building these versions on Mac OS X? Thanks, Gabriel Ricard - 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: building latest mysql on mac os x
At 12:01 -0500 3/25/02, Gabriel Ricard wrote: I've been watching the mysql.com downloads page for a while and it doesn't seem like there's a build of 3.23.49 coming soon. The manual on mysql.com talks about a 3.23.50, is that the latest source distribution? What is 3.23.49a, which is listed for the downloads? The manual is usually slightly ahead of the distributions that are available. Use 3.23.49a. I'd like to get a build of 3.23.50 or .49a, whichever is more stable, on OS X soon. So if there isn't one available then I guess I'll build it myself. Are there any known issues with building these versions on Mac OS X? No. Well, yes. You can't use BDB tables. Thanks, Gabriel Ricard - 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 on MAC OS X 10.1
James wrote: I'd like to install MySQL on MAC OS X 10.1 I've notice it's using Darwin 1.4 But the binaries for MySQL appear to say for Darwin 5.1 What should I do? Apparently Apple decided to move Darwin's version number to 5.1 when it shipped the update of OS X 10.1.1. I have heard this was done to get Darwin's version number closer to the version of OS X that it ships with and will at some point in time become the same version number as Mac OS X to make things more uniform. In any case, you can use the Software Updater to update to OS X 10.1.3 which will also update Darwin to 5.3. -- David Steinbrunner mailto:[EMAIL PROTECTED] MFM Communication Software, Inc. http://www.mfm.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 on MAC OS X 10.1
I'd like to install MySQL on MAC OS X 10.1 I've notice it's using Darwin 1.4 But the binaries for MySQL appear to say for Darwin 5.1 What should I do? James __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.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: MySQL on MAC OS X 10.1
Marc Liyanage has a special Mac OS X friendly installer at: http://www.entropy.ch/software/macosx/mysql/ I've installed it on OS X 10.1 and it works great. David Gadd gaddzeit.com I'd like to install MySQL on MAC OS X 10.1 I've notice it's using Darwin 1.4 But the binaries for MySQL appear to say for Darwin 5.1 What should I do? James __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.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
DBD::Mysql on Mac OS X
I am trying to install mysql, DBI, and DBD::mysql on MacOS X. My problems are in the DBI and DBD::mysql part. Has anyone successfully installed the DBI and DBD::mysql perl modules on this platform? I'm running into troubles in the fact that, god bless them, whoever decided to put unix on a mac, decided that, hey! You don't need a compiler! :-) So I've been looking around for binary versions of DBD::mysql.. to no avail.. nor can I find a binary version of the crap which you would normally use to install products/modules from source! Anyone have any pointers (meaning can you point me in the right direction) or suggestions as to how I can allow the perl product that I have installed use mysql? (comments like Get a real OS won't be usefull, because it's a clients machine). TIA! -John - 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: DBD::Mysql on Mac OS X
At 13:54 -0500 1/31/02, John Tsangaris wrote: I am trying to install mysql, DBI, and DBD::mysql on MacOS X. My problems are in the DBI and DBD::mysql part. Has anyone successfully installed the DBI and DBD::mysql perl modules on this platform? I'm running into troubles in the fact that, god bless them, whoever decided to put unix on a mac, decided that, hey! You don't need a compiler! :-) So I've been looking around for binary versions of DBD::mysql.. to no avail.. nor can I find a binary version of the crap which you would normally use to install products/modules from source! I've installed it, but from source, because I installed the Mac OS Developer's tools. Those come on a separate CD with Mac OS X; the updated versions are available from, uh, I think http://developer.apple.com/tools/ Anyone have any pointers (meaning can you point me in the right direction) or suggestions as to how I can allow the perl product that I have installed use mysql? (comments like Get a real OS won't be usefull, because it's a clients machine). TIA! -John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2
Yes. Dumb question. You did install the OS X developer tools, yes? I just compiled 3.23.47 from source this morning on 10.1.2 with not a problem at all. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 18:40:12 -0800 To: [EMAIL PROTECTED] Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to compile it with: ./configure --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-pthread \ --with-raid Unfortunately, I can't even get it to compile with just: ./configure Produces error: sql_show.cc c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -c sql_udf.cc sql_udf.cc:57: dlfcn.h: No such file or directory make[3]: *** [sql_udf.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 Any suggestions? Ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2
Cool. And the file ./mysql-3.23.47/sql/sql_udf.cc is present? Did you try a make clean? It shouldn't have any effect on configure but... -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Wed, 30 Jan 2002 00:21:44 -0800 To: [EMAIL PROTECTED] Subject: Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 Yes. Dumb question. You did install the OS X developer tools, yes? I just compiled 3.23.47 from source this morning on 10.1.2 with not a problem at all. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 18:40:12 -0800 To: [EMAIL PROTECTED] Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to compile it with: ./configure --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-pthread \ --with-raid Unfortunately, I can't even get it to compile with just: ./configure Produces error: sql_show.cc c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -c sql_udf.cc sql_udf.cc:57: dlfcn.h: No such file or directory make[3]: *** [sql_udf.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 Any suggestions? Ryan - 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 - 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 compile error, mysql-3.23.47, Mac OS X 10.1.2
Yes, the file is present. Yes, I've made clean between each attempt. At 10:11 AM -0500 1/30/02, John McCauley wrote: Cool. And the file ./mysql-3.23.47/sql/sql_udf.cc is present? Did you try a make clean? It shouldn't have any effect on configure but... -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Wed, 30 Jan 2002 00:21:44 -0800 To: [EMAIL PROTECTED] Subject: Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 Yes. Dumb question. You did install the OS X developer tools, yes? I just compiled 3.23.47 from source this morning on 10.1.2 with not a problem at all. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 18:40:12 -0800 To: [EMAIL PROTECTED] Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to compile it with: ./configure --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-pthread \ --with-raid Unfortunately, I can't even get it to compile with just: ./configure Produces error: sql_show.cc c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -c sql_udf.cc sql_udf.cc:57: dlfcn.h: No such file or directory make[3]: *** [sql_udf.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 Any suggestions? Ryan - 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 - 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
MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2
I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to compile it with: ./configure --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-pthread \ --with-raid Unfortunately, I can't even get it to compile with just: ./configure Produces error: sql_show.cc c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -c sql_udf.cc sql_udf.cc:57: dlfcn.h: No such file or directory make[3]: *** [sql_udf.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 Any suggestions? Ryan - 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 compile error, mysql-3.23.47, Mac OS X 10.1.2
Dumb question. You did install the OS X developer tools, yes? I just compiled 3.23.47 from source this morning on 10.1.2 with not a problem at all. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 18:40:12 -0800 To: [EMAIL PROTECTED] Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to compile it with: ./configure --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-pthread \ --with-raid Unfortunately, I can't even get it to compile with just: ./configure Produces error: sql_show.cc c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -c sql_udf.cc sql_udf.cc:57: dlfcn.h: No such file or directory make[3]: *** [sql_udf.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 Any suggestions? Ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP - Setting up MySQL on Mac OS X 10.0.4
Brandon, I've had success, but it has been painful and I'm not sure that I can easily reproduce it. I did a combination of the mysql load that provided the latest version and then got the mysql package from this German guy. I found him from the discussions on http://www.apple.com/support. There are two solutions there. One of them is: http://www.macosguru.de/ (This worked perfectly for me). Then there was another trick that requires you to set the permissions on /tmp. Please drop me a note if these two don't get you started. Lloyd From: Brandon Pearcy [EMAIL PROTECTED] Date: Tue, 13 Nov 2001 18:37:52 -0700 To: [EMAIL PROTECTED] Subject: HELP - Setting up MySQL on Mac OS X 10.0.4 Hi Everyone, Has anyone successfully set up MySQL on Mac OS X 10.0.4 yet? If so, what distribution did you use? What special steps (if any) did you have to take? Every tutorial on this topic that I've found on the web so far, is either outdated or has simply has not worked for me. Thanks in advance for any help! -- -- Brandon Pearcy Internet Technician Bowes Online -- phone: 1-780-532-1110 ext. 265 fax: 1-780-532-2120 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: HELP - Setting up MySQL on Mac OS X 10.0.4
Has anyone successfully set up MySQL on Mac OS X 10.0.4 yet? If so, what distribution did you use? What special steps (if any) did you have to take? Every tutorial on this topic that I've found on the web so far, is either outdated or has simply has not worked for me. That's because Mac OS X 10.0.4 is outdated. Unless you have a really good reason not to use it, you should use 10.1 (it's much much better for only a $20 upgrade). Note that 10.1 DevTools is different from 10.0.4, so you will need that too (free download with registration @ apple.com), and there will be some changes especially if you use Apache. If you need more info on that, email me, but on the subject of setting up MySQL on 10.1: http://developer.apple.com/internet/macosx/osdb.html http://www.stepwise.com/Articles/Workbench/2001-10-11.01.html and if you want to do a binary install, there's Fink or Marc Liyanage's packages: http://fink.sourceforge.net http://www.entropy.ch/software/MacOSx/mysql/ Fink is well worth it, it is a port of Debian's package management for Darwin (and there are plenty of ports available through Fink). Erik = Microsoft e[X]tra [P]roprietary -- Is this where you really wanted to go today ? -- http://www.redhat.com/about/opinions/xp.html __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.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: HELP - Setting up MySQL on Mac OS X 10.0.4
Brandon, Try going to http://www.entropy.ch/software/macosx/mysql/. There is a download and instructions on how to set it up. I've installed it on OSX 10.0.4 Server, OSX 10.0.4 Client, and OSX 10.1 Client and it's worked perfectly every time. Hope this helps. Jason From: Brandon Pearcy [EMAIL PROTECTED] Date: Tue, 13 Nov 2001 18:37:52 -0700 To: [EMAIL PROTECTED] Subject: HELP - Setting up MySQL on Mac OS X 10.0.4 Hi Everyone, Has anyone successfully set up MySQL on Mac OS X 10.0.4 yet? If so, what distribution did you use? What special steps (if any) did you have to take? Every tutorial on this topic that I've found on the web so far, is either outdated or has simply has not worked for me. Thanks in advance for any help! -- -- Brandon Pearcy Internet Technician Bowes Online -- phone: 1-780-532-1110 ext. 265 fax: 1-780-532-2120 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
HELP - Setting up MySQL on Mac OS X 10.0.4
Hi Everyone, Has anyone successfully set up MySQL on Mac OS X 10.0.4 yet? If so, what distribution did you use? What special steps (if any) did you have to take? Every tutorial on this topic that I've found on the web so far, is either outdated or has simply has not worked for me. Thanks in advance for any help! -- -- Brandon Pearcy Internet Technician Bowes Online -- phone: 1-780-532-1110 ext. 265 fax: 1-780-532-2120 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem installing mySql on Mac OS X
I am having a few problems with the install. First off Mac OS X does not support the groupadd or useradd commands. Next the scripts/mysql_install_db fails and tells me to look for more i\ nformation in ./data logs, however in the data directory there are no log files\ . How-To-Repeat: Follow the instructions in the INSTALL-BINARY file. Fix: ??? Submitter-Id: submitter ID Originator:System Administrator Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: Installing on Mac OS X Severity: critical Priority: medium Category: mysql Class: support Release: mysql-3.23.42-apple-rhapso (Official MySQL binary) - 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: Problem installing mySql on Mac OS X
This site has precompiled MySQL binaries for Mac OS X: http://www.entropy.ch/software/macosx/mysql/ It also has easy to follow installation instructions. You need to use your Users utility to add the MySQL user instead of the useradd and groupadd commands. Complete instructions are at the site. On Thursday, September 13, 2001, at 05:39 PM, [EMAIL PROTECTED] wrote: I am having a few problems with the install. First off Mac OS X does not support the groupadd or useradd commands. Next the scripts/mysql_install_db fails and tells me to look for more i\ nformation in ./data logs, however in the data directory there are no log files\ . How-To-Repeat: Follow the instructions in the INSTALL-BINARY file. Fix: ??? Submitter-Id: submitter ID Originator:System Administrator Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: Installing on Mac OS X Severity: critical Priority: medium Category: mysql Class: support Release: mysql-3.23.42-apple-rhapso (Official MySQL binary) - 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 mysql-unsubscribe- [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
MySQL on Mac OS X?
Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul - 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 on Mac OS X?
I haven't run mysql personally on my OS X box yet but I do know of some who have and there seems to be a current problem with getting mysql to quit properly. I think that will be fixed with Mac OS X 10.1 which is coming out sometime this month. Other than that go to www.versiontracker.com and click on the OS X section and do a search for SQL you will find a lot of tools to help you out. Troy On Wednesday, September 12, 2001, at 05:03 AM, Paul Groves wrote: Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul - 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 mysql-unsubscribe- [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
MySQL on Mac OS X?
Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul -- Paul Groves, HCDT Senior Project Officer Humanities Computing Development Team OUCS, 13 Banbury Rd, Oxford, OX6 2NN. Tel: +44 (0)1865 273 290 Web: www.oucs.ox.ac.uk/hcdt/staff.html#paul HCDT is part of the Learning Technologies Group www.oucs.ox.ac.uk/ltg/ - 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 on Mac OS X?
At 10:03 AM +0100 9/12/01, Paul Groves wrote: Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, I use it on my iBook when I'm travelling and don't have access to MySQL on my primary servers. I run it with Perl (DBI), PHP 4, Python (DB-API), and Java (JDBC). I think I've gotten Ruby to compile and used the Ruby MySQL interface a bit, too. Don't quote me on that. :-) The one problem is that the server won't shut down properly. This is apparently a problem with Apple's thread library or something. kill -9 works, though. If you restart Mac OS X, it seems to pause during shutdown more with mysqld running than when it's not, which I attribute to the system waiting for mysqld to shut down, and then finally force killing it. regards Paul -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Building/installing MySQL under Mac OS X 10.03
Hi Everbody, Forgive if there is a fact somewhere for this. I have benn trying to install mysql 3.23.38 under Mac OS X 10.03 to no avail. The binary distrubution says I need pthreads ! the manual says I do not !?! The only binary arround is for the Mac OS Server (though it should matter much ). My Problems re either: Where can I get pthreads binary or instruction to build ! ORRR Where can I find decent instructions on how to build mysql 3.23.38 ? Do not say the manual !! According to it mysql should compile ! But that note is for Mac Public Beta not Mac OS X 10.03(.0x)! Second when I tried compiling for Mac Server I get syntax errors and can not build or install while compiling the sources !! I have tried several patches (with fresh installs of the sources) for earlier versions of mysql on 3.23.38 to no avial. I have found references to a path to one file in line 12xx or something like that, but another source says it does fit the sources of 3.32.38. Please help ! Thanx in advance Keith. - 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: Building/installing MySQL under Mac OS X 10.03
I don't understand how yuo can have so much trouble building it ! I just downloaded the latest stable release, unzipped it, and did ./configure make make install mysql_install_db safe_mysqld and it went hoopla running ! (after almost half an hour compiling that is) - 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: Building/installing MySQL under Mac OS X 10.03
PS : here's my versionnnumber : mysql SHOW VARIABLES LIKE version; +---+-+ | Variable_name | Value | +---+-+ | version | 3.23.37 | +---+-+ 1 row in set (0.00 sec) - 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 for Mac OS X
I am looking for MySQL for Apple's Mac OS X (10.0.3). Up to now I have only found some old versions for Mac OS X Server or OS X Beta Any tips or hints? Regards Robert Goeres - 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 for Mac OS X
At 2:36 PM +0200 5/16/01, Robert Goeres wrote: I am looking for MySQL for Apple's Mac OS X (10.0.3). Up to now I have only found some old versions for Mac OS X Server or OS X Beta Any tips or hints? Try this ... http://www.versiontracker.com/moreinfo.fcgi?id=10425 -- %~%~% | Ray Zimmerman ([EMAIL PROTECTED]) | The number you have| | 428-B Phillips Hall| dialed is imaginary. | | Cornell Univ., Ithaca, NY 14853 | Please rotate the phone| | 607-255-9645 Fax: 815-377-3932| 90 degrees and try again.| %~%~% - 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 for Mac OS X
You can compile from source on OS X. I personally built 3.23.36 on 10.0 when it came out; right now it requires a couple of edits to the source code prior to compilation. The edit can be found here: http://www.mysql.com/doc/M/a/Mac_OS_X_Public_Data.html in the Comments section. Once you patch this it should build easily. However, right now the test suite does not work properly and once running, the mysqld cannot be stopped using mysqladmin or anything else short of a kill -KILL 'pid' . I'm told these problems are being worked on by people smarter than me :) Zach On Wednesday, May 16, 2001, at 08:36 AM, Robert Goeres wrote: I am looking for MySQL for Apple's Mac OS X (10.0.3). Up to now I have only found some old versions for Mac OS X Server or OS X Beta Any tips or hints? Regards Robert Goeres - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Mac OS X (10.0)
On 3/29/01 7:29 AM, "Tim Bauer" [EMAIL PROTECTED] wrote: Dear Friends, Sorry for the stupid question, but are any of the distributions available out there for the newly released Mac OS X. I see two on MySQL download pages: MacOS X Server (PowerPC) [apple-rhapsody5.5-powerpc] 3.23.27 - MacOS X (PowerPC) [beta-apple-darwin1.2-powerpc] Will either of these work? Also, does anyone know of other plans to update/port the current release?? I'm VERY eager to find an industrial strengh DB engine for Mac OS X and have several friends use MySQL on Windoze and other Unix?? thanks for your time, Tim Bauer You can download the source files for any of the versions above 3.23.27 (I think) and compile them yourself. Install the developer tools from the source CD that came with X. Download the source for MySQL Unpack the package You will have to edit 1 file to make it compile on OS X From a a post by Paul Dubois: I installed Mac OS X on my iBook today and configured MySQL 3.23.24a using exactly the same configure command. It proceeded without incident. There was a problem compiling sql/mysqld.cc at line 1232: sa.sa_handler=( void (*)() ) handle_segfault; This has to be changed to: sa.sa_handler=( void (*)(int) ) handle_segfault; ^^^ Then the compile finished with no problems. From last Saturday http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:69436:200103:joidfilkihmmclll koel Now, if someone can just convince the daemon to shutdown when asked nicely... ;) - 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 for Mac OS X Beta
I would like to know where I can get the MySQL build for Mac OS X Beta? Or, if anyone has built it from the source? Thanks, Manoj - 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 for Mac OS X Beta
I would like to know where I can get the MySQL build for Mac OS X Beta? Or, if anyone has built it from the source? Thanks, Manoj Manoj, You can get a binary installation here: http://homepage.mac.com/LightyearDesign/MacOSX/ . I'm using it and it's working just fine. Now if only I could get DBI and DBD working under X... Dunc. - 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 and Mac OS X Server
Hello all - I'm a new mySQL user and am interested to know if anyone has successfully installed mySQL in the Mac OS X Server environment - if so, is there a precompiled binary or install instructions for the platform? Thanks and sorry for the newbie question. Doug -- Doug Dockery [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php