Home »
FUDforum »
FUDforum Installation Issues »
ALTER Error Compacting Messages
Re: ALTER Error Compacting Messages [message #4187 is a reply to message #4186] |
Wed, 17 July 2002 20:36 |
Juanisan
Messages: 24 Registered: July 2002 Location: Conshohocken, PA
Karma:
|
Junior Member |
|
|
I ran the test....
Called it test.php. This is what I got:
test.php output |
--------------------------------------
Error in function/script: db.inc
has caused the following error: query failed: %( ALTER TABLE fud2_pmsg ADD INDEX(offset) )% because %( Access denied for user: 'badmin@localhost' to database 'barforum' )%
while processing script name: /var/www/htdocs-bar/chat/test.php
the error occured at: 17/07/2002 20:37:12 GMT
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.1a) Gecko/20020610
User Ip: 10.10.9.1
Script Accessed: /var/www/htdocs-bar/chat/test.php
Query Failed: ALTER TABLE fud2_pmsg ADD INDEX(offset)
Reason: Access denied for user: 'badmin@localhost' to database 'barforum'
From: /var/www/htdocs-bar/chat/test.php
Server Version: 3.23.51
|
Mysql Privileges |
root@juanisan:~# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7772 to server version: 3.23.51
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select Host,User,Alter_Priv from user;
+-----------+--------+------------+
| Host | User | Alter_Priv |
+-----------+--------+------------+
| localhost | root | Y |
| juanisan | root | Y |
| localhost | | N |
| juanisan | | N |
| % | badmin | Y |
| localhost | badmin | Y |
+-----------+--------+------------+
6 rows in set (0.00 sec)
mysql>
|
Never ask a geek why, just nod your head and slowly back away.
|
|
|
Goto Forum:
Current Time: Thu Nov 28 08:04:29 GMT 2024
Total time taken to generate the page: 0.04099 seconds