Current time: 04-21-2014, 02:54 PM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 5 Votes - 4.2 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to run SQL Queries using phpMyAdmin
11-13-2005, 04:08 PM (This post was last modified: 11-29-2005 01:54 PM by Chris Boulton.)
Post: #1
How to run SQL Queries using phpMyAdmin
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.
   

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.
   

3) You should now be at a screen that looks similar to this:
   

4) To run a SQL query, click on "SQL" on the navigation bar.
   

5) Enter your SQL in the box provided.
   

6) Click "Go".
   

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

Cheers!
Find all posts by this user
Quote this message in a reply
11-13-2005, 07:03 PM
Post: #2
RE: [Tutorial] How to run SQL Queries using phpMyAdmin
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! **
Visit this user's website Find all posts by this user
Quote this message in a reply
11-13-2005, 07:11 PM
Post: #3
RE: [Tutorial] How to run SQL Queries using phpMyAdmin
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".
   

3) Scroll all the way down the new page and click on "phpMyAdmin".
   

4) Follow the steps in the first post.
Find all posts by this user
Quote this message in a reply
08-07-2007, 05:22 AM
Post: #4
RE: How to run SQL Queries using phpMyAdmin
thx alot,

it really helped me alot.

well why do we get this error?
Find all posts by this user
Quote this message in a reply
11-19-2007, 09:33 AM
Post: #5
RE: How to run SQL Queries using phpMyAdmin
Thanks a bunch Kodaks.... your tutorial's is the best... great for newbie like me... Big Grin
Find all posts by this user
Quote this message in a reply
11-20-2007, 03:23 AM
Post: #6
RE: How to run SQL Queries using phpMyAdmin
nice tutorial man thanks

Official Arabic Translator.
Find all posts by this user
Quote this message in a reply
12-03-2007, 12:28 PM
Post: #7
RE: How to run SQL Queries using phpMyAdmin
Thanks for the tutorial.
It would be very useful to a lot of users...
Find all posts by this user
Quote this message in a reply
02-22-2008, 06:15 PM
Post: #8
RE: How to run SQL Queries using phpMyAdmin
please explain this i cont understand
((5) Enter your SQL in the box provided.)

http://uacommunication.com/aff.php?aff=109
Visit this user's website Find all posts by this user
Quote this message in a reply
02-22-2008, 06:31 PM
Post: #9
RE: How to run SQL Queries using phpMyAdmin
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'

[]s, Claudio

Tutorial: Jquery (by google API) with mybb (Prototype)
Distinction between Paid/Free Plugins Threads
Visit this user's website Find all posts by this user
Quote this message in a reply
02-23-2008, 09:33 AM
Post: #10
RE: How to run SQL Queries using phpMyAdmin
sir please kindly give me more detail i still cont undertsand please give me full detail with examples thanks

http://uacommunication.com/aff.php?aff=109
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication