PHP SQL - create database from another ip?

Author

create database from another ip?

jarah.mo@gmail.com

2006-02-23, 6:59 pm

I have created a username giving GRANT ALL ON *.* TO privileges...
I also did FLUSH PRIVILEGES, but this doesn't seem to change anything
either...

I have a wordpress blog on another ip that I am trying to install- it
does make the connection, but won't allow the user to create the
database/tables.

This is what it spits out:

[Access denied for user 'xxx'@'xxx.xxx.xxx.x' to database 'xxxx']
CREATE TABLE wp_categories ( cat_ID bigint(20) NOT NULL auto_increment,
cat_name varchar(55) NOT NULL default '', category_nicename
varchar(200) NOT NULL default '', category_description longtext NOT
NULL, category_parent bigint(20) NOT NULL default '0', category_count
bigint(20) NOT NULL default '0', PRIMARY KEY (cat_ID), KEY
category_nicename (category_nicename) )

and then another 76 pages of similar errors.

any ideas on what I might be missing on the mySQL side?
Other auto-installs such as joomla do the same thing.

Thanks!
mojar

J.O. Aho

2006-02-23, 6:59 pm

jarah.mo@gmail.com wrote: Re: create database from another ip?
mojar wrote: Re: create dbs from another ip???

Two threads with the same content? Feels like you are a bad multiposter, if
you want to ask the same question at more than one newsgroup (with good
netiquette, max 4-5), then crosspost (one post with multiple newsgroups: ).

> I have created a username giving GRANT ALL ON *.* TO privileges...
> I also did FLUSH PRIVILEGES, but this doesn't seem to change anything
> either...

GRANT ALL ON *.* TO 'username'@'remotehost' ...

You need to change the remotehost to the ip-name that the server where thinks
the webserver is called.

Eg, you have your mysql server on example.net and you have your webpage on
content.locator.metadata.windowsmedia.com (host gives the ip-number to
207.46.248.247).

On example.net run 'host 207.46.248.247' and see what you get as result,
should be content.locator.metadata.windowsmedia.com.

Now in your GRANT statement you should use
content.locator.metadata.windowsmedia.com, as the remote address.

GRANT ALL ON *.* TO 'username'@'content.locator.metadata.windowsmedia.com' ...

In some cases it can be to have two GRANTs, one for the ip-name and one for
the ip-number.

GRANT ALL ON *.* TO 'username'@'content.locator.metadata.windowsmedia.com' ...
GRANT ALL ON *.* TO 'username'@'207.46.248.247' ...

//Aho

mojar

2006-02-24, 6:58 pm

i'm not sure why you're so rude- as far as i know there is no call for
it- i don't even know you.... i posted to this group once- it said it
didn't post, so i reposted, and you're being nasty. not

.

"Two threads with the same content? Feels like you are a bad
multiposter, if
you want to ask the same question at more than one newsgroup (with good

netiquette, max 4-5), then crosspost (one post with multiple
newsgroups: )."

J.O. Aho

2006-02-24, 6:58 pm

mojar wrote:
> i'm not sure why you're so rude- as far as i know there is no call for
> it- i don't even know you.... i posted to this group once- it said it
> didn't post, so i reposted, and you're being nasty. not

.

You did post the same message on this newsgroup one minute apart

--- first ---
Subject: create database from another ip?
From: jarah.mo@gmail.com
Date: 23/02/06 23:07
Newsgroups: alt.php.sql
Organization: http://groups.google.com
Lines: 26
Message-ID: <1140732450.890705.76390@p10g2000cwp.googlegroups.com>
NNTP-Posting-Host: 204.141.205.16
--- eof ---

--- second ---
Subject: create dbs from another ip???
From: mojar <jarah.mo@gmail.com>
Date: 23/02/06 23:08
Newsgroups: alt.php.sql
Organization: http://groups.google.com
Lines: 26
Message-ID: <1140732496.590703.140510@u72g2000cwu.googlegroups.com>
NNTP-Posting-Host: 204.141.205.16
--- eof ---

The contents of the two posts are identical, with different subjects which
indicates you haven't been a happy trigger but have had an intent to post the
same message more than once. Multiposting is something that are highly
disliked by regular posters at newsgroups. http://www.dtcc.edu/cs/rfc1855.html

I'm sorry if I offended you, but when you notice that you made dubble posts
like this in the future, try to cancel one of them.

//Aho

Sponsored Links