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?
This question is related to
php
mysql
localhost
credentials
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.
type this command
select CURRENT_USER();
You will get the username and server
Default user for MySQL is "root", and server "localhost".
Source: Stackoverflow.com