MySQL ODBC Connector - Problems setting up on Mac OS X

Author

Problems setting up on Mac OS X

Jim C.

2005-09-28, 8:24 pm

I had the same problem with both of these:

mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg
and
mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg

They seem to install OK, but when I set the root password I can't get in
afterwards as root.

Clues?

Jim C.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Jim C.

2005-09-28, 8:24 pm

-------------- enig3487CEA0307A5265
36019CB0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Jim C. wrote:
> I had the same problem with both of these:
>
> mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg
> and
> mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg
>
> They seem to install OK, but when I set the root password I can't get in
> afterwards as root.
>
> Clues?
>
> Jim C.

I can provide any additional information necessary, if someone can let
me in on what is desirable. :-)

-------------- enig3487CEA0307A5265
36019CB0
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)

iD8DBQFDOwheS+yOHSv8
mrERArCZAJ0Z2uwyi6hs
C9xMz0VMEaTIub1ANwCe
O/xE
Hj4yRYUATYOL2s34evmq
ip4=
=0P49
-----END PGP SIGNATURE-----

-------------- enig3487CEA0307A5265
36019CB0--

Scott Haneda

2005-09-28, 8:24 pm

on 9/28/05 11:52 AM, Jim C. at jamesc@topiaventures
.com wrote:

> I had the same problem with both of these:
>
> mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg
> and
> mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg
>
> They seem to install OK, but when I set the root password I can't get in
> afterwards as root.

This may be a little out of date, but should still apply, and maybe help:
<http://www.newgeo.com/index.ws?id=100007>
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
<http://www.newgeo.com> Novato, CA U.S.A.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Bruce Dembecki

2005-09-29, 3:23 am

On OSX server there is a copy of MySQL already installed and just
installing the MySQL binary doesn't necessarily bypass it. Try
logging on as root with no password, you may still be booting from
Apple's data directory rather than MySQL's... starting mysqld using "/
usr/local/mysql/bin/mysqld_safe &" will generally avoid that
problem... this is the one MySQL installed.

You should also create a /etc/my.cnf file that will tell it what data
directory you want and all your other specific settings.

It can be quite troublesome getting around Apple's install as they
tend to install it back again at various system updates.

Best Regards, Bruce

On Sep 28, 2005, at 11:52 AM, Jim C. wrote:

> I had the same problem with both of these:
>
> mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg
> and
> mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg
>
> They seem to install OK, but when I set the root password I can't
> get in
> afterwards as root.
>
> Clues?
>
> Jim C.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=bruce@liveworl
d.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Jim C.

2005-09-29, 3:23 am

Bruce Dembecki wrote:

> On OSX server there is a copy of MySQL already installed and just
> installing the MySQL binary doesn't necessarily bypass

I'm afraid this isn't an OS X server nor is a server grade installation
of MySQL what I am after, right now. I'm a developer and what I am
after is something I can test applications against. It will be mostly an
empty database and probably not running unless I am testing. I'm just
using it as a back-end for jUDDI so that I can test a really cool
Java-based infrastructure technology against it and MySQL. :-)

Knowing how to set MySQL up still has value to me beyond this, however.
There are a great many things one can do with MySQL and knowing a thing
or two about it probably won't hurt my career one bit. ;-)
Furthermore, I am going to use it at home as a backend for MythTV, also.
:-) That's on Mandriva (blech! Still hate Mandrake's new name.) and I
can't get MySQL to talk there either.

> it. Try logging on as root with no password, you may still be booting
> from Apple's data directory rather than MySQL's... starting mysqld
> using "/ usr/local/mysql/bin/mysqld_safe &" will generally avoid that
> problem... this is the one MySQL installed.

I do not have, nor should I require, the root password. In our shop, we
use sudo as is appropriate. :-)
....and because the Administrator requires it. ;-/

"/usr/local/mysql/bin/mysqld_safe &" does work. It lets me in and I
can change the password of the root user... and then after logging out
and restarting the server using the panel item is when the trouble
starts. After this I cannot get back in. While logged in, I *do*
notice the conspicuous presence of *two* root users. one is root from
"localhost" and the other is root from "myhostname.domainname.net". Do I
need to delete one?

> You should also create a /etc/my.cnf file that will tell it what data
> directory you want and all your other specific settings.

OK, that is new information. I'll look around for this kind of stuff. .

I'm not fond of the idea, but perhaps if I can't get it working, I'll
try compiling it from source.

Jim C.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Scott Haneda

2005-09-29, 3:23 am

on 9/28/05 9:49 PM, Jim C. at jcllings@gmail.com wrote:

> I'm not fond of the idea, but perhaps if I can't get it working, I'll
> try compiling it from source.

There is no reason to do this unless you really want to, I assure you, mysql
can run on OS X. You may want to not use the startup pane thingy, I never
used it, just start it from the command line, or leave it running all the
time, wont hurt a thing on a dev machine.
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
<http://www.newgeo.com> Novato, CA U.S.A.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links