Linux

Ask something
Discussion Locked

About MySQL Database

0 helpful
5 replies

by badair

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Here's the problem i have....
I had installed a new message forum or was installing one... called
phpBB from http://www.phpbb.com
i made a few minor mistakes in some options while installing so i decided to just go in to the ftp and i deleted thewhole folder and was going to do a fresh install..
but now when i go to do a fresh install i get this error...
Testing DB Connection...DB Connection Good!
Selected database simracingnewsnet...Database Selected!
Creating phpBB tables an insertingdefault data...
Creating table cat ERROR! Could not create table. Reason: Table 'catagories' already exists
the host tells me i need to write a cgi script to erase the table 'categories' but i have no clue about this... if someone can help me outhere i would appreciate it thanks...
you can contact me via email here...
webmaster@simracingnews.net

5 replies

by badair

yes i cleared the tables after contacting the host... i found a nice script called phpMyAdmin available here... http://phpmyadmin.sourceforge.net/
but now i've got this error coming up when trying to create a new database...
Error
SQL-query :

CREATE DATABASE `newdbtest`

MySQL said:

Access denied for user: 'simracingnewsnet@localhost' to database 'newdbtest'

by taisn

Hi there

It is quite simple to remove table "categories" at Mysql prompt. Logon to Mysql with the following command:

#mysql -pabc (abc here shows the password u have set to mysql database, you can set this with "mysqladmin password abc" command. This is must as this would also be required in phpbb installation process)

mysql>use simracingnewsnet;
mysql>drop table categories;
mysql>exit

or if you are interested to remove database "simracingnewsnet" to avoid further error messages in the installation process, do as follows:

mysql>drop database simracingnewsnet;

Regards

Tahir
Pakistan

This discussion is closed to new replies.