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";

6 Years
Discussion Span
Last Post by manojsamtani

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"

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

why could that be?

thank you


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 or your computer IP address


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


Edited by happygeek: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.