RSS feed for InstantSpot site Mark Brown's Blog

Reset MySql root password

Fri, 20 Apr 2007 17:29:03 GMT

One of the problems I ran into when I started playing with MySql was trying to figure out how to reset the root password.

one night I was dinking around in MySql, and wound up locking myself out. I searched high and low for someway to reset that password, found a couple of hints at how, but couldn't ever get it reset. It was on a new install of Ubuntu and Mysql, so I removed MySql, reinstalled it, and I still couldn't get in. So, I wound up reinstalling Ubuntu, then MySql to get it to work.

Today I was perusing the mysql newbie from and saw this post. http://forums.mysql.com/read.php?10,149291,149311#msg-149311

Boy that would have been helpful about 3 weeks ago, so hopefully someone here might find it useful now!

Have a good weekend!

Remote Access to mySql Database

Sat, 31 Mar 2007 04:38:16 GMT

As I'm playing with MySql I found that setting up remote access to the mysql server is a bit tricky at first, so I thought I'd share quickly with you how to set up account with remote access.

Here's the whole process:

I've got a Ubuntu box running MySql 5 on it. Once I got MySql installed (sudo apt-get install mysql-server) I set up the root account with a password. (mysqladmin -u root password "passwordyouwant") <--Thanks for that Aaron Lynch.

Then, log into the MySql server by opening a terminal window locally and typing:

mysql -u root -p (then enter the password you set above)

Following the tutorial located here , I then created a db, and table, and populated it with some data.

At this point I think, what if I want to administer this thing from my laptop? So, I installed the MySql Administrator (sudo apt-get install mysql-admin).

I tried to log in using the sql admin tool after the install. Typed in the ip address of the MySql Server, username and password, but it threw this error:

Could not connect to host
MySQl Error Nr. 1130
Host '192.168.1.103' is not allowed to connect to this MySQL server

I started browsing some forums and blogs and found that I need to edit the /etc/mysql/my.conf file to allow other machines besides the localhost to access the server.

  sudo nano /etc/mysql/my.cnf

  and change the line:

  bind-address           = localhost

  to your own internal ip address e.g. 192.168.2.10

  bind-address           = 192.168.2.10

  CTRL-X to close nano, y to save, enter to confirm the location

I try the MySql Administrator again, but get the same error or a 1045 error. So I get to doing some more research and find that for a account to access a MySql db remotely you have to tell the server the host name that you'll be connecting from or you can use a % as a wildcard meaning from everywhere. The MySql documentation does a great job of showing you how here.

I went to the server, logged into mysql locally (or via ssh) and typed:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'typeusername'@'localhost' IDENTIFIED BY 'typepasswordhere' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'typeusername'@'%' IDENTIFIED BY 'typepasswordhere' WITH GRANT OPTION;

The first statement gives the username permission to log on locally to the db from the console of the server, and the second statement gives the username access remotely from anywhere. I could have done 'typeusername'@'192.168.2.50' in that second statement restricting that username to only being able to connect from local and 192.168.2.50.

One note on those usernames. I created another username for remote access, instead of trying to edit root, as I was scared to mess with the root account. Plus I'm getting kinda tired of breaking these linux boxs and not knowing how to fix them:) Also the part that says "PRIVILEGES ON *.*" is giving this new account superuser privileges, so be careful with this.

Once I typed those two commands into MySql to create those accounts and privileges it started working like a champ from my workstation.

Of course none of this is anything new, but I found it a bit time consuming trying to get it to work. I'm still pretty new to mySql. Hopefully this will save some other newbies some of their time.

Later,

Mark

SQL Tutorials

Fri, 17 Nov 2006 15:17:15 GMT

In my quest to learn all this new stuff I've found that there are a great deal tutorials on the web that are very helpful in learning new technologies without having to spend half my pay checks on books.

After talking to a developer friend of mine about good resources to use to learn sql he directed me to this webesite. http://www.sqlcourse.com/

Seems like a pretty good site for a complete newbie to SQL, but i haven't gone all the way thru it yet. Another one I found this I like is http://www.w3schools.com/sql/default.asp.

Actually I've found most of the tutorials at W3Schools pretty helpful.

This might all be old news to some of you, but it's nice to know where to go to get some good example and turorials on some of this stuff.

Thanks for reading and as always I'm looking forward to your comments.

Mark

P.S. If you feel like adding to this very short list, please do.

CF Newbieness and Hello

Wed, 11 Oct 2006 13:42:07 GMT

Well, Hello. My name is Mark Brown. This is my first blog, so bear with me.

I decided to start this thing because I'm learning some new skills. I'm a IT Manager, and am very familiar with pc's, servers, networks, blah, blah, blah. It dawned on me a few months ago that I needed to learn some new skills. On the advice from a friend, Mike, I decieded to learn Web Application Programming using ColdFusion. So, I figured, that sounds easy enough, and started. First problem I ran into was, I HAVE NO PROGAMMING EXPERIENCE. None. Ziltch. Nada. I've written a few batch scripts for login scripts on my Novell servers at work, but other than that I was clueless. Well, I'm still clueless, but an learning more by the day. You web programmers talk your own language. I'm Starting to understand some of it, but hey, life is just one big learning curve. Right?

Anyway, I'm about 6 months into it. I haven't been hitting it too hard, but have learned quite a bit. About a month ago I launched my family website, http://www.thebrownhomeonline.com. I did it with Coldfusion and it seemed fairly straight forward. It's got a private section that took me a while to figure out how to do the security, and the initial learning about frameworks to keep the maintenance of it easy were a bit difficult for me, but I eventually got it with some very generous help from Mike.

I've got a couple other projects I'm working on, which I'll talk about later.

Main reason for this blog entry is just to Introduce myself, and give you all a idea of what to expect from this blog.

What I'm hoping to accomplish here is to document my journey from total cluelessness in ColdFusion and web apps to my finished products. I hope to be able to help other newbies find good resources I've used, and/or document some of the hurdles I ran into throughout this process and how I overcame them. You'll probably also get to see some of my rants and raves on wide variety of subjects. Lucky YOU!!!

So, there you have it.

Later,

Mark