Category: mysql

MySQL create user

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, […]

Getting PHP to talk to MySql

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 = 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 […]

Foreign Keys

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 […]


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 […]

Another Job

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 Tuning mySQL Linux AIX (not […]

Resizing the root partition in Solaris

Backup the root filesystem (preferably in single user mode) # ufsdump 0f /mnt/backup.dmp / To restore the root filesystem Boot from the CD-ROM to single user mode OK> boot cdrom -s Resize the root partition using format Mount the HDD to be restored to: # mount -o rw -F ufs /dev/dsk/ /root_disk Restore from the […]

Connecting to MySQL

At your shell prompt type # mysql -u <username> –password=<password> Where <username> and <password> are the username and password you entered when first setting up MySQL. You may also be able to login as root like this, # mysql -u root without using a password, depending on how your system was setup.

Creating a user and set password mysql

I’ve had a few problems creating users, assigning passwords and granting access to uses in MySQL. Below is one method I’ve found that works, at least for WordPress databases. mysql> create database wordpressdb; mysql> create user ‘wordpressuser’@’localhost’; mysql> set password for ‘wordpressuser’@’localhost’=PASSWORD(‘password’); mysql> use wordpressdb; mysql> grant all on * to ‘wordpressuser’@’localhost’;