mysql ip adress

[serdas]

hi,
i finally learned how to install mysql and phpmyadmin
but now i need to find out the ip adress for the specific datebese

i can login IP/phpMyAdmin

but i need an ip adress instead of "IP/phpMyAdmin"
can you please help me?

$dbH = "ip";
$dbU = "user";
$dbP = "password";
$dbD = "database";

[fobos]

its your localhost. Either 127.0.0.1 or your computer IP address

[serdas]

ok but i think i might have some other issue first

thru ssh how can i find how many users and databases i have and the passwords other then the root?
i cannot seem to login anymore with the user i created maybe that's why i am getting below error?

JavaScriptException occured while calling pluginInit: org.apache.commons.dbcp.DbcpException: java.sql.SQLException: null,  message from server: "Host 'serveripadress' is not allowed to connect to this MySQL server"

[serdas]

i can get into the database and the user thru ssh but not thru the myphpadmin

why could that be?

thank you

[simplypixie]

That is an issue you need to take up with your hosting provider.

[serdas]

what would this mean? this happens on client side when i put either as an ip
thank you Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

its your localhost. Either 127.0.0.1 or your computer IP address

[manojsamtani]

plz answer following:

1) Are you able to access using user name from where the mysql server is located
2) Post the output of following from mysql server : use mysql; select user,host from user;
3) If step 2) showing the appropriate user and IP (client) then run following from client/application server : nmap -P0 mysqlserverIP

And find out if port 3306 is opened and accessible

SPAM DELETED