Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: WXP on October 28, 2001, 03:21:52 AM

Title: MySQL
Post by: WXP on October 28, 2001, 03:21:52 AM

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

Title: Re: MySQL
Post by: Craig Foster on October 28, 2001, 04:34:35 PM

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

Title: Re: MySQL
Post by: WXP on October 28, 2001, 07:11:43 PM

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

Thank you

Title: Re: MySQL
Post by: Noah on October 29, 2001, 09:49:42 PM

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

Title: Re: MySQL
Post by: Dan Brown on October 29, 2001, 09:54:25 PM

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.

Title: Re: MySQL
Post by: AlecN on October 30, 2001, 03:51:51 AM

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.)

Title: Re: MySQL
Post by: Noah on November 01, 2001, 06:28:17 PM

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