accessing mysql/deleting tabels
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
What OS are you using?
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;