accessing mysql/deleting tabels

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 !

3 Replies

Do you have phpmyadmin installed?

What OS are you using?

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).

From the SSH command line:

mysql -uUSERNAME -p DATABASE_NAME

Enter your MySQL password when prompted.

From the MySQL command line:

SHOW TABLES;
DROP TABLE TABLE_YOU_WANT_TO_DELETE;

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct