Tag Archives: MySQL

Allowing remote access to MySQL

Posted by dave on March 15, 2013 No comments

MySql remote access can be easily achieved by running the following command: CREATE USER ‘usernamehere’@’%’ IDENTIFIED BY ‘passwordhere’; GRANT ALL PRIVILEGES ON *.* TO ‘databasenamehere’@’%’ WITH GRANT OPTION;

Using LDAP authentication with MediaWiki and IIS

Posted by dave on January 15, 2013 No comments

I wanted MediaWiki to use Windows Authentication automatically when users visited the Wiki. This wasn’t as straight forward as I had hoped but I finally managed to get it working, this is roughly how I went about it: Install PHP Install LDAP …

Read more »

Automating MySql Scripts

Posted by dave on August 2, 2012 2 comments

So I needed to run a mysql script on a daily basis to do some maintenance on a database. Pretty straight forward davessql.sql:

davesbatch.bat

Then a scheduled task to call the batch file, job done.

Link Leaderboard – WordPress Plugin (Version 0.1 Alpha)

Posted by dave on July 5, 2012 No comments

This is a post dedicated to the WordPress Link Leaderboard plugin that I wrote, Version 0.1 (Alpha) This is the first WordPress plugin that I’ve written so expect many bugs and errors and plenty of room for improvement. The basic idea was …

Read more »

Backing up mySQL Databases Batch File / Script

Posted by dave on July 4, 2011 No comments

And another, this time to backup the databases, based on an earlier post or creating simple backups, I can then call this batch from within another batch file. @echo off IF %1.==. GOTO No1 ECHO Dave’s mySQL Database Backup UtilityECHO …

Read more »

mySQL Restore Batch File / Script

Posted by dave on July 4, 2011 No comments

I got bored typing mysql commands so wrote a little script to keep on my box for easy access to restore databases from .sql files. It’s very simple and may not be any use to anyone. It also stores the …

Read more »

PHP optimisation in Windows IIS

Posted by dave on February 18, 2011 No comments

Firstly, use the non-thread-safe version of PHP, its more efficient, see here. If you are unsure which version you have, check the very top of phpinfo() Then you can make some slight changes to php that will save some processing …

Read more »

OSTicket Database Errors (Polish Characters)

Posted by dave on February 16, 2011 No comments

I’ve had a few emails from OSTicket recently, telling me that there was a DB error, specifically: Incorrect string value: ‘xC2x0AThan…’ for column ‘message’ at row 1 The email had originated from a Yahoo address and so my initial thought …

Read more »

Speeding up MySQL Databases by setting the Query Cache Size

Posted by dave on February 11, 2011 No comments

I use MySQL in a Windows Server 2008 R2 box and it runs very well, I never have any issues with it and currently there are about 18 databases on there. However, it now has a fair bit of data …

Read more »