I have turned my local MySQL server to a remote one

Problem with permissions :(

[asson]

Hi everyone.
I have turned my local MySQL server to a remote server for allowing remote connections, the problem is the database user has not the right permission to dba. can anyone please explaing how to fix that?

I have tried every tutorial out there regarding this issue, none of them helped.

My server runs Ubuntu as OS.

Many thanks in advance.

[phranque]

mysql uses a database named "mysql" that contains the permission tables.
you probably need to add a record to the "db" table so that the user has access from the remote host and then you must do a "mysqladmin reload".