PHP SQL - create dbs from another ip???

Author

create dbs from another ip???

mojar

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

steve1084@gmail.com

2006-02-23, 6:59 pm

My advice would be to contact the support for your host provider,
sounds like something has gone wrong on the server.
Who is the host provider.

mojar wrote:
> 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

Sponsored Links