Enter Password For Mysql In Mac Os X Terminal

#Enter For Mysql In Terminal Mac OS X

Enter For Mysql In Terminal Mac OS X

To use this commands make sure to start line with the commandname and finish it with вЂ вЂ™.If you took notes of your Root Password вЂ“ try searching for it first.If you are using the terminal client, generally you can do things like reset the root users password for mysql or create databases. A simple example can be found at the MySQL docs site, of which I will copy the highlights. To create a new MySQL user: Login to MySQL in Terminal:mysql -u usernameTo establish an SSH tunnel on a computer running Mac OS X or Linux: Open a terminal window and type the following command at the command line.

Then load it in a web browser. PhpsDirectoryIndex index.php index.shtml index.html.to the section marked '', so that it looks like this:Now restart the webserver, by going to Preferences->Sharing and unchecking, then rechecking the Personal Web Sharing box.And save that file as something.php. Find and uncomment (remove # mark) these lines:LoadModule php4_module libexec/httpd/libphp4.soAddType application/x-httpd-php-source. Edit (backup first) /etc/httpd/httpd.conf. 10.2 ('Jaguar') come with php installed, but it is not enabled by default. Current versions of Mac OS X v.

The basic functionality of php is now enabled on your system. Add the key php libraries. If you don't, then something's wrong - check the syntax in httpd.conf, restart Apache again, run Software Update and reboot if necessary, and try again.2.

(At the time of this writing, that's version 4.0.) Then scroll down to the 'Mac OS X Package Installer downloads' section and pick 'Standard.'When it's finished downloading, unpack and mount the disk image. Go to the mysql downloads page, then go to the link for whatever's listed as the 'Production Release' from the 'MySQL database server & standard clients' list. Download and install mysql. So, either make sure you re-copy those files after you install relevant system updates, or figure out how to do something clever with hard links (OS X 10.0 didn't support them, maybe Jaguar does?), or do something else that works.and please email me about it so I can update this howto.

To test from the command line, type:You should then see a mysql prompt. You would type these two commands, verbatim:Mysqladmin -u root -h `hostname` password goober4. Say the password you want to use is 'goober'. Set the mysql root password.

Go to the phpBB downloads page and select the gzipped version of the 'Full Package' from the download list. Download and unpack phpBB2. For a quickstart on that, take a look at this tutorial.1. Or just ctrl-d to exit.At this point, you can start cranking out php scripts to communicate with mysql databases via web forms or whatever.

Move this directory to your webroot:Sudo mv phpBB2 /Library/WebServer/Documents/Optionally, you can rename the directory to something friendlier like 'forums' - keep in mind that whatever you name the directory will be its URL. This contains all the code for the bulletin board. If Stuffit automatically unpacks it, delete the folder it creates and leave the archive untouched.) Now, open a Terminal, cd to the directory containing the downloaded phpbb tarball, and type:This should create a directory called 'phpBB2'.

Type ctrl-d to exit mysql.3. If you get an error, try again - check syntax, make sure there's no spaces where they shouldn't be, etc.)To check that the database was created, type:You should see three databases: 'mysql', 'test', and 'forumdb'. It should say 'Query OK, 0 rows affected (0.01 seconds)' or something very similar. In the Terminal, type:Don't forget the semicolon.

For some info on that, consult the mysql documentation, or for a quick-and-dirty solution, see this post. Remember to select the right version of mysql ('4.x') and specify the right login info so that phpBB can talk to your 'forumdb' database.Note: It would be a Good Idea, security-wise, to create a non-root mysql user for phpBB to use, rather than using the root account. If you don't, something is broken - either your php setup is uncool (you'll need those key libraries, make sure they're all under /usr/lib/php), or the phpBB2 files themselves are somehow fouled up (did you unpack them with Stuffit Expander instead of command-line tar? Bad idea.) Try again, and make sure to force-reload the page and/or clear your browser's cache.For the actual phpBB installation details, refer to their excellent documentation at. You should get the phpBB 'Install' page.

Enter Password For Mysql In Mac Os X Terminal