Access Denied - MySQL

[GoPantheoN]

I am getting a blank page http://www.warezxl.org and if I open any thread I get "Access Denied" message http://www.warezxl.org/showthread.ph...-updated-daily

I have set the user name and password prefectly and I have checked the privileges too.

I tried the following in shell

[root@** ~]# mysql_fix_privilege_tables --password=****
This script updates all the mysql privilege tables to be usable by
the current version of MySQL

Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaul                                                                             ts --force --user=root --host=localhost --database=mysql
Please check the above output and try again.

GoPantheoN Reviewed by GoPantheoN on 2nd Sep 2011. Access Denied - MySQL I am getting a blank page http://www.warezxl.org and if I open any thread I get "Access Denied" message http://www.warezxl.org/showthread.php?573712-nod32-keys-updated-daily I have set the user name and password prefectly and I have checked the privileges too. I tried the following in shell # mysql_fix_privilege_tables --password=**** This script updates all the mysql privilege tables to be usable by the current version of MySQL Rating: 5

[GoPantheoN]

shell> mysql_fix_privilege_tables used and it resulted that successful but still its access denied.

[soft2050]

First execute this to login to mysql through ssh:

mysql -u USER -p DBNAME

(You can also login as root)

Enter the pass for the user

Then execute this

GRANT ALL PRIVILEGES ON dbname.* TO dbuser @'%' IDENTIFIED BY 'dbpassword';

And

FLUSH PRIVILEGES;

[GoPantheoN]

Ok, I ll use this. Thank you.

Edit: Actually I removed everything and installing fresh, but ll do this if it occurs again.

[GoPantheoN]

I got the following error

mysql> GRANT ALL PRIVILEGES ON warezxl_wxldb.* TO warezxl_wxldb @'%' IDENTIFIED BY 'pass';
ERROR 1044 (42000): Access denied for user 'warezxl_wxldb'@'localhost' to database 'warezxl_wxldb'

[soft2050]

I got the following error

Login to mysql as root
If you have never set root password, then it should work by executing

mysql

Then execute this

GRANT ALL PRIVILEGES ON dbname.* TO dbuser @'%' IDENTIFIED BY 'dbpassword';

And

FLUSH PRIVILEGES;

Use a new username and password this time

Then edit db details and try
Should fix your problem

[GoPantheoN]

I should replace dbname dbuser and dbpassword with the details right ?

Also when i try to FLUSH i get just this for long time

mysql> FLUSH PRIVILEGES
->
->

[soft2050]

I should replace dbname dbuser and dbpassword with the details right ?

Also when i try to FLUSH i get just this for long time

Yes with your details

I guess you didn't added ; after the command

Its "FLUSH PRIVILEGES;" without quotes

[GoPantheoN]

mysql> GRANT ALL PRIVILEGES ON warezxl_wxldb.* TO warezxl_wxldb @'%' IDENTIFIED BY 'pass';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES
->

After Flush nothing happens.

[soft2050]

After Flush nothing happens.

Tried updating the details in the script with new user and pass

Does it worked out?