Tuesday, February 3rd, 2009
Quick and dirty commands from commandline: mysql -u <user> -p<password> mysql> CREATE DATABASE wordpress; mysql> GRANT ALL PRIVILEGES ON wordpress.* TO 'wpuser'@'localhost' IDENTIFIED BY 'dbpassword'; ...
Posted in MySQL, SQL, wordpress | No Comments »
Wednesday, December 10th, 2008
It happens sometimes that due to database migration, you see spurious characters in MySQL tables and you would like to intervene massively (thick for instance to forums) and replace them with proper characters. Luckily this is easily doable if you manage to have connection to DB with command line ...
Posted in SQL | 1 Comment »
