Month: September 2009

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

Adding space to a tablespace

One of the jobs I do the most as a DBA is added space to peoples schemas.  It’s not a big thing, just something I have to monitor and watch out for. Users don’t like it when they can’t save their data into the database. Below is a script that simplifies the main tasks required […]