Tag Archives: phpMyAdmin

MySQL Remove whitespace

Posted on March 6, 2011 by mindeater

update your_table set your_field = trim(your_field)

Posted in MySQL | Tagged , | Comments Off

Create joomla 1.5 admin

Posted on March 2, 2011 by mindeater

This is something I do often enough to not want to google it .. Step 1 Create the new Joomla! User REPLACE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (’60′, ‘Admin2′, … Continue reading →

Posted in Joomla | Tagged , , , | Comments Off

Adding admin user from phpMyAdmin

Posted on December 3, 2010 by mindeater

here: http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database

Posted in Wordpress | Tagged , , | Comments Off