0

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

4
Contributors
6
Replies
8
Views
5 Years
Discussion Span
Last Post by manojsamtani
0

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

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

why could that be?

thank you

0

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

0

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

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.