jdbc connect to nuke db - issues

[tracey]

hmm .. i'm stuck here ... i'm trying to run the command

GRANT ALL PRIVILEGES ON [dbname].* to '[user]'@'[hostname]' identified by '[password]';

with the proper dbname, username, hostname (localhost) and password -- no quotes except around password, no brackets (of course) and MySQL said:

#1044 - Access denied for user: user@localhost' to database 'dbname'

I've done this from SSH session logged in command line to mysql (and am connect to the database, with the username and password!!) and have also tried from phpMyAdmin ... both give me the same basic message over and over

i'm guessing that until i can get this step .. it won't itegrate into nuke .. HELLLPPP

it's a linux server .. running fedora core 1

thanks!
??? ??? ???
Trace

[imported_admin]

please checkout this page:

http://www.123flashchat.com/mysql_problem.html

if you still have problem, please contact our support team, we can provide the installation service for free. just send your installation request to : support@123flashchat.com , with your ssh account and server ip address.

[tracey]

thanks for getting back .. I hadn't found that doc ...

i'm logged in as root (from ssh) .. i run mysql -p -u [dbuser] -h 127.0.0.1 [dbname]
and get:

ERROR 1130: Host 'localhost.localdomain' is not allowed to connect to this MySQL server

however, if i do the same command , but instead put localhost instead of 127.0.0.1 it works -- but the commands still don't (grant all ...)

for some reason my sql root password isn't letting me log in, could be another issue. so i couldn't try doing it from root. I get "ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)" which makes me think the pw they gave me as mysql root isn't right ... ??? >

I ran "netstat -a | grep mysql" and got:

tcp        0      0 *:mysql                 *:*                     LISTEN
unix  2      [ ACC ]     STREAM     LISTENING     1508   /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     124963 /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     115372 /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     111169 /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     110992 /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     110924 /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     107198 /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     95927  /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     81538  /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     80203  /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     79581  /var/lib/mysql/mysql.sock
unix  3      [ ]         STREAM     CONNECTED     78398  /var/lib/mysql/mysql.sock

hmmm .. no 3306??

I also ran "netstat -a | grep 3306" and got nothing -- so is mysql not working on 3306?? what will or won't it do??

When I ran "telnet 127.0.0.1 3306" I get

Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
NHost 'localhost.localdomain' is not allowed to connect to this MySQL serverConnection closed by foreign host.

but hey .. foreign host?? i'm logged on locally as root -- not at console, via ssh

contents of /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

man, i just don't get it .. is it maybe a server configuration problem?? we're leasing this server .. and it still refers to itself as 'localhost.localdomain' .. even tho the /etc/sysconfig/network file has a host name ... (the server has been rebooted many times) -- then again, maybe it does that because the hosts file has an entry for itself on loopback and on physical IP and it's normal -- so maybe it's a non-issue and i'm babbleing.

any ideas to help??

of course, this could all be moot if the answer to the following question is NO ... can this client be configured to run on a hosting server, and host different chats to different domains on different instances of nuke?? ???

thanks in advance .. tracey

[imported_admin]

when you ran:

telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
NHost 'localhost.localdomain' is not allowed to connect to this MySQL serverConnection closed by foreign host.


that's mean the mysql is listening the port 3306.

OK, now the problem is: you have to login to your mysql with root account and execute the grant command.
but you can't login the mysql with root by this command:

mysql -p -u root

you forget the password or never create the root password ?

you can try this way to login the mysql:

first login to your linux with root:

$ su -
# mysql

can you login to the mysql now ?

if yes, please execute these commands:

mysql> GRANT ALL PRIVILEGES ON [dbname].* to [user]@127.0.0.1 identified by '[password]';
mysql> FLUSH PRIVILEGES;

replace the [dbname] with your database name.
replace the [user] with your database user name.
replace the [password] with your database password.
don't forget the last command: "FLUSH PRIVILEGES"

about the chat server and web server in diffrent servers, that's ok,
we host the chat server for a lot of phpnuke and postnuke users, we run the chat server,
and our customers have their web server, we use the "URL" to integrate the database, not JDBC.