Posted by jarah.mo on 02/24/06 00:07

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

• Next in forum: create dbs from another ip???
• Prev in forum: Re: Using PHP to Connect to a Remote MySQL Server
• Thread view: create database from another ip?

[Reply to this message]