[SOLVED] mysql user cannot remove a database entry, help!

[ivytony]

I've created a db user and given it full privileges:

 

mysql>CREATE USER 'user10'@'localhost' IDENTIFIED BY 'password'

 

mysql>create database database_10;

 

GRANT ALL PRIVILEGES

ON database_10.*

TO 'user10'@'localhost'

IDENTIFIED BY 'password10'

WITH GRANT OPTION;

 

But this user cannot remove any entry from the database anymore! This is a new problem arised today, it used to be able to delete any entry in the database. I wonder what I need to do to enable this user to do its job.

 

Another problem is about logging in to phpmyadmin.

 

Say the user10 is the owner of a database used by domainA.com, I used to access phpmyadmin by using this url http://www.domainA.com/phpmyadmin and was able to log in using 'user10' and 'password'. But now, I cannot even log in phpmyadmin from http://www.domainA.com/phpmyadmin, instead I have to use this url http://www.domainB.com/phpmyadmin to access the database user10 owns. I wonder what causes this weird weird problem???

 

These are all new problem due to no reason today. thanks

 

[fenway]

Have you been run FLUSH PRIVILEGES?

[ivytony]

yes, I've flushed privileges. It turned out that my APF blocks the port '3306'. LOL

[fenway]

So, solved?