Getting thru the MySQL Admin screen

[SysEnvir]

Hi!

Can somebody please help with the MySQL Admin screen, which asks for a Server Hostname (?) and gives a port #. Whilst I am not in a position to question the port number, the Hostname is unknown to me. What should I put there?

Furthermore, I have installed Postgresql from the SPM, but although the blurb i the SPM says its a fully featured etc it has just disappeared from sight. Should I be trying to link tp postgresql using MySQL. I am old Access hand and this host name business is rather new to me.

I a nutshell, how do I fire up MySQL, please? I've tried the MySQL website and found myself engulfed in corporate license blurb.......

[barriehie]

In a terminal enter:

Code: Select all

hostname


Barrie

[x00r]

If you whish to use MySQL (as database server) at your own computer, install it first.

Code: Select all

apt-get update && apt-get install mysql-server

After this, set a mysql-root password

Code: Select all

mysql_secure_installation

After this, install some front end like PhpMyAdmin in this case, you do not have to set hostname or port. Default it should fallback to localhost or 127.0.0.1 and port 3306.