How do I find my host and username on mysql?

Viewed 142491

I need to open my database through PHP. But I need to know my username and the name of my host (e.g. localhost), and I don't know them.

When I used mysql and did my database, it just asked me directly for a password.

How do I find my host and username on mysql?

5 Answers

Default user for MySQL is "root", and server "localhost".

You should be able to access the local database by using the name localhost. There is also a way to determine the hostname of the computer you're running on, but it doesn't sound like you need that. As for the username, you can either (1) give permissions to the account that PHP runs under to access the database without a password, or (2) store the username and password that you need to connect with (hard-coded or stored in a config file), and pass those as arguments to mysql_connect. See http://php.net/manual/en/function.mysql-connect.php.

This is how you can open MySQL shell

\connect root@localhost:3306

Related