http://diymacserver.com/forum/ DIYMacServer » Forum: MySQL - Recent Posts en Wed, 08 Feb 2012 06:01:15 +0000 http://diymacserver.com/forum/topic/mysql-558-install-confusion#post-911 Thu, 20 Jan 2011 05:00:10 +0000 Richard 911@http://diymacserver.com/forum/ <p>Zelda, please use an editor like vi to change it. The .swp file and the strange characters are usually left there by your editor.</p> <p>Please read <a href="http://diymacserver.com/2011/01/08/first-attempt-at-using-mysql-5-5-x/" rel="nofollow">http://diymacserver.com/2011/01/08/first-attempt-at-using-mysql-5-5-x/</a> as well indicating all the effects of using 5.5.x has on the rest of the installation instructions. </p> http://diymacserver.com/forum/topic/mysql-558-install-confusion#post-910 Wed, 19 Jan 2011 16:15:50 +0000 zelda 910@http://diymacserver.com/forum/ <p>Sorry it did not like the weird characters inside the .bash_profile.swp file so i zapped the gremlins and will try again:</p> <blockquote><p>b0VIM 7.2Smy-iMac.local~my/.bash_profile<br /> U3210#"! Utpad"export PATH="$PATH:/usr/local/mysql/bin"</p></blockquote> http://diymacserver.com/forum/topic/mysql-558-install-confusion#post-909 Wed, 19 Jan 2011 16:12:22 +0000 zelda 909@http://diymacserver.com/forum/ <p>I am having trouble getting the newest version of MySql-5.5.8 to startup on my Snow Leopard, 64-bit Intel arch., iMac and am wondering if i screwed-up the installation process or did not follow direction right:<br /> I downloaded the MacOSX dmg package mysql-5.5.8-osx10.6-x86_64.dmg<br /> and ran the installer, but did not install the Preference Pane as instructed in documentation.</p> <p>However, here's where i get confused you recently stated that,<br /> <blockquote>you no longer need to compile MySQL. Which is excellent news as it simplifies the setup and a lot of the problems I see here from users.</p></blockquote> <p>So installed MySQL but do i now skip your "Compiling MySQL 5.1.x in 64 bits mode on Snow Leopard" instructions in the documentation?</p> <p>I created the .bash_profile file and placed it in my home directory to be able to use MySQL commands from the Terminal but now something called .bash_profile.swp as showed up there too and seems to be messing something up as i cannot access MySQL from the Terminal saying it<br /> <blockquote>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)</blockquote> Looking inside this .swp file reveals:</p> <blockquote><p>b0VIM 7.2</p></blockquote> http://diymacserver.com/forum/topic/documentation-link#post-900 Tue, 16 Nov 2010 18:23:04 +0000 Richard 900@http://diymacserver.com/forum/ <p>Thank you Larry, I will amend that! </p> http://diymacserver.com/forum/topic/documentation-link#post-899 Tue, 16 Nov 2010 17:11:17 +0000 LarryL 899@http://diymacserver.com/forum/ <p>Richard, just a small discrepancy in documentation. Both the Leopard and Snow Leopard pages for Securing Your MySQL Install link to the Compiling Apache page and skip the Starting MySQL page. </p> http://diymacserver.com/forum/topic/no-readlinerlstdch-file-error-while-compiling-mysql-5142#post-783 Wed, 24 Feb 2010 23:50:00 +0000 aurora72 783@http://diymacserver.com/forum/ <p>Well I have to use 5.1.42 version because of the compatibility reasons. </p> <p>I had downloaded it at <a href="http://downloads.mysql.com/archives.php?p=mysql-5.1&#38;o=other">MySQL.com archives</a> as .tar.gz file and upon your remark I have re-downloaded it, this time as .zip file and after that, it compiled perfectly at the make stage. </p> <p>Clearly enough, it was a corrupted source file as you have guessed.</p> <p>Thanks! </p> http://diymacserver.com/forum/topic/no-readlinerlstdch-file-error-while-compiling-mysql-5142#post-782 Wed, 24 Feb 2010 19:24:35 +0000 Richard 782@http://diymacserver.com/forum/ <p>I'm sorry but I've never seen this error before on any of the systems I installed? Recenlty tested 5.1.44 without any problem. Are you sure you've got the correct sourcefile? </p> http://diymacserver.com/forum/topic/no-readlinerlstdch-file-error-while-compiling-mysql-5142#post-781 Wed, 24 Feb 2010 10:51:31 +0000 aurora72 781@http://diymacserver.com/forum/ <p>I've posted a little <a href="http://diymacserver.com/installing-mysql/compiling-mysql-51x-in-64-bits-mode-on-leopard/"> problem here</a> as a comment. Here is the problem:</p> <p>I try to compile MySQL 5.1.42 using the configuration options provided for Intel. The configuration works fine but at the make stage, it gives the following error:</p> <p>xmalloc.h:29:31: error: readline/rlstdc.h: No such file or directory</p> <p>My system: MAC OS X 10.5.8 XCode 3.1 1.83GHz Intel Core 2 Duo.</p> <p>Any suggestions?<br /> Thanks. </p> http://diymacserver.com/forum/topic/mysql-port-listed-as-0#post-609 Wed, 31 Dec 2008 09:35:30 +0000 Richard 609@http://diymacserver.com/forum/ <p>If you did follow the security guidelines with skip-networking the port won't work. The safest solution to connect is using the socket option for all connections. This works with dspam and sqlgrey as I set it up myself. However this is still a stange error.</p> <p>To make sure your my.cnf is used, make some changes that you would note there and restart mysql to see if the changes are reflected in the running mysql.</p> <p>I found several times that errors where related to mysql server not running while I thought it was. </p> http://diymacserver.com/forum/topic/mysql-port-listed-as-0#post-606 Sun, 28 Dec 2008 00:24:53 +0000 dw 606@http://diymacserver.com/forum/ <p>Hi all,</p> <p>Still trying to get everything up and running on Leopard. Resolved at least 1 strange issue which I'll report on after I make sure everything works. </p> <p>I am continuing to have a problem with tools like dspam and sqlgrey connecting to mysql. With a lot of retrying and searching, the one thing I've come across that seems strange is that when I enter mysql_config, it tells me the following:</p> <p><code><br /> --cflags [-I/usr/local/mysql/include/mysql -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT]<br /> --include [-I/usr/local/mysql/include/mysql]<br /> --libs [-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lm]<br /> --libs_r [-L/usr/local/mysql/lib/mysql -lmysqlclient_r -lz -lm]<br /> --socket [/tmp/mysql.sock]<br /> --port [0]<br /> --version [5.0.67]<br /> --libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld -lz -lm]<br /> </code></p> <p>What's strange is that the port is listed as 0, although in my.cnf the port is declared as 3306.</p> <p>I'll keep googling, but if anyone has an idea, please let me know.</p> <p>Dave </p> http://diymacserver.com/forum/topic/mysql-on-105-ppc#post-558 Wed, 10 Sep 2008 20:06:32 +0000 Richard 558@http://diymacserver.com/forum/ <p>Jeff, I haven't tried it, but the tar packages don't come with an installer. It's basically a tar of the mysql dir. I would advise to install the 10.4 version and compile from the source over that install. </p> http://diymacserver.com/forum/topic/mysql-on-105-ppc#post-557 Wed, 10 Sep 2008 19:56:11 +0000 jstubbs 557@http://diymacserver.com/forum/ <p>There are two different versions of 5.0.67 mysql available on the download site. One is the usual dmg file for 10.5, but seems to be intel only. The other is a tar'd package for 10.5 ppc. </p> <p>What puzzled me for a second is that there is no dmg for 10.5 ppc machines. Poking around in the forums, there's a post that the 10.4 ppc dmg file is appropriate for a 10.5 ppc machine. Any one have experience with one or the other?</p> <p>Jeff </p> http://diymacserver.com/forum/topic/still-need-to-recompile-mysql#post-555 Tue, 09 Sep 2008 14:18:44 +0000 Richard 555@http://diymacserver.com/forum/ <p>Jeff, yes somehow there are still issues when using php. Don't know exactly what they were but compiling is simple. Sorry to hear about the G3. </p> http://diymacserver.com/forum/topic/still-need-to-recompile-mysql#post-554 Mon, 08 Sep 2008 18:25:23 +0000 jstubbs 554@http://diymacserver.com/forum/ <p>Richard,</p> <p>My old G3 finally gave the ghost. Got my hands on a G4, installed 10.5, downloaded the 5.0.67 ppc package (32 bit) of mysql. I unpacked it and was poking around. I noticed that there are shared libraries inside of lib. Still need to recompile the source code?</p> <p>Jeff </p> http://diymacserver.com/forum/topic/database-doesnt-start#post-530 Thu, 14 Aug 2008 12:21:00 +0000 mastertk 530@http://diymacserver.com/forum/ <p>Ok Thanks<br /> I think now I know how to solve the problem.<br /> I'll Post it when it works. </p> http://diymacserver.com/forum/topic/database-doesnt-start#post-529 Wed, 13 Aug 2008 20:10:39 +0000 Richard 529@http://diymacserver.com/forum/ <p>Normally your connection is configured in your php.ini but the configuration may be overwritten by your webshop applicaiton. Please compare the connection settings between phpmyadmin and your webshop application. It is possible to use socket and ports to connect. If you use my security advise the port option is closed of.</p> <p>You could use the same password, but I think it is best to have a separate user/password for each database for security purposes. </p> http://diymacserver.com/forum/topic/database-doesnt-start#post-528 Wed, 13 Aug 2008 09:36:53 +0000 mastertk 528@http://diymacserver.com/forum/ <p>Oke but the webshop says it can't connect trough a certain socket but why can phpmyadmin access trough the socket and the webshop doesn't.<br /> And the password and user that I need to use are those the same as the password and user I need to open HTTP://Localhost/phpmyadmin/ ? </p> http://diymacserver.com/forum/topic/database-doesnt-start#post-527 Wed, 13 Aug 2008 07:01:25 +0000 Richard 527@http://diymacserver.com/forum/ <p>Thomas, why do you think it isn't started ? If you can access it by using phpmyadmin you should be able to connect to it from your webshop. You should only see a mysqld process running. Please make sure you connect to it with the correct user and password and that access has been granted. </p> http://diymacserver.com/forum/topic/database-doesnt-start#post-526 Mon, 11 Aug 2008 20:35:03 +0000 mastertk 526@http://diymacserver.com/forum/ <p>I need to create a database for a webshop.<br /> I created one in phpmyadmin but it doesn't show up in the process list and I don't know how to start it.<br /> Maybe someone can give me some advise.<br /> Greetings Thomas </p> http://diymacserver.com/forum/topic/mysql-recompile-problems#post-507 Sat, 12 Jul 2008 07:22:23 +0000 Richard 507@http://diymacserver.com/forum/ <p>David, please install the XCode developer tools from your OS X install DVD or download them from <a href="http://developer.apple.com" rel="nofollow">http://developer.apple.com</a> </p> http://diymacserver.com/forum/topic/mysql-recompile-problems#post-505 Fri, 11 Jul 2008 20:42:45 +0000 davidsparty 505@http://diymacserver.com/forum/ <p>first time installer using these great directions! </p> <p>when I try to compile i get</p> <p>"no acceptable C compiler found in $PATH" </p> http://diymacserver.com/forum/topic/configureerror-mysql-5037#post-346 Tue, 03 Apr 2007 01:00:28 +0000 PeterZwarich 346@http://diymacserver.com/forum/ <p>I'm a boner . . . I was simply leaving out the "--" at the beginning of each line. It is now compiling.</p> <p>cheers,<br /> peter </p> http://diymacserver.com/forum/topic/configureerror-mysql-5037#post-345 Mon, 02 Apr 2007 19:33:31 +0000 PeterZwarich 345@http://diymacserver.com/forum/ <p>Hi - I am working on the compilation instructions for MySQL.<br /> after entering:<br /> without-bench<br /> I get this message:<br /> configure: error: invalid variable name: with-server-suffix</p> <p>I downloaded mysql-5.0.37.</p> <p>peter </p> http://diymacserver.com/forum/topic/mysql-recompile-problems#post-325 Thu, 22 Feb 2007 22:34:11 +0000 eulipion2 325@http://diymacserver.com/forum/ <p>It's in the mail! </p> http://diymacserver.com/forum/topic/mysql-recompile-problems#post-324 Thu, 22 Feb 2007 15:36:50 +0000 Richard 324@http://diymacserver.com/forum/ <p>Yes, it really looks awfull. Could you send the output and the config.log file to my gmail account: diymacserver at gmail.com ! This is difficult to read.</p> <p>Yes, you should run the ./configure command, the make and make install command from the 5.0.33 source dir. </p>