Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Sun Aug 22, 2010 1:03 pm 
Offline
Senior Member

Joined: Wed May 27, 2009 9:04 pm
Posts: 60
Hello,
This is very new to me so sorry if this is a dumb question:

How do you access Mysql ? I know I have everything installed correctly because I have wordpress installed on my server... How ever I need to go in and delete a few tables.. how do I go about doing that?

Is it like a regular server and I can access phpmyadmin? or is it something else?


Thanks in advance !


Top
   
 Post subject:
PostPosted: Sun Aug 22, 2010 1:30 pm 
Offline
Senior Newbie
User avatar

Joined: Mon Jun 28, 2010 11:04 pm
Posts: 14
Website: http://johnlevandowski.com/
Location: Salt Lake City, UT
Do you have phpmyadmin installed?
What OS are you using?


Top
   
 Post subject:
PostPosted: Sun Aug 22, 2010 3:05 pm 
Offline
Senior Member

Joined: Fri Jan 09, 2009 5:32 pm
Posts: 634
If you just need something occasionally, I'd suggest getting one of the GUI tools, install to your desktop, then connect remotely (via ssh tunnel).


Top
   
 Post subject:
PostPosted: Sun Aug 22, 2010 4:03 pm 
Offline
Senior Member

Joined: Fri May 02, 2008 8:44 pm
Posts: 1121
From the SSH command line:
Code:
mysql -uUSERNAME -p DATABASE_NAME

Enter your MySQL password when prompted.

From the MySQL command line:

Code:
SHOW TABLES;
DROP TABLE TABLE_YOU_WANT_TO_DELETE;


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group