Every time I have to setup users in MySQL I seem to have problems.
I was setting up a system to do some WordPress testing and installed MySQL OK, but ran into problems with the users and permissions. Again.
So I had to search the net, again, and find out what I was doing wrong, again.
Maybe I’m [...]
If you are trying to get PHP, Apache and MySQL to work together one of the steps you have to do is edit the file /etc/php5/apache2/php.ini and uncomment the following line,
extensions = mysql.so
You then need to commented out the following lines,
;extension_dir = /usr/lib/php4/20020429-zts/
;include_path = “.:/usr/share/php”
NOTE : These are the only steps of course, its just [...]
I’ve been looking at foreign key constraints today. I’ve managed to set a FK constraint in an Oracle and a MySQL database without too much trouble. But I was having trouble understanding why you would set up a FK constraint. It seems some of the reasons are: -
ensure referential integrity
assist with visualizing and preparing [...]
I did some digging and found out that Postgres is actually PostgreSQL an open source database. Much like MySQL.I setup a spare laptop with Fedora 10 and installed it and got it running OK with only a few little hitches. Mostly from not knowing a thing about it.
Looks like it would be simple enough to [...]
I happened to have a quick look at the jobs available at the Bureau of Meteorology yesterday. They have a “Systems and Database Specialist” position available starting at $80K.
Although I’m not going to apply for it, it has given me some ideas on how/where to improve my skills.
Database [...]