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/[EMAIL PROTECTED]
