Setting up a database and creating a user to have access to it is quite a simple job.

(more…)

For information, I really don’t like Microsoft. Thanks to them, we now accept the worst operational environment as ‘the norm’. So why support it? Well, because it is used by some huge percentage of the IT world, and even if I were to win the Euro-millions lottery, and potentially disrupt the economy of some countries, I could not even begin to touch microsoft.

I’d probably buy shares though.

I managed to get the 8i DBA course completed from Learning Tree and have not yet upgraded. I work mostly with 10g and 9i now, so I suppose I should really get to it.

Changing a users password without a GUI in Oracle is pretty straight forward.

ALTER USER <username> IDENTIFIED BY <new password>;

Note the lack of quotes.

For MySQL its similar

update user set password=PASSWORD("<new password>") where User='<username>';

You will need to flush the privileges to make this effective.

flush privileges;

As a basis for the majority of new installs, I use the Developer Side base system on windows as it provides basically everything. Their site also provides excellent resources for help and support as well as how to do things on Linux

For a Linux install, the core RPMs seem to work fine The linux RMP installs tend to complete with a basic working copy of what you installed and as long as you do it in the right order things are generally fine.

Apache -> MySQL -> PHP -> anything else you need.