CODEWITHSUNDEEP
mysql
acctman
acctman

Reputation: 4349

MySQL how to find host and user info?

how do I find out what my database hostname and user login is? I've tried localhost and root@localhost but no success.

Failed to connect to database host.domain.com:3306 user:root. Please check the database settings you provided and verify that MySQL is up and running.

Upvotes: 0

Views: 1048

Answers (1)

D Mac
D Mac

Reputation: 3809

Assuming that mysql is running and you have credentials that work, you can get all the host and user information from the mysql database once you are running mysql successfully - "select User,Host from mysql.user" for example.

But, it looks like your problem is that you can't log into mysql.

If you don't have a valid credentials to your own database, one has to wonder how you managed to lose them. That happens, however, and the way to reset those credentials is described in detail at http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html.

Upvotes: 1

Related Questions