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
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
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
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
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
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
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
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
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