Thread Rating:
  • 5 Vote(s) - 4.2 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to run SQL Queries using phpMyAdmin
#1
There are quite a few question on the MyBB forums regarding how to properly run SQL queries with phpMyAdmin. Here is a small tutorial I put together that explains the easiest method.
-------------------------------------------------------------------------
1) Login to phpMyAdmin. If you do not know where or how to do this, please consult your host.
Less than 1 minute ago" />   

2) In some cases, you may have to choose which database your MyBB tables are located on. If this is the case, please choose using the dropdown box.
Less than 1 minute ago" />   

3) You should now be at a screen that looks similar to this:
Less than 1 minute ago" />   

4) To run a SQL query, click on "SQL" on the navigation bar.
Less than 1 minute ago" />   

5) Enter your SQL in the box provided.
Less than 1 minute ago" />   

6) Click "Go".
Less than 1 minute ago" />   

7) If all goes well, your SQL query will now be succesfully entered.

Cheers!
Reply
#2
Great tutorial kodaks, I know several users here will find this very helpful. Nice work, rep. added and 5-star rating given. Thanks! Smile
-AndyM3

Proud user of MyBB since April 2005!
9 installations to-date!


** A special thank-you to ANY and ALL of the MyBB developers for their hard work! **
Reply
#3
Your welcome! Smile

Added:
If you use Cpanel, you may have to follow the below steps to access phpMyAdmin:

1) Log into cpanel.

2) When you have successfully logged into the front end, you will have to find the icon that says "MySQL Databases".
Less than 1 minute ago" />   

3) Scroll all the way down the new page and click on "phpMyAdmin".
Less than 1 minute ago" />   

4) Follow the steps in the first post.
Reply
#4
thx alot,

it really helped me alot.

well why do we get this error?
Reply
#5
Thanks a bunch Kodaks.... your tutorial's is the best... great for newbie like me... Big Grin
Reply
#6
nice tutorial man thanks
Official Arabic Translator.
Reply
#7
Thanks for the tutorial.
It would be very useful to a lot of users...
Reply
#8
please explain this i cont understand
((5) Enter your SQL in the box provided.)
Reply
#9
casiocasio Wrote:please explain this i cont understand
((5) Enter your SQL in the box provided.)

this is an example:
- If you want to make all users from your forum to not show Redirect Messages

PHP Code:
UPDATE mybb_users SET showredirect='no' WHERE showredirect='yes'
Reply
#10
sir please kindly give me more detail i still cont undertsand please give me full detail with examples thanks
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)