Reset Mysql Root password on Mac OSX
Had a strange issue where mysql started asking for a password for my local mysql after updating my mysql2 gem. So to fix this had to update my root password and here is how l did it
1. Stop MySQL service. You can do that using the preference pane if you have that installed or you can stop it using Terminal sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
2. Skipping Access Tables. If you have installed MySQL5, fire up Terminal window and execute /usr/local/mysql/bin/mysqld_safe –skip-grant-tables For older versions of MySQL, execute the following command /usr/local/mysql/bin/safe_mysqld –skip-grant-tables
3. Reset MySQL root password. Now when safe_mysqld running in one Terminal window, open up another Terminal window and execute /usr/local/mysql/bin/mysql mysql. This opening up the MySQL console and opening the mysql table so we can update MySQL root user. Write the reset query into the console as follows UPDATE user SET Password=PASSWORD(‘YOUR_PASSWORD’) WHERE Host=’localhost’ AND User=’root’;. Replace “YOUR_PASSWORD” with your desired password.
4. Once you’ve done that just exit the console “exit;” close the safe_mysqld execution and restart your MySQL server. You can do this using sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
Once you have done that you can access mysql again with no issues
Sublime Text 2 the next text editor in your toolbox
So i have decided to try out Sublime Text 2. Now l have been a Textmate user for a number of years now but the speed in which you can find files and the way it handles large files such as log files or csv’s for example has always been an issue and one of the guys here at Sentia suggested l try Sublime as he is also in the process of giving it a go as well.
So there is a Beta 2 out now which l promptly downloaded and fire it up. Now l have to say that its fantastic. Its super fast and easy to use. Sure its missing some of the little things that Textmate has that makes life easy such as the rails bundles etc but you can actually download and install ported bundles from textmate that users have ported across.
The UI is clean and simple to use and the fact that you can change almost every setting in the app and also with the full screen feature its hard to beat.
The search is the best feature hands down. Its super fast and simple to use and you never get caught again hitting apple + T and find out later that you have typed some of your search letters into a random ruby file you had open at the time.
Here are some screen shots of how clean the UI is in full screen mode and the search tool
p.s One thing that you will be missing is the
mate .
Command but not to worry simply add the following
alias sub='open -a "/Applications/Sublime Text 2.app"'
to your .bashrc or .profile file and you can open projects the same you would have in textmate in sublime but with the following command
sub .
Also worth the license is cross platform so no more buying multiple licenses.
Hotspot PMQ
Hotspot PMQ keeps you connected to everything happening in Port Macquarie worth knowing about.
Sentia was not only responsible for building the iPhone application but also the Administration System used to manage all the deals on offer
www.onebigswitch.com.au
One Big Switch uses the power of group switching to help consumers pay less for their regular household bills, in a quick, easy and obligation free way.
Sentia was commissioned to develop this new idea for a fantastic service that looks to help empower everyday people and give them the ability to get the best possible deals for themselves.
