Question

How can I know my database informations?

Hi,

I searched this all day long and I couldn’t find anything on phpmyadmin or webmin.

I’m searching;

$dbhost = “”; $dbuser = “”; $dbpass = “”; $dbname = “t”; $display_errors = false;

these informations.

I’m new on vps so please help me.

Subscribe
Share

What type of droplet did you create? If you created a PHPMyAdmin server you can find the mysql root password in the MOTD displayed when you log in via ssh. In that case the settings would be:

$dbhost=“localhost” (assuming that the web app is running on the same server as your database) $dbuesr=“root” $dbpass="Password displayed in MOTD $dbname=“name of the database you created

My droplet: 512MB Ram 20GB SSD Disk Amsterdam 3 Ubuntu 14.04 x64 I created phpmyadmin server in droplet but I never created a ssh password because I didn’t know it’s necessary for dbpass. And I don’t know what is motd. What should I do in that case now?

This comment has been deleted


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

If you installed phpmyadmin using apt-get then your mySQL Server should be installed with the user root and no password.

If you installed manually by downloading the phpmyadmin files and installed on a web server you will need to install mySQL.

apt-get install mysql-server

then run

/etc/init.d/mysql start

this will start your mySQL Server. Your connection details will be

User : root Password : <blank> Hostname: localhost Port : 3306

You can create a database by running

mysqladmin create <dbname>

Once you have done this your config should look like this

$dbhost = “localhost”; $dbuser = “root”; $dbpass = “”; $dbname = “<dbname from above>”; $display_errors = false;

I highly recommend you set a root password on mySQL however and never run queries as root unless creating new databases or adding users.