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;
Tag Archives: MySQL
Allowing remote access to MySQL
Posted by dave on March 15, 2013
No comments
Using LDAP authentication with MediaWiki and IIS
Posted by dave on January 15, 2013
No comments
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:
|
1 2 |
USE databasename DELETE FROM 'tablename' where timestamp <= DATE_SUB(NOW(), INTERVAL 1 MONTH); |
davesbatch.bat
|
1 |
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe" -uUSERNAME -pPASSWORD < "davessql.sql" |
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
Backing up mySQL Databases Batch File / Script
Posted by dave on July 4, 2011
No comments
mySQL Restore Batch File / Script
Posted by dave on July 4, 2011
No comments
PHP optimisation in Windows IIS
Posted by dave on February 18, 2011
No comments
OSTicket Database Errors (Polish Characters)
Posted by dave on February 16, 2011
No comments
Speeding up MySQL Databases by setting the Query Cache Size
Posted by dave on February 11, 2011
No comments