It won't let me get into code editor so I can't matt
You don't need to do anything with a code editor to run a query, you run queries in phpMyAdmin...
Now the files won't show in settings.php
fml
Did you edit it in the editor and then save it?? That may ruin it... Also, did you mess something up in the query? O_O
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mybb_usersSETpassword= '098f6bcd4621d373cade4e832627b4f6',salt` = '' WHE' at line 1
You've not copied all the query properly if you're getting that error.
So this hole code
UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6', salt = '' WHERE uid = '1';
#1046 - No database selected
Well you've not selected a database, you have to choose one first from the menu on the left when you first go into phpMyAdmin.
1 row(s) affected. ( Query took 0.0007 sec )
(2011-03-14, 10:02 PM)koolace55 Wrote: [ -> ]1 row(s) affected. ( Query took 0.0007 sec )
Yes, now you can login using the password "test".