mySQL Administration and Security

[ukgimp]

I have been working locally on a mysql and php dev server (firepages) and hope to transfer some stuff onto a real live server (:)) which will available online. Here is where it gets scary. I don’t really have the first idea about making sure the thing is secure online At present it is not secure at all as there are no users assigned, so a connection with password “” and username “” gets in no worries.

I have been reading around and found few resources but this is something new to me and I want to get it right from the off.

I have found the following:

Daunting
[mysql.com...]

Not bad
[devshed.com...]

I don’t have command line access on my local machine or at least I don’t know how to get going with it. Can I rum a command line with my type of set up. Until now I have had phpmyadmin set up which is pretty cool. I figure if I can get is secure on my machine I can upload and be moderately safe.

If any one has link, suggestions, ideas I am all ears and will be hugely greatful.

Cheers

[justageek]

Use this to admin it. [mysql.com ]

[ukgimp]

command prompt on windows running firepages:

navigate to the bin where your mysql folder is then:

type
mysql -u root mysql

So that work in windows. Still overwhelmed by the other issues at present