mySQL help

[PyRo]

hey i need some help wiht mySQL, how do i erase a database to start over, or should i say ghow do i acess mySQL?

[Paul E]

You can use phpMySQLadmin (http://phpmyadmin.net/) to access your DB (it seems to be a favorite) Or... you can try mySQLFront (http://mysqlfront.sstienemann.de/) which I feel is MUCH easier to use.

Once you access your DB, you can delete the tables.

[patricko]

Try this (http://www.mysql.com/downloads/download.php?file=Downloads/MyCC/mysqlcc-0.8.6-win32.zip)

That is if you have a windows system I don't like the idea of having phpadmin on the server just do it remote with the tools you can get for free......or if you have a http server and php installed on your system you should be able to set it up on your system

I use Mascon paid for it but Mysqlcc works just as good and it is free

[Jade Dragon]

make sure you have done these steps: (new user)

1) go to ops purchase mySQL database ($10.00 one time charge)

2) in ops go to mysql tab, create new user & password (write this down)

3) (per powweb tutorial at help.powweb.com ) you may need the #!/usr/local/bin/php if you do put it in make sure it goes at the top of the page before the first "<?"

4) change the config.inc.php per the tutorial (make sure you save it as a ".php" and not ".php.txt" )

5) upload the entire directory to the htdocs folder in ASCII FTP setting.

6) set your permissions (CHMOD) for the folders and files (755)

7) use .htaccess to password protect your directory!!!

Next....

Go to yourdomain.com/phpMyAdminXXXXXX/

You should see a frameset with your database name to the left. If you click on that the admin tabs should apear.

you will see all your tables to the left. Click on the database name that contains your tables you want to remove.

then hit structure (if your list isn't showing). that will list all the tables in the main window. Click the little box next to the ones you want to delete.

then scroll down to the very bottom of the page and select "drop" from the drop down menu. THIS WILL DELETE THOSE TABLES. so make sure you know which ones you want to delete. Have dropped several installs this way when testing phpbb out.

Also for multiple independant phpbb just change the table prefix from phpbb_ to whatever_