My SQL OS X setup - utterly, completely, 100% stumped
Anyone willing to help a newbie walk through setup and install? I've tried everything specified in the online documentation, the tips on Marc Lynnage's page, install tips in several MySQL books multiple times. I've read all error messages and tried my best to figure out how to work around them. Absolutely nothing works. I can't set the root password, there is no 'mysql' table after the install, can't create new databases, can't reset the root password by following the instructions at: http://www.mysql.com/doc/en/Resetting_permissions.html I don't have the $700 dollars for the commercial license at the moment and can't stomach paying that much just to learn how to get MySQL running and be able to create new tables. I've been a Macintosh C programmer for 7 years and after that, being unable to get a database running after following the instructions to the letter has me rather stumped. Any Unix/MySQL experts willing to spend a 15 minutes or so on AIM to help me out? Thanks Ken Tozier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My SQL OS X setup - utterly, completely, 100% stumped
On Sunday, April 6, 2003, at 10:28 AM, B. van Ouwerkerk wrote: You don't explain your problem. First problem is that after doing a clean install of mysql-standard-4.0.12 and following the instructions cd /usr/local/mysql sudo ./bin/mysqld_safe (Enter your password) (Press CTRL+Z) bg (Press CTRL+D to exit the shell) Then attempting to set the root password as recommended: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' which runs without error followed by: /usr/local/mysql/bin/mysqladmin -u root -h $hostname password 'new-password' which fails with an error of hostname: Undefined variable. An earlier post by Lenz Grimmer mentions a possible issue with the hostname variable so I tried hard coding the host name as follows: // get the host name [my-computer:~] my-user-name% hostname my-computer.local. // use it to set the password [my-computer:~] my-user-name% /usr/local/mysql/bin/mysqladmin -u root -h my-computer.local. password mypassword /usr/local/mysql/bin/mysqladmin: connect to server at 'my-computer.local.' failed error: 'Host '10.0.1.5' is not allowed to connect to this MySQL server' [my-computer:~] my-user-name% Also tried to run (without the hostname field) which yielded: [my-computer:~] my-user-name% /usr/local/mysql/din/mysqladmin -u root password mypassword /usr/local/mysql/din/mysqladmin: Command not found. [my-computer:~] my-user-name% At this point, my limited unix skills run out, what now? You don't even tell which versions you're running. mysql-standard-4.0.12 on Mac OS 10.2.3 If there is no mysql table then you didn't create it, or you trashed it. I didn't create it, true, but the documentation never says to do so. I assumed the package installer would handle this as part of the install. Does everyone need to create this table manually? Definitely didn't trash it as I didn't issue any rm's or manual deletes in the finder after install, so my suspicion is the installer just doesn't make one. In the manual you will find references to how to install MySQL on MAC OS X. http://www.mysql.com/doc/en/Mac_OS_X_installation.html Already followed these to the letter at least 4 times, can't set the password no way no how. without the root password, I can't create any new databases so everything else is just academic. IMHO your problem needs to be solved via the list. That way someone else can learn from the problem and others don't have to ask the same question over and over. I would definitely post the full solution and might even whip up a web page for other mac users You did search the archive.. right? Yep One possible problem might be that in my users and groups control panel, attempting to set a mysql user fails with the error: user mysql already exists even though it doesn't show up. Might be an old instance from when I tried MySQL a few months ago (also with no luck) Best I can tell, there wasn't any other mysql files on the system, I deleted them all prior to the install with rm's
More OS X install fun
Has anyone successfully installed mysql-max-4.0.12 on OS X? I've been trying for three days to set the root password and nothing I try seems to work. I'm a total unix newbie but I did go out and buy a Unix book and think I have enough of a feel for it to follow printed directions. It seems to launch ok but when I try to create new databases I get the following error: mysql create test; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'test' at line 1 Not sure whether this is a problem, but running mysql show databases; the terminal seems to hang. The absence of the mysql database seems to be a bad thing as the documentation clearly states mysql database is required because it describes user access privileges does this indicate a fatal install error? Is there a way to roll this file by hand? Thanks Seriously puzzled newbie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OS X install for Unix dummy
I just downloaded and installed the mysql-max-4.0.12.pkg, ran cd /usr/local/mysql sudo ./bin/mysqld_safe (Enter your password) (Press CTRL+Z) (Press CTRL+D to exit the shell) bg as specified in the readme. When attempting to set the root password, I successfully ran /usr/local/mysql/bin/mysqladmin -u root password 'new-password' but it choked on: /usr/local/mysql/bin/mysqladmin -u root -h $hostname password 'new-password' with the error: hostname: Undefined variable. Problem is, I'm such a Unix newbie I don't know how to retrieve the hostname it is looking for. I tried the name of my computer and my user name but those didn't work. What is it looking for? Thanks Ken Tozier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]