Re: MySQL on Mac OS 10.8

2013-04-17 Thread Reindl Harald
at running on MacOS. I googled and >>> didn't find anything. I posted to a mac forum, but haven't received >>> any responses yet. I'll have to try SO >> >> you need to modify the StartupItem to create the directory >> before starting mysq

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Kapil Karekar
AM, Reindl Harald >>> wrote: >>>> Am 16.04.2013 18:34, schrieb Larry Martell: >>>>> I just set up mysql on Mac OS 10.8. Each time after the machine is >>>>> rebooted the server fails to start with: >>>>> >>>>> 2013-

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Larry Martell
On Wed, Apr 17, 2013 at 8:32 AM, Reindl Harald wrote: > > > Am 17.04.2013 15:32, schrieb Larry Martell: >> On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald >> wrote: >>> Am 16.04.2013 18:34, schrieb Larry Martell: >>>> I just set up mysql on M

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Reindl Harald
Am 17.04.2013 15:32, schrieb Larry Martell: > On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald > wrote: >> Am 16.04.2013 18:34, schrieb Larry Martell: >>> I just set up mysql on Mac OS 10.8. Each time after the machine is >>> rebooted the server fails to start wit

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Larry Martell
On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald wrote: > Am 16.04.2013 18:34, schrieb Larry Martell: >> I just set up mysql on Mac OS 10.8. Each time after the machine is >> rebooted the server fails to start with: >> >> 2013-04-13 14:09:54 1 [ERROR] /usr/lo

Re: MySQL on Mac OS 10.8

2013-04-16 Thread Reindl Harald
Am 16.04.2013 18:34, schrieb Larry Martell: > I just set up mysql on Mac OS 10.8. Each time after the machine is > rebooted the server fails to start with: > > 2013-04-13 14:09:54 1 [ERROR] /usr/local/mysql/bin/mysqld: Can't > create/write to file '/var/run/mysqld/mys

Re: MySQL on Mac OS 10.8

2013-04-16 Thread Larry Martell
time it turn out to be Time > Machine. Ask around on those lists. I'm not running time machine on this box. I realize it's Mac specific, I just thought someone here might have experienced and solved this. Thanks for the reply. > On Tue, Apr 16, 2013 at 12:34 PM, Larry Martell >

Re: MySQL on Mac OS 10.8

2013-04-16 Thread Michael Dykman
3 at 12:34 PM, Larry Martell wrote: > I just set up mysql on Mac OS 10.8. Each time after the machine is > rebooted the server fails to start with: > > 2013-04-13 14:09:54 1 [ERROR] /usr/local/mysql/bin/mysqld: Can't > create/write to file '/var/run/mysqld/mysqld.p

Re: manage mysql-bin.xxxxxx files on mac

2012-08-03 Thread Rik Wasmus
> (1) What server fail to start, it always says that missing mysql.sock I seem to remember some distro's switching over from mysql.sock so mysqld.sock... is that mysqld.sock there after restart? If so, just update your "socket" configuration accordingly / make it consistent. -- Rik Wasmus --

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Elim Qiu
Thanks a lot to all helped me out. Really appreciated. Rik Wasmus, Thanks for the Binary Log Documentation http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html#sysvar_max_binlog_size Rick James, I'll try this: expire_logs_days=7 Vikas Shukla, My server-id is 1 (thought that

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Vikas Shukla
Hi ,, It would be helpful if you could share the error messages. Do any of these: 1) Add these lines to my.cnf file: expire_logs_days = 7 2) Or Try this log-bin=OFF or simply u can comment the lines related to the log-bin. 3) Other than this, if you are using se

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rik Wasmus
Hm, due to some popups that was a premature sending... Mea culpa > > I don't really know how to use those files and so like to know how to > > stop populating them. or at least control the number and size of them. > > Used for: disaster recovery / replay modifications on backup, or > replication

RE: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rick James
2 9:56 AM > To: mysql@lists.mysql.com > Subject: manage mysql-bin.xxxxxx files on mac > > I don't really know how to use those files and so like to know how to > stop populating them. or at least control the number and size of them. > > I'm running os x 10.6.8

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rik Wasmus
> I don't really know how to use those files and so like to know how to > stop populating them. or at least control the number and size of them. Used for: disaster recovery / replay modifications on backup, or replication afaik. Days kept: expire_log_days: http://dev.mysql.com/doc/refman/5.5/en

manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Elim Qiu
I don't really know how to use those files and so like to know how to stop populating them. or at least control the number and size of them. I'm running os x 10.6.8, mysql Server version: 5.1.61-log MySQL Community Server (GPL) I tried comment out the line "log-bin=mysql-bin" and those mysql-bin.

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-08 Thread Johan De Meersman
- Original Message - > From: "Stan Iverson" > Yes, it's a binary file; however, MySQL Connector for ODBC only works > in Windows and I'm using a Mac. If no other solutions, will try > tomorrow on a friend's PC. If it's binary, you're gonn

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-06 Thread Shawn Green (MySQL)
Hello Stan, On 2/3/2012 20:06, Stan Iverson wrote: On Fri, Feb 3, 2012 at 11:11 AM, Johan De Meersmanwrote: - Original Message - From: "Stan Iverson" I have a Mac and a Linux server and I need to read the table schema for a database dump from MSSQL. Possible? How? Heeh.

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-03 Thread Stan Iverson
On Fri, Feb 3, 2012 at 11:11 AM, Johan De Meersman wrote: > - Original Message - > > From: "Stan Iverson" > > > > I have a Mac and a Linux server and I need to read the table schema > > for a database dump from MSSQL. Possible? How? > > Heeh.

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-03 Thread Johan De Meersman
- Original Message - > From: "Stan Iverson" > > I have a Mac and a Linux server and I need to read the table schema > for a database dump from MSSQL. Possible? How? Heeh. If you're talking about an SQL dump into a textfile, that should be doable - you m

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-03 Thread Wendell Turner
"There is a profound difference between doing things right and doing the right things." - On 3 Feb 2012, at 02:20 PM, Stan Iverson wrote: > > > On Fri, Feb 3, 2012 at 10:01 AM, Wendell Turner wrote: > Hi. > > On a Mac, you could use... > * Sequ

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-03 Thread Stan Iverson
On Fri, Feb 3, 2012 at 10:01 AM, Wendell Turner wrote: > Hi. > > On a Mac, you could use... > * SequelPro <http://www.sequelpro.com/> > It appears one has to have a database up and running to open the backup. I can get MySQL running, but, again, the backup is of a MSSQL d

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-03 Thread Wendell Turner
Hi. On a Mac, you could use... * SequelPro <http://www.sequelpro.com/> or one of the Navicat products... <http://www.navicat.com/en/download/download.html> HTH. Wendell Turner p:= +44(0)777 164 6532 e: wendel...@gmail.com "Th

Re: Problem installing python MySQLdb on Mac OS X Version 10.5.8

2012-01-09 Thread Larry Martell
On Mon, Jan 9, 2012 at 2:21 PM, Larry Martell wrote: > Some may consider this slightly off-topic, but I'm out of places to > turn to, so I'm hoping someone here can help me. > > > I am having no luck with getting the python module MySQLdb to work on > my Mac. I a

Problem installing python MySQLdb on Mac OS X Version 10.5.8

2012-01-09 Thread Larry Martell
Some may consider this slightly off-topic, but I'm out of places to turn to, so I'm hoping someone here can help me. I am having no luck with getting the python module MySQLdb to work on my Mac. I am getting the dreaded 'wrong architecture' message when I try to import the mo

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
Roger, 2 mins. of Google turned up these (just f.y.i.): http://www.cyberciti.biz/faq/mysql-change-root-password/ http://www.cyberciti.biz/tips/recover-mysql-root-password.html -G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
>> >>> ...as Brandon said.. from terminal you have to type something to get into >>> mysql, and if you are like me, then that is: >>> >>> /usr/local/mysql/bin/mysql >> >> Oh, I forgot to add - but you might need to be super user first. >> >> su >> (input pass..) > > why in the world should s

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Reindl Harald
Am 06.11.2011 02:00, schrieb Govinda: > >> ...as Brandon said.. from terminal you have to type something to get into >> mysql, and if you are like me, then that is: >> >> /usr/local/mysql/bin/mysql > > Oh, I forgot to add - but you might need to be super user first. > > su > (input pass..)

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
> ...as Brandon said.. from terminal you have to type something to get into > mysql, and if you are like me, then that is: > > /usr/local/mysql/bin/mysql Oh, I forgot to add - but you might need to be super user first. su (input pass..) > > -Govinda > >> I installed Mysql using the .dmg pa

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
...as Brandon said.. from terminal you have to type something to get into mysql, and if you are like me, then that is: /usr/local/mysql/bin/mysql -Govinda > I installed Mysql using the .dmg package. I can use System Preferences to > start and stop the program. When I open a terminal window,

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Brandon Phelps
On 11/5/2011 12:32 PM, Roger CPL wrote: I installed Mysql using the .dmg package. I can use System Preferences to start and stop the program. When I open a terminal window, I think this is the way to us the program, any Mysql command I inter is not recognized. Thanks Roger You will need to

New-be: problem installing on Mac SO10.6

2011-11-05 Thread Roger CPL
I installed Mysql using the .dmg package. I can use System Preferences to start and stop the program. When I open a terminal window, I think this is the way to us the program, any Mysql command I inter is not recognized. Thanks Roger -- MySQL General Mailing List For list archives: http://list

Re: Initial install instructions for mac lion/macports

2011-10-11 Thread Tim Johnson
* Brandon Phelps [111011 07:43]: > Tim, > Just a reminder, as I am not sure if it is documented or not; > After you get MySQL up and running via the DMG package be sure to > install the System Preferences pane (it didn't use to install by > default, not sure if it does now) which should be one o

Re: Initial install instructions for mac lion/macports

2011-10-11 Thread Brandon Phelps
lling mysql on a mac mini, with the Lion - osx 10.7 operating system. mysql-server was downloaded and built with macports. Following instructions included has not resulted in a successful startup. :) Last night before turning in, I thought that maybe I should have investigated the DMG option.

Re: Initial install instructions for mac lion/macports

2011-10-11 Thread Tim Johnson
* Tim Johnson [111010 15:37]: > I familiar with mysql on linux, as of late - ubuntu. > I am installing mysql on a mac mini, with the Lion - osx 10.7 > operating system. > > mysql-server was downloaded and built with macports. > Following instructions included has not result

Re: Initial install instructions for mac lion/macports

2011-10-11 Thread Brandon Phelps
as of late - ubuntu. I am installing mysql on a mac mini, with the Lion - osx 10.7 operating system. mysql-server was downloaded and built with macports. Following instructions included has not resulted in a successful startup. I have recorded error messages, but it may suffice if I were pointed to i

Re: Initial install instructions for mac lion/macports

2011-10-11 Thread Vladislav Geller
; > On 10/10/2011 07:34 PM, Tim Johnson wrote: > >> I familiar with mysql on linux, as of late - ubuntu. >> I am installing mysql on a mac mini, with the Lion - osx 10.7 >> operating system. >> >> mysql-server was downloaded and built with macports. >> Follo

Re: Initial install instructions for mac lion/macports

2011-10-11 Thread Brandon Phelps
familiar with mysql on linux, as of late - ubuntu. I am installing mysql on a mac mini, with the Lion - osx 10.7 operating system. mysql-server was downloaded and built with macports. Following instructions included has not resulted in a successful startup. I have recorded error messages, but it

Initial install instructions for mac lion/macports

2011-10-10 Thread Tim Johnson
I familiar with mysql on linux, as of late - ubuntu. I am installing mysql on a mac mini, with the Lion - osx 10.7 operating system. mysql-server was downloaded and built with macports. Following instructions included has not resulted in a successful startup. I have recorded error messages, but

Re: Build from bazaar source on Mac 10.7 (Lion) fails

2011-09-03 Thread Derek Downey
gt; internal code of the MySQL DB. I'm off to a great start, since I can't even >> get it to build properly... >> >> My machine is: >> >> $ uname -a >> Darwin DDMac 11.1.0 Darwin Kernel Version 11.1.0: Tue Jul 26 16:07:11 PDT >> 2011; root

Re: Build from bazaar source on Mac 10.7 (Lion) fails

2011-09-03 Thread Jan Steinman
arwin DDMac 11.1.0 Darwin Kernel Version 11.1.0: Tue Jul 26 16:07:11 PDT > 2011; root:xnu-1699.22.81~1/RELEASE_X86_64 x86_64 Since you're on a Mac, have you considered using MacPorts? MySQL builds and installs flawlessly on 10.6.8 with "sudo port -f install mysql5" here. (Ha

Build from bazaar source on Mac 10.7 (Lion) fails

2011-09-02 Thread Derek Downey
Hello, I am trying to setup a development machine to start delving into some of the internal code of the MySQL DB. I'm off to a great start, since I can't even get it to build properly. I'm sure I'm missing an important step, but am following the instructions from http://dev.mysql.com/doc/ref

Re: Import from Quicken 2004 Mac?

2011-08-12 Thread Chris Elhardt
tform. -Original Message- From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Thursday, August 11, 2011 2:37 PM To: David Brian Chait Cc: mysql@lists.mysql.com Subject: Re: Import from Quicken 2004 Mac? On 11 Aug 11, at 14:17, David Brian Chait wrote: The QIF file includes a lot of data aside

Re: Import from Quicken 2004 Mac?

2011-08-12 Thread Hal�sz S�ndor
>>>> 2011/08/11 14:14 -0700, Jan Steinman >>>> QB 2010 Mac appears to only export ".IIF" format, which appears to be a variant of the older ".QIF" format, and Google didn't turn up really anything for getting IIF/QIF files into MySQL. The best

RE: Import from Quicken 2004 Mac?

2011-08-11 Thread David Brian Chait
ather than trying to move it around from platform to platform. -Original Message- From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Thursday, August 11, 2011 2:37 PM To: David Brian Chait Cc: mysql@lists.mysql.com Subject: Re: Import from Quicken 2004 Mac? On 11 Aug 11, at 14:17, David

Re: Import from Quicken 2004 Mac?

2011-08-11 Thread Jan Steinman
accounts (in Quick Books) with project management (in MySQL). > From: Jan Steinman [mailto:j...@bytesmiths.com] > Sent: Thursday, August 11, 2011 2:15 PM > To: mysql@lists.mysql.com > Subject: Import from Quicken 2004 Mac? > > I'm looking for ways to import QuickBooks 2010

RE: Import from Quicken 2004 Mac?

2011-08-11 Thread David Brian Chait
: mysql@lists.mysql.com Subject: Import from Quicken 2004 Mac? I'm looking for ways to import QuickBooks 2010 Mac. I've only just started researching this, so feel free to "RTFM" me -- with a proper reference, of course! I'll be wanting to set up a process to do this pe

Import from Quicken 2004 Mac?

2011-08-11 Thread Jan Steinman
I'm looking for ways to import QuickBooks 2010 Mac. I've only just started researching this, so feel free to "RTFM" me -- with a proper reference, of course! I'll be wanting to set up a process to do this periodically (and hopefully, automagically) for new transactions

Re: MySQL v5.5.12 on Mac OSX - Server won't start...

2011-05-14 Thread Reindl Harald
Am 14.05.2011 17:32, schrieb rich gray: > I have installed MySQL v5.5.12 Community Server on Mac OS X v10.5.8 > > When I try and start the server I get these messages before it aborts... > > 110514 17:16:14 mysqld_safe Starting mysqld daemon with databases from > /us

MySQL v5.5.12 on Mac OSX - Server won't start...

2011-05-14 Thread rich gray
I have installed MySQL v5.5.12 Community Server on Mac OS X v10.5.8 When I try and start the server I get these messages before it aborts... 110514 17:16:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110514 17:16:16 [Warning] The syntax '--log-slow-querie

Re: max allowed packets on Mac

2010-12-21 Thread Sharl
, but I think you need to >> assume root. As your mac admin user, try >> $ sudo su - >> and give your admin password when asked. You should now be root and >> can expect permissions to behave as you would expect. >> >> - michael dykman >> >> On Fri,

Re: max allowed packets on Mac

2010-12-21 Thread 杨涛涛
I agree with michael dykman. 杨涛 我博客1:http://yueliangdao0608.cublog.cn My 我博客2:http://yueliangdao0608.blog.51cto.com 2010/12/18 Michael Dykman > I'm not nuts about deploying MySQL on macs, but I think you need to > assume root. As your mac admin user, try > $ sudo su - > an

Re: max allowed packets on Mac

2010-12-17 Thread Michael Dykman
I'm not nuts about deploying MySQL on macs, but I think you need to assume root. As your mac admin user, try $ sudo su - and give your admin password when asked. You should now be root and can expect permissions to behave as you would expect. - michael dykman On Fri, Dec 17, 2010 at 12:

max allowed packets on Mac

2010-12-17 Thread g...@noiseunit.com
Hi, I found this page on the wiki regarding max allowed packets. http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html However, on my Mac OSX when I try to run the following from terminal window I get "Permission Denied" shell> mysqld --max_allowed_packet=16M And if I

MySQL 5.1 does not work on Mac OS X 10.5 Leopard and Power PC

2010-01-05 Thread Moishe Weiss
I would like to note to the MySQL development team that there is no download available for MySQL 5 Community Edition for a Mac Power PC and OS X 10.5. There is a MySQL 4/PPC/OSX 10.4 download and there is a MySQL 5/Intel/OSX 10.5 download. I tried the MySQL 5.1 /x86-64/OSX 10.5 download and

Re: MySQL 5.4 Support for Mac OS X 10.6.x ?

2009-12-02 Thread Steve Pincaud
files installed at /usr/local/mysql-5.4.3-beta-osx10.5-x86_64/ and a link /usr/local/mysql has been created pointing to /usr/local/mysql-5.4.3-beta-osx10.5-x86_64/ I then tried to create environment variables following the here under docs : http://developer.apple.com/mac/library/qa/qa2001/qa1255

MySQL 5.4 Support for Mac OS X 10.6.x ?

2009-11-29 Thread Steve Pincaud
Hello, I have a Mac Book Pro (64 bits x86) running with Snow Leopard aka Mac OS X 10.6.2, I have read the here under pages and my conclusion is that MySQL currently does not support Mac OS X 10.6.x, so my question is: is there any plan in the roadmap to support it ? and if so what would be the

MySQL 5.1.41 compatible with Mac OS X Server 10.6?

2009-11-23 Thread René Fournier
Hi, I've installed MySQL 5.1.41 x86_64 on fresh install of Mac OS X Server 10.6.2 (where the bundled version is 5.0.82. Just a couple questions: 1. Have any of your encountered compatibility issues with MySQL 5.1.x on Mac OS X Server 10.6.2? (Since I am in the process of migrating se

RE: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Gavin Towey
30 PM To: Gavin Towey Cc: mysql@lists.mysql.com Subject: Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 Here is the error I am receiving ( I posted this issue in the recent past): dyld: lazy symbol binding failed: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwi

Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Hagen Finley
1:58 AM > To: mysql@lists.mysql.com > Cc: finha...@comcast.net > Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 > > After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get > my DBD:mysql module to work. I am kind of beyond trying

RE: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Gavin Towey
t.net Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible

Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Hagen
After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work. Between various releases and 32/64 b

MAC OS 10.6 Snow Leopard Breaks MySQL - Resolved

2009-09-05 Thread Hagen
I tried creating a soft link to the /usr/local/bin/mysql but that didn't address the issues I was having. However, following a little more research I found a discussion of this problem at: http://stackoverflow.com/questions/1334272/cant-start-mysql-in-mac-os-10-6-s now-leopard which said:

RE: MAC OS 10.6 Snow Leopard Breaks MySQL

2009-09-04 Thread Hagen
-What's the best way to inform MySQL the direct structure changed? -Is there a 5.4 version for MAC OS 10.6? -Would it make sense to reinstall with that version? (my data base is tiny and its relatively easy to export and import it and I am the only user) Hagen -Original M

MAC OS 10.6 Snow Leopard Breaks MySQL

2009-09-04 Thread Hagen
I upgraded to MAC OS 10.6 Snow Leopard over the weekend and now I find that upgrade appears to have broken MySQL (5.1.31 MySQL Community Server (GPL)). When I attempt to start MySQL I get: ERROR 2002: (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock (2)

How to start / stop mySQL with NetBeans 6.7 under Apple MAC OS X 10.5 LEOPARD ?

2009-06-25 Thread Jacques PIOTROWSKI
>Description: In the tab "services", item "databases", choice "mySQL server at localhost", right click, "admin properties" tab of window "mySQl server properties" Path to start command "/usr/local/mysql/support-files/mysql.server" with argument "start" : don't work Path to stop com

Re: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Gavin Towey
"I've run up on the rock of a binary (meaning: indecipherable) field." SELECT hex(some_binary_field) FROM table; Solved. The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of

RE: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Gavin Towey
A MAC address is just a number, it doesn't contain letters unless you're doing something silly like storing the HEX representation of it. Do not use CHAR! This does DOUBLE for all of you storing IP addresses! Since a MAC address is going to be between 48 and 64 bits, then

RE: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Daevid Vincent
@access public * @paramstring $ip * @return string * @since4.2.6 * @date 10/05/2006 */ function wildcardIP2CIDR( $ip ) { $result = ""; if ( isValidWildcardIP( $ip ) ) { $parts = explode( ".", $ip );

Re: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Pete Wilson
I agree, and didn't mean to say that I disagreed. This is certainly one of the top five principles to follow, imo. Too many times, while trouble-shooting, I've run up on the rock of a binary (meaning: indecipherable) field. What is the cost of including the binary representation (for indexing)

Re: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Jim Lyons
r the OP's question, but: > > MAC addresses do not by design contain letters. Native MAC addresses are > 48-bit (6-byte) integers: > > http://standards.ieee.org/getieee802/download/802-2001.pdf > > The confusion arises because a MAC address is usually /represented/ as &

Re: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Pete Wilson
I'm new to MySQL so can't answer the OP's question, but: MAC addresses do not by design contain letters. Native MAC addresses are 48-bit (6-byte) integers: http://standards.ieee.org/getieee802/download/802-2001.pdf The confusion arises because a MAC address is usually /

Re: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Jim Lyons
Definitely CHAR (or VARCHAR). If the format of a MAC address changes at all, you could be in real trouble. Also, if a MAC address can have a leading 0 (I don't know anything about MAC addresses), then storing it as some sort of number could lose that. This is a general rule for me. A

Re: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Thomas Spahni
On Thu, 14 May 2009, Ilia KATZ wrote: Hi. Currently I have a table: 1. MAC address defined as BIGINT 2. MAC address set as primary key Should I consider changing it to CHAR(12)? Replies will be appreciated. Ilia Hi It depends. You may convert the MAC address to a decimal integer and store

RE: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Ilia KATZ
6th byte the last 2 bytes (of the BIGINT) left unused. Ilia From: Fish Kungfu [mailto:fish.kun...@gmail.com] Sent: Thursday, May 14, 2009 3:54 PM To: Ilia KATZ Cc: mysql@lists.mysql.com Subject: Re: MAC address as primary key - BIGINT or CHAR(12

RE: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Jerry Schwartz
You might even want to plan for longer MAC addresses. I don't follow developments in that area, but they had to go from IP4 to IP6 and they might have to introduce longer MAC addresses. It isn't hard to change a MySQL field definition, but your applications would be more of

Re: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread kabel
On Thursday 14 May 2009 09:53:58 am Fish Kungfu wrote: > Since MAC addreses also contain letters, BIGINT wouldn't work. So, yes, I > would say go with CHAR(12). > > On May 14, 2009 9:43 AM, "Ilia KATZ" wrote: > > Hi. > Currently I have a table: > 1. MAC add

Re: MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Fish Kungfu
Since MAC addreses also contain letters, BIGINT wouldn't work. So, yes, I would say go with CHAR(12). On May 14, 2009 9:43 AM, "Ilia KATZ" wrote: Hi. Currently I have a table: 1. MAC address defined as BIGINT 2. MAC address set as primary key Should I consider changin

MAC address as primary key - BIGINT or CHAR(12)

2009-05-14 Thread Ilia KATZ
Hi. Currently I have a table: 1. MAC address defined as BIGINT 2. MAC address set as primary key Should I consider changing it to CHAR(12)? Replies will be appreciated. Ilia

Re: Securing MySQL on Mac OSX

2009-03-11 Thread Tom Brown
It mentions that root in MySQL has nothing to do with the root of Mac OSX, but I need to know if MySQL being unprotected in this way has opened a door for hackers. it means that they can do whatever they want to the mysql db's without being prompted for a password. This does not

Securing MySQL on Mac OSX

2009-03-11 Thread Matthew Stuart
I am in the process of installing MySQL and PHP on my Mac following instruction in a book written by a chap called David Powers. I have come to a section that is called 'Securing MySQL on Mac OSX'. Basically it states that MySQL is up and running with a default account of '

Re: Newbie First Use Connection Question - Mac OSX 10.5.6

2009-02-19 Thread Curtis Maurand
or as the docs read: shell> mysqladmin password John Daisley wrote: The root Password will be blank after initial install. You can set it at a shell prompt with commands something like this... shell> mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); mysql> FLUS

Re: Newbie First Use Connection Question - Mac OSX 10.5.6

2009-02-19 Thread John Daisley
The root Password will be blank after initial install. You can set it at a shell prompt with commands something like this... shell> mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); mysql> FLUSH PRIVILEGES; mysql> EXIT; Where newpwd is your desired password. Best to

Newbie First Use Connection Question - Mac OSX 10.5.6

2009-02-19 Thread Jeff Murdock
I am brand new to MySQL and JAVA/Netbeans 6.5 so please excuse the stupid questions ... 1. I have just downloaded and successfully installed MySQL v5.1 on my MacBook Pro running OS X 10.5.6 2. I have also downloaded and installed MySQL Tools: Administrator & Query Browser (I come from

Re: unable to change root password on Mac OSX 10.5.2

2008-04-21 Thread Olga Lyashevska
Dear List, I have solved my problem I think. For some reasons 'alias mysql=/usr/local/mysql/bin/mysql' didnt work for me. When I type '/usr/local/mysql/bin/mysql -u root' I can log in as a root and change password. Later I can log in: '/usr/local/mysql/bin/mysql -u root -p' Thank you, Olga

Re: unable to change root password on Mac OSX 10.5.2

2008-04-21 Thread Warren Young
Olga Lyashevska wrote: e7253:mysql olichka$ /usr/local/mysql/bin/mysql Try: $ /usr/local/mysql/bin/mysql -u root -p It looks like you aren't logging into MySQL as root, so you don't have permission to set the root password. (If you don't give -u, it uses your OS X short user name a

unable to change root password on Mac OSX 10.5.2

2008-04-21 Thread Olga Lyashevska
Dear List, I have installed a binary package mysql-5.0.51a-osx10.5-x86_64.dmg I can start up/shutdown MySQL and connect to MySQL server, but I cant change a root password as required. ---begin example--- e7253:~ olichka$ cd /usr/local/mysql e7253:mysql olichka$ sudo ./bin/mysqld_safe Pass

Startup Item won't install on Mac OS X 10.5.2

2008-04-06 Thread Gabe da Silveira
I was having some problems with MySQL after restoring a new MacBook Pro from a Time Machine backup. I deleted /Library/StartupItems/MYSQLCOM and the corresponding package in /Library/Receipts, however I am unable to reinstall the Startup Item. I've tried both 10.5 packages and the Intel 10.4 packa

StartupItem not installing on Mac OS X 10.5

2008-03-31 Thread SA
Hello, About 3 months ago I purchased two Mac Mini systems to use as MySQL EDB servers (I might point out that I've been doing this for years with OS X 10.4/Tiger and it works really good). The newest Macs came with OS X 10.5 Leopard. I was not able to downgrade the OS to 10.4. At the

Install on Mac 10.4.10 is Rough

2008-03-06 Thread neale hirsh
>Description: It is my first install of MySQL 64 bit. The platform is Mac G4 under OS 10.4.10. My guide has been the included text file, INSTALL-BINARY whose instructions are referred to below. The instructions call for adding a user via ADDUSER, a FreeBSD command that nevertheless

Re: Newbie Q- Mac OSX install - login to mysql not working...

2007-12-13 Thread Rob Wultsch
ated root on this machine (I understand that > Apple, by default disables it), perhaps there's something I'm missing > in my lack of knowledge of the way the Mac OS uses root? > > I'm sure this is a stupid newbie issue, but I'm a bit wrapped around > the axle here

Newbie Q- Mac OSX install - login to mysql not working...

2007-12-13 Thread Al
ull admin privs, and I've tried everything to login, including no password, my account's password, etc. Since I've not activated root on this machine (I understand that Apple, by default disables it), perhaps there's something I'm missing in my lack of knowledge of the way the

Re: Mac OS X PowerPC 64 bit

2007-07-26 Thread Joerg Bruehe
Hi Jan Pieter, all ! I am sorry I reply so late, was too busy with other things till now. Jan Pieter Kunst wrote: Dear mysql-ers, It seems that the Mac OS X PowerPC 64 bit version of the MySQL Community server is no longer available. That was true in some versions, there were issues with

Re: Mac OS X PowerPC 64 bit

2007-07-25 Thread Kieran Kelleher
v.mysql.com/doc/refman/4.1/en/mysql-binaries.html Once you know what cryptic configuration command (cryptic for those of us who don't work with C++ anyway) to use for the target processor, compiling form source is a piece of cake. Here are my steps to compile on Mac (with SSL capability includ

Mac OS X PowerPC 64 bit

2007-07-11 Thread Jan Pieter Kunst
Dear mysql-ers, It seems that the Mac OS X PowerPC 64 bit version of the MySQL Community server is no longer available. Now I'm wondering which version I should use on a G5 PowerMac. PowerPC 32 bit or Universal? Thanks for any insights. Jan Pieter Kunst -- MySQL General Mailing List For

5.0.37 for Mac OS X 10.4 64 bit

2007-04-04 Thread Jan Pieter Kunst
Dear MySQL'ers, Any chance that MySQL for OS X 10.4 64 bit will be updated to 5.0.37? It's still at 5.0.27. Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database Connection Problem with MAMP (Mac)

2007-03-26 Thread David Blomstrom
I installed a preconfigured package called MAMP on my MacBook Pro and have just about everything working except my database connections. I can use phpMyAdmin to manipulate databases and tables, but I can't connect to those databases from Dreamweaver. I read somewhere that you have to use a spec

problem with starting mysql on mac osx 10.4

2006-11-08 Thread uszek
Hi, I constantly keep receiving this kind of error: mariuszlenks-ibook-g4:~ mariuszlenk$ cd /usr/local/mysql mariuszlenks-ibook-g4:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe Password: ./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file ./bin/mysqld_safe: line 1

Re: V 5.0.18 on Mac OS X

2006-11-08 Thread Dan Buettner
d upgrade. Dan On 11/8/06, Steffan A. Cline <[EMAIL PROTECTED]> wrote: I am having an issue with MySQL running on Mac OS X. Currently the version as stated 5.0.18 on a dual G4 Xserve with 1gb of ram. MySQL is mainly the only thing running on this server. I am trying to track down an is

V 5.0.18 on Mac OS X

2006-11-08 Thread Steffan A. Cline
I am having an issue with MySQL running on Mac OS X. Currently the version as stated 5.0.18 on a dual G4 Xserve with 1gb of ram. MySQL is mainly the only thing running on this server. I am trying to track down an issue in which MySQL is being overloaded and it consistently damages the same one or

Starting a Second Server under Mac OS X 10.3.9

2006-08-30 Thread cristopher pierson ewing
I'm trying to get a second server running using mysql 4.1.15 on Mac OS X 10.3.9. I have one server running as my main development server, and would like a second to use for testing alternate DB Schema. I've followed the instructions in the manual section 5.12.2 'running mult

  1   2   3   4   5   6   >