Topic: MySQL

[WXP]

Hey folks,

Here is my problem.
I have to access to my "MySQL" database from somewhere on the net.. because my provider does not give an access to mysql on his server.
So I thought.. Humm why dont use mine ?

So I created a new user with phpmyadmin with all grants and server "%".. (not localhost or e-smith)
Now, I'm trying to open the page on my providers server but it's not working.. if the password is wrong I have some errors but if the password is right I doesnt do anything.. actually, it freezes..

I'm running 4.1.2.. any idea ?

Thanx

[Craig Foster]

I've found that the phpMyAdmin method of adding users seems inconsistant. If you read the mySQL docs about adding users manually, you might find it works.

In the past, adding users by hand in phpMyAdmin has only worked once...

If it turns out that there's a specific procedure to use in phpMyAdmin, please post.. I'd be greatly interested. Doing all this by hand seems overly complicated

Craig Foster

[WXP]

so could you tell me how to add a new user with all permissions and accessible from anywhere in the world ?

Thank you

[Noah]

WXP wrote:
>
> so could you tell me how to add a new user with all
> permissions and accessible from anywhere in the world ?
>

Not that I recommend you do this, but this is probably what you want:

GRANT ALL on *.* to someuser identified by "password";

Also, whenever you add a user or change persmissions, don't forget to issue a "flush privileges" (or, using phpMyAdmin, click on Reload MySQL).

A better option would be to SSH into your server and access MySQL from localhost.  

Noah

[Dan Brown]

I think you'd need a host spec in that command line--something like "someuser@*".  Not sure though; check the MySQL docs to make sure.

[AlecN]

I must admit I tried what you are attempting sometime ago with no success. If your database name is say (mydb), then issue the following MySQL statement

grant all on mydb.* to mydb@whateverhost identified by 'password';  (that's a semicolon on the end.)

[Noah]

Dan Brown wrote:
>
> I think you'd need a host spec in that command
> line--something like "someuser@*".  Not sure though; check
> the MySQL docs to make sure.

If you don't specify a host, then MySQL allows access from any host.  Omitting the host or using @% should be equivalent.  

Noah