klkl

The last couple of days I’ve been thinking about setting up a local copy of my websites on my laptop so that I can develop them before I make them live.

Last night I enabled PHP on the apache server built into Mac OSX on my new laptop and installed MySQL on it. I also set up some bash aliases to rsync commands so that I could synchronise the websites from the server to the laptop and back again.

Now that I had local copies of the sites that are synchronised it was time to turn my attention to synchronising the databases between the server and my local machine. I could of configured the server’s MySQL installation to allow remote connections, however, I did not want to do this for security reasons. I decided that I would connect to the MySQL server over SSH by forwarding a port on my local machine to a remote port on the server.

First I needed to create an SSH tunnel using the following command

ssh -fNg -L 3307:127.0.0.1:3306 server.host.name Read the rest of this entry »

If you have never set a root password for MySQL, the server does not require a password at all for connecting as root.

To setup root password for first time, use mysqladmin command at shell prompt as follows:

$ mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use following command

$ mysqladmin -u root -p’oldpassword’ password newpass

At the beginning of the week I purchased a new MacBook Pro In between working I’m in the process of configuring it as I like it and one of the things that was bugging me was the default shell for the root user. I was foolishly trying to set the the prompt PS1 value in .bash_profile when the default root shell isn’t even bash.

The solution is to switch to the superuser (root) and issue the following command…

chsh -s /bin/bash

That will change the default shell to bash and the prompt will change as per your configuration.
Just for information my root PS1 is…

PS1=’\[\033[01;31m\]\h\[\033[01;34m\] \W \$\[\033[00m\] ‘

Happy Configuring!