mysqladmin: connect to server at 'localhost' failed

[infinite_root]

Hi Gurus out there,

I am trying to configure phpopenchat. An error appeared as follows:

A database (tablespace) with name "poc" could not be found!

I checked the dialog box create this database (tablespace)!
Choose one of the existent databases (tablespaces):

So I try creating poc database using the ff:

# mysqladmin create poc
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

However, I can open my database using:
# mysql -u root mysql -p
without any problem.

What could be the problem?

Also, anyone here had a successful installation of phpopenchat? Anyone care to point me to the right direction to accomplish it's installation? There's no available Installation manual translated in English

I know this isn't the right forum. But no one was attending my question at sourceforge.

Iam a little to late in accomplishing our project. Hope you can help me

Thanks and more power to all.

[redhead]

I havn't tried phpopenchat, but the error you're getting is because you didn't tell mysqladmin that you wanted the 'poc' created in the "tablespace" database.
Then just do it the old fasion way..

~> mysql -u root -p tablespace
 Enter password: ********* # roots password
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A

 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 12707 to server version: 3.23.49-log

 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 mysql> CREATE TABLE poc ( id INT DEFAULT '0' NOT NULL ); # What ever poc should be holding
 Query OK, 0 rows affected (0.10 sec)
 mysql> quit;
 Bye
~>

But that would require you to know exactly which columns this 'poc' should take care of, itg should be listed in the database dump filed that came with phpopenchat, altho if this is the case, 'poc' should have been created when you told mysql to read that file as your "tablespace" design.

[infinite_root]

Thanks for the reply. I got it running.

More power.

[Admin]

there was some type of PHP chat program that had some nasty bugs in it. i don't recall what it was, you may want to look into this before making your chat live.