Hi all,
I installed mysql server and phpmyadmin on centos 5.5.
then i created a user with command
mysql> create user 'username'@'localhost' identified by 'password';
he can access phpmyadmin from another computer but cant able to access via command prompt from another computer.
then i created another user with command
mysql> create user 'username'@'%' identified by 'password';
he can access mysql server form another computer via command prompt
but not able to access phpmyadmin from local or another computer.

how to create user who can access mysql server from local computer and another computer in network with command prompt as well as phpmyadmin.

thanks
suresh.

He will need to use the first password for phpMyAdmin as that runs on the localhost no matter what machine he is accessing the web interface from.
He will need to use the first password for command line access on the mysql server.
He will need to use the second password for command line access from other servers.

The second user should be able to access both from the localhost and from the network, in this context the '%' is a wildcard, so it should include localhost. I would try to either restart mysql or flush privileges to make sure that it has propagated.