MySQL on MAC

Boy, switching to a MAC after years and years of PC's is tough, but I am enjoying it. I though I would provide a few hints where I had trouble and to me a little while figure out.

MySQL install went okay but I did have a few challenges.

1. Know DOS but my unix/linix command skills are very rusty. So I relied on tranlation sites to get me through. Just google unix vrs dos commands. Ex. http://unixhelp.ed.ac.uk/DOStoUNIX.html
2. Finding terminal. It's under applications and then utilities! Or just type terminal in Finder.
3. Be sure to run a 3 files in the 5.0 download.
   
1. mysql-5.0.41-osx10.4-i686.pkg //main install easy and quick
   
2. MySQLStartItem.pkg //since we windows boys are mac dumb this like placing in you startup
   
3. MySQL.prefPane //puts a monitor and start and stop tool in control panel
4. Look in your Application folder to find the MySQL Query Browser
5. I had trouble connecting with CF. It was because I needed another user added in the database
1. open Terminal
2. Type: sudo /usr/local/mysql/bin/mysql
3. type in root password
4. you should get a sql prompt mine: mysql>
5. Connect to the main database by typing: use mysql
6. User are found a table named user. Do: show tables; desc user;
   
7. Add a new user with: create user test@localhost //if name is long you will need to use ticks. Ex 'joehammond'@'localhost'
8. Set Password
   

1. SET PASSWORD FOR 'test'@'localhost' = PASSWORD('newpass');

2. FYI: the password are encypty to 32 bit. So use the password function shown above
   
3. http://dev.mysql.com/doc/refman/5.0/en/set-password.html
   
9. Create a test database:
   
10. Apply Grants to test database to test user.
    
6. Eclipse need the driver go here http://dev.mysql.com/downloads/connector/j/5.0.html
7. Unpack. I placed the unzip folder in my liabrary
8. Then in SQL Explorer under Eclipse Preferences setup the extra class path for MySQL driver.
   

Well, I know I left some gaps but I am tired of typing and want to play some more. I will try to add more later. If you have questions or get stuck just email me. joe.d.hammon@gmail.com

Spiritual Blessings

God sent a new friend and new believer to my door a few weeks ago. Tracey stopped my office and she noticed a Bible on my desk. We began discussing the Bible and shared our testimonies. I shared my blog spot with her and is it because of her I decided to return today.

My last post was in 2 Corinthians but I continued reading the Bible daily and underlining things I learn. I finished the New Testament. I look back now I say WOW that was a lot of reading. I should have commented on my thoughts during this. I learned so many things I should have shared. I am bad. I was not sure if anyone really read this site based on no comments, so I stopped. Typing is not my strong suit and I need encouragement to make myself continue. Tracey encouraged me. So, that is why I am here today. I ran across this in Revelations and it made me think of one our conversations.

Rev 19:13. He was clothed with a robe dipped in blood, and his title was the Word of God.

So, Jesus is the lamb and he is the one in the robe. Jesus is Word of God, which is the Bible. Reference to this can also be found in John 1:1.

John 1.

Prologue: Christ, the Eternal Word

1 In the beginning the Word already existed. The Word was with God, and the Word was God.
2 He existed in the beginning with God. 3 God created everything through him, and nothing was created except through him. 4 The Word gave life to everything that was created, and his life brought light to everyone.

May God bless you.