Member Avatar for 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";

  • 4 Contributors
  • 6 Replies
  • 193 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by manojsamtani
Member Avatar for fobos

its your localhost. Either 127.0.0.1 or your computer IP address

Member Avatar for 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"
Member Avatar for serdas

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

why could that be?

thank you

Member Avatar for simplypixie

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

Member Avatar for 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

Member Avatar for 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

Edited by happygeek because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.