Archive for the 'MySQL' Category

DBMS for basic application data storage

August 19, 2006

An application I am making requires a basic DBMS and it would be ideal if I could have this as a standalone file without having to install mySQL or another service based DBMS on a users computer when it is not necessary. Microsoft Access files definately do the job but I’d like an alternative. All the file needs to do is store the SQL data and provide a DBMS engine. I don’t need any of the visual functions (form creation, etc).

I’ll proberly end up going with OO.o Base 2 due to the simplicity. The other alternatives include: looking for or implementing an XML based storage solution, using an object database to directly save objects, using an API based database engine or as mentioned installing mySQL on the client.

For quick and easy implementation it is much easier to use a datafile, ODBC, and SQL. I’ll install OO.o Base 2 and see what I come up with, still have assignments that I need to get done at the moment though!

Advertisements

WordPress install

July 9, 2006

Well I’m definately on my way to a new theme, I have installed all the development tools and have them working together (apache, mysql, php and wordpress). My install went something like this:

Apache 2.2.x didnt like php4 and was not loading the module dll, I understand this is a common problem and came across some solutions based on php5. I wanted to run php4 so I installed Apache 2.0.x.

I did come across XAMPP, a cross platform easy to install Apache distribution containing MySQL, PHP and Perl. Looked like the perfect solution but I’d like to learn how to do it manually.

I Changed the default folder public_html by editing DocumentRoot pram and edited the various other settings to work in with the directory structure I created (%roo%/www/…)

I also installed mysql from a zip archive and changed the ini file to point to my non default install location and set my windows classpath. After setup I gave the root user a password, created a user account and removed the anonymous accounts.

I extracted the wordpress install to a folder named blog in my public_html directory

I came accross a small error in setting up a user for the wp-config file. MySQL 5 uses a new password encryption format that is not supported currently by wordpress this is fixed by starting up the mysql server with the –old-passwords pram:

mysqld –console –old-passwords (I don’t have mysql installed as a service)

Or by creating a new user in the following way:

GRANT ALL ON *.* to ‘user’@’localhost’;
SET PASSWORD FOR ‘user’@’localhost’=OLD_PASSWORD(‘password’);

Note the OLD_PASSWORD function.

From the website:

[UPDATE: MySQL 4.1.7 uses a new password encryption system that is incompatible with prior methods. If you want to get WordPress working with a 4.1.7 database, you need to make sure your user password is set as an old-style password (password-old instead of password, if you’re using mysqladmin). — Nabil] Note : The above are actual user comments, and may be subjective in their content. It is hoped that it will be of help to some users who face the specific problems that are addressed by this question..

Once wordpress could work with my passwords the installation was extremely straight forward and my blog was up in no time! Now time to find/create a theme!

blog