Ok, two likely scenarioes comes to mind here.
A) You have not granted access to the user Blackbt to the table anarchy or forgot to reload the privileges after such a grant has been made. To do this log into your MySQL server as root and type the commands:
GRANT ALL ON anarchy.* TO Blackbt@localhost IDENTIFIED BY 'passwordHere';
FLUSH PRIVILEGES;
or
B) The username is case sensitive so you might have granted access to blackbt@localhost or BlackBt@localhost or some other similar name. (perhaps even BlackBot@localhost). To verify this beyond all odds you can log into your MySQL server as root and type the commands:
use mysql;
SELECT * FROM db WHERE User='Blackbt';
It should yeld a reply similar to:
+-----------+------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv |
+-----------+------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| localhost | anarchy | Blackbt | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
+-----------+------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
Now if this lines is filled with 'N's or does not return see point A.
I hope that helps.
Note: To log in to your MySQL server as root type the command at the command line: mysql.exe -u root -p
Then at the prompt provide the root password you have set. (You have set a root password, haven't you?)
Content
Members
Total Members: 1243
Stats
Users Online
