update your_table set your_field = trim(your_field)
Tag Archives: phpMyAdmin
Create joomla 1.5 admin
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’, ‘admin2’, ‘user@usersemailaddress’, ‘21232f297a57a5a743894a0e4a801fc3:abcdefghijklmnopqrstuvwxyz012345’, ‘Super Administrator’, ‘0’, ‘0’, ’25’, ‘2000-01-01 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”); The
Continue reading: Create joomla 1.5 admin
Adding admin user from phpMyAdmin
here: http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database